Oracle Cloud Infrastructure v2.31.0, Apr 17 25

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

oci.DataSafe.getTargetDatabasesColumns

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

Example Usage

TypeScript
Python
Go
C#
Java
YAML

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/v2/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.

TypeScript
Python
Go
C#
Java
YAML

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)
public static Output<GetTargetDatabasesColumnsResult> getTargetDatabasesColumns(GetTargetDatabasesColumnsArgs args, InvokeOptions options)

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.

Oracle Cloud Infrastructure v2.31.0 published on Thursday, Apr 17, 2025 by Pulumi

pulumi/pulumi-oci

oci.DataSafe.getTargetDatabasesColumns

On this page

On this page

Example Usage

Using getTargetDatabasesColumns

getTargetDatabasesColumns Result

Supporting Types

GetTargetDatabasesColumnsColumn

GetTargetDatabasesColumnsFilter

Package Details

On this page

On this page