1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getTargetDatabasesColumns
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

oci.DataSafe.getTargetDatabasesColumns

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi

    This data source provides the list of Target Databases Columns in Oracle Cloud Infrastructure Data Safe service.

    Returns a list of column metadata objects.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testTargetDatabasesColumns = oci.DataSafe.getTargetDatabasesColumns({
        targetDatabaseId: testTargetDatabase.id,
        columnNames: targetDatabasesColumnColumnName,
        columnNameContains: targetDatabasesColumnColumnNameContains,
        datatypes: targetDatabasesColumnDatatype,
        schemaNames: targetDatabasesColumnSchemaName,
        schemaNameContains: targetDatabasesColumnSchemaNameContains,
        tableNames: testTable.name,
        tableNameContains: targetDatabasesColumnTableNameContains,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_target_databases_columns = oci.DataSafe.get_target_databases_columns(target_database_id=test_target_database["id"],
        column_names=target_databases_column_column_name,
        column_name_contains=target_databases_column_column_name_contains,
        datatypes=target_databases_column_datatype,
        schema_names=target_databases_column_schema_name,
        schema_name_contains=target_databases_column_schema_name_contains,
        table_names=test_table["name"],
        table_name_contains=target_databases_column_table_name_contains)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/DataSafe"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DataSafe.GetTargetDatabasesColumns(ctx, &datasafe.GetTargetDatabasesColumnsArgs{
    			TargetDatabaseId:   testTargetDatabase.Id,
    			ColumnNames:        targetDatabasesColumnColumnName,
    			ColumnNameContains: pulumi.StringRef(targetDatabasesColumnColumnNameContains),
    			Datatypes:          targetDatabasesColumnDatatype,
    			SchemaNames:        targetDatabasesColumnSchemaName,
    			SchemaNameContains: pulumi.StringRef(targetDatabasesColumnSchemaNameContains),
    			TableNames:         testTable.Name,
    			TableNameContains:  pulumi.StringRef(targetDatabasesColumnTableNameContains),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testTargetDatabasesColumns = Oci.DataSafe.GetTargetDatabasesColumns.Invoke(new()
        {
            TargetDatabaseId = testTargetDatabase.Id,
            ColumnNames = targetDatabasesColumnColumnName,
            ColumnNameContains = targetDatabasesColumnColumnNameContains,
            Datatypes = targetDatabasesColumnDatatype,
            SchemaNames = targetDatabasesColumnSchemaName,
            SchemaNameContains = targetDatabasesColumnSchemaNameContains,
            TableNames = testTable.Name,
            TableNameContains = targetDatabasesColumnTableNameContains,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DataSafe.DataSafeFunctions;
    import com.pulumi.oci.DataSafe.inputs.GetTargetDatabasesColumnsArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var testTargetDatabasesColumns = DataSafeFunctions.getTargetDatabasesColumns(GetTargetDatabasesColumnsArgs.builder()
                .targetDatabaseId(testTargetDatabase.id())
                .columnNames(targetDatabasesColumnColumnName)
                .columnNameContains(targetDatabasesColumnColumnNameContains)
                .datatypes(targetDatabasesColumnDatatype)
                .schemaNames(targetDatabasesColumnSchemaName)
                .schemaNameContains(targetDatabasesColumnSchemaNameContains)
                .tableNames(testTable.name())
                .tableNameContains(targetDatabasesColumnTableNameContains)
                .build());
    
        }
    }
    
    variables:
      testTargetDatabasesColumns:
        fn::invoke:
          Function: oci:DataSafe:getTargetDatabasesColumns
          Arguments:
            targetDatabaseId: ${testTargetDatabase.id}
            columnNames: ${targetDatabasesColumnColumnName}
            columnNameContains: ${targetDatabasesColumnColumnNameContains}
            datatypes: ${targetDatabasesColumnDatatype}
            schemaNames: ${targetDatabasesColumnSchemaName}
            schemaNameContains: ${targetDatabasesColumnSchemaNameContains}
            tableNames: ${testTable.name}
            tableNameContains: ${targetDatabasesColumnTableNameContains}
    

    Using getTargetDatabasesColumns

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getTargetDatabasesColumns(args: GetTargetDatabasesColumnsArgs, opts?: InvokeOptions): Promise<GetTargetDatabasesColumnsResult>
    function getTargetDatabasesColumnsOutput(args: GetTargetDatabasesColumnsOutputArgs, opts?: InvokeOptions): Output<GetTargetDatabasesColumnsResult>
    def get_target_databases_columns(column_name_contains: Optional[str] = None,
                                     column_names: Optional[Sequence[str]] = None,
                                     datatypes: Optional[Sequence[str]] = None,
                                     filters: Optional[Sequence[_datasafe.GetTargetDatabasesColumnsFilter]] = None,
                                     schema_name_contains: Optional[str] = None,
                                     schema_names: Optional[Sequence[str]] = None,
                                     table_name_contains: Optional[str] = None,
                                     table_names: Optional[Sequence[str]] = None,
                                     target_database_id: Optional[str] = None,
                                     opts: Optional[InvokeOptions] = None) -> GetTargetDatabasesColumnsResult
    def get_target_databases_columns_output(column_name_contains: Optional[pulumi.Input[str]] = None,
                                     column_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                     datatypes: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                     filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetTargetDatabasesColumnsFilterArgs]]]] = None,
                                     schema_name_contains: Optional[pulumi.Input[str]] = None,
                                     schema_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                     table_name_contains: Optional[pulumi.Input[str]] = None,
                                     table_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                     target_database_id: Optional[pulumi.Input[str]] = None,
                                     opts: Optional[InvokeOptions] = None) -> Output[GetTargetDatabasesColumnsResult]
    func GetTargetDatabasesColumns(ctx *Context, args *GetTargetDatabasesColumnsArgs, opts ...InvokeOption) (*GetTargetDatabasesColumnsResult, error)
    func GetTargetDatabasesColumnsOutput(ctx *Context, args *GetTargetDatabasesColumnsOutputArgs, opts ...InvokeOption) GetTargetDatabasesColumnsResultOutput

    > Note: This function is named GetTargetDatabasesColumns in the Go SDK.

    public static class GetTargetDatabasesColumns 
    {
        public static Task<GetTargetDatabasesColumnsResult> InvokeAsync(GetTargetDatabasesColumnsArgs args, InvokeOptions? opts = null)
        public static Output<GetTargetDatabasesColumnsResult> Invoke(GetTargetDatabasesColumnsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetTargetDatabasesColumnsResult> getTargetDatabasesColumns(GetTargetDatabasesColumnsArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DataSafe/getTargetDatabasesColumns:getTargetDatabasesColumns
      arguments:
        # arguments dictionary

    The following arguments are supported:

    TargetDatabaseId string
    The OCID of the Data Safe target database.
    ColumnNameContains string
    A filter to return only items if column name contains a specific string.
    ColumnNames List<string>
    A filter to return only a specific column based on column name.
    Datatypes List<string>
    A filter to return only items related to specific datatype.
    Filters List<GetTargetDatabasesColumnsFilter>
    SchemaNameContains string
    A filter to return only items if schema name contains a specific string.
    SchemaNames List<string>
    A filter to return only items related to specific schema name.
    TableNameContains string
    A filter to return only items if table name contains a specific string.
    TableNames List<string>
    A filter to return only items related to specific table name.
    TargetDatabaseId string
    The OCID of the Data Safe target database.
    ColumnNameContains string
    A filter to return only items if column name contains a specific string.
    ColumnNames []string
    A filter to return only a specific column based on column name.
    Datatypes []string
    A filter to return only items related to specific datatype.
    Filters []GetTargetDatabasesColumnsFilter
    SchemaNameContains string
    A filter to return only items if schema name contains a specific string.
    SchemaNames []string
    A filter to return only items related to specific schema name.
    TableNameContains string
    A filter to return only items if table name contains a specific string.
    TableNames []string
    A filter to return only items related to specific table name.
    targetDatabaseId String
    The OCID of the Data Safe target database.
    columnNameContains String
    A filter to return only items if column name contains a specific string.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    datatypes List<String>
    A filter to return only items related to specific datatype.
    filters List<GetTargetDatabasesColumnsFilter>
    schemaNameContains String
    A filter to return only items if schema name contains a specific string.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    tableNameContains String
    A filter to return only items if table name contains a specific string.
    tableNames List<String>
    A filter to return only items related to specific table name.
    targetDatabaseId string
    The OCID of the Data Safe target database.
    columnNameContains string
    A filter to return only items if column name contains a specific string.
    columnNames string[]
    A filter to return only a specific column based on column name.
    datatypes string[]
    A filter to return only items related to specific datatype.
    filters GetTargetDatabasesColumnsFilter[]
    schemaNameContains string
    A filter to return only items if schema name contains a specific string.
    schemaNames string[]
    A filter to return only items related to specific schema name.
    tableNameContains string
    A filter to return only items if table name contains a specific string.
    tableNames string[]
    A filter to return only items related to specific table name.
    target_database_id str
    The OCID of the Data Safe target database.
    column_name_contains str
    A filter to return only items if column name contains a specific string.
    column_names Sequence[str]
    A filter to return only a specific column based on column name.
    datatypes Sequence[str]
    A filter to return only items related to specific datatype.
    filters Sequence[datasafe.GetTargetDatabasesColumnsFilter]
    schema_name_contains str
    A filter to return only items if schema name contains a specific string.
    schema_names Sequence[str]
    A filter to return only items related to specific schema name.
    table_name_contains str
    A filter to return only items if table name contains a specific string.
    table_names Sequence[str]
    A filter to return only items related to specific table name.
    targetDatabaseId String
    The OCID of the Data Safe target database.
    columnNameContains String
    A filter to return only items if column name contains a specific string.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    datatypes List<String>
    A filter to return only items related to specific datatype.
    filters List<Property Map>
    schemaNameContains String
    A filter to return only items if schema name contains a specific string.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    tableNameContains String
    A filter to return only items if table name contains a specific string.
    tableNames List<String>
    A filter to return only items related to specific table name.

    getTargetDatabasesColumns Result

    The following output properties are available:

    Columns List<GetTargetDatabasesColumnsColumn>
    The list of columns.
    Id string
    The provider-assigned unique ID for this managed resource.
    TargetDatabaseId string
    ColumnNameContains string
    ColumnNames List<string>
    Name of the column.
    Datatypes List<string>
    Filters List<GetTargetDatabasesColumnsFilter>
    SchemaNameContains string
    SchemaNames List<string>
    Name of the schema.
    TableNameContains string
    TableNames List<string>
    Name of the table.
    Columns []GetTargetDatabasesColumnsColumn
    The list of columns.
    Id string
    The provider-assigned unique ID for this managed resource.
    TargetDatabaseId string
    ColumnNameContains string
    ColumnNames []string
    Name of the column.
    Datatypes []string
    Filters []GetTargetDatabasesColumnsFilter
    SchemaNameContains string
    SchemaNames []string
    Name of the schema.
    TableNameContains string
    TableNames []string
    Name of the table.
    columns List<GetTargetDatabasesColumnsColumn>
    The list of columns.
    id String
    The provider-assigned unique ID for this managed resource.
    targetDatabaseId String
    columnNameContains String
    columnNames List<String>
    Name of the column.
    datatypes List<String>
    filters List<GetTargetDatabasesColumnsFilter>
    schemaNameContains String
    schemaNames List<String>
    Name of the schema.
    tableNameContains String
    tableNames List<String>
    Name of the table.
    columns GetTargetDatabasesColumnsColumn[]
    The list of columns.
    id string
    The provider-assigned unique ID for this managed resource.
    targetDatabaseId string
    columnNameContains string
    columnNames string[]
    Name of the column.
    datatypes string[]
    filters GetTargetDatabasesColumnsFilter[]
    schemaNameContains string
    schemaNames string[]
    Name of the schema.
    tableNameContains string
    tableNames string[]
    Name of the table.
    columns Sequence[datasafe.GetTargetDatabasesColumnsColumn]
    The list of columns.
    id str
    The provider-assigned unique ID for this managed resource.
    target_database_id str
    column_name_contains str
    column_names Sequence[str]
    Name of the column.
    datatypes Sequence[str]
    filters Sequence[datasafe.GetTargetDatabasesColumnsFilter]
    schema_name_contains str
    schema_names Sequence[str]
    Name of the schema.
    table_name_contains str
    table_names Sequence[str]
    Name of the table.
    columns List<Property Map>
    The list of columns.
    id String
    The provider-assigned unique ID for this managed resource.
    targetDatabaseId String
    columnNameContains String
    columnNames List<String>
    Name of the column.
    datatypes List<String>
    filters List<Property Map>
    schemaNameContains String
    schemaNames List<String>
    Name of the schema.
    tableNameContains String
    tableNames List<String>
    Name of the table.

    Supporting Types

    GetTargetDatabasesColumnsColumn

    CharacterLength int
    Character length.
    ColumnName string
    A filter to return only a specific column based on column name.
    DataType string
    Data type of the column.
    Length string
    Length of the data represented by the column.
    Precision int
    Precision of the column.
    Scale int
    Scale of the column.
    SchemaName string
    A filter to return only items related to specific schema name.
    TableName string
    A filter to return only items related to specific table name.
    CharacterLength int
    Character length.
    ColumnName string
    A filter to return only a specific column based on column name.
    DataType string
    Data type of the column.
    Length string
    Length of the data represented by the column.
    Precision int
    Precision of the column.
    Scale int
    Scale of the column.
    SchemaName string
    A filter to return only items related to specific schema name.
    TableName string
    A filter to return only items related to specific table name.
    characterLength Integer
    Character length.
    columnName String
    A filter to return only a specific column based on column name.
    dataType String
    Data type of the column.
    length String
    Length of the data represented by the column.
    precision Integer
    Precision of the column.
    scale Integer
    Scale of the column.
    schemaName String
    A filter to return only items related to specific schema name.
    tableName String
    A filter to return only items related to specific table name.
    characterLength number
    Character length.
    columnName string
    A filter to return only a specific column based on column name.
    dataType string
    Data type of the column.
    length string
    Length of the data represented by the column.
    precision number
    Precision of the column.
    scale number
    Scale of the column.
    schemaName string
    A filter to return only items related to specific schema name.
    tableName string
    A filter to return only items related to specific table name.
    character_length int
    Character length.
    column_name str
    A filter to return only a specific column based on column name.
    data_type str
    Data type of the column.
    length str
    Length of the data represented by the column.
    precision int
    Precision of the column.
    scale int
    Scale of the column.
    schema_name str
    A filter to return only items related to specific schema name.
    table_name str
    A filter to return only items related to specific table name.
    characterLength Number
    Character length.
    columnName String
    A filter to return only a specific column based on column name.
    dataType String
    Data type of the column.
    length String
    Length of the data represented by the column.
    precision Number
    Precision of the column.
    scale Number
    Scale of the column.
    schemaName String
    A filter to return only items related to specific schema name.
    tableName String
    A filter to return only items related to specific table name.

    GetTargetDatabasesColumnsFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi