Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
oci.DataSafe.getTargetDatabasesColumns
Start a Neo task
Explain and create an oci.DataSafe.getTargetDatabasesColumns resource
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/v3/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[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[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 dictionaryThe following arguments are supported:
- Target
Database stringId - The OCID of the Data Safe target database.
- Column
Name stringContains - A filter to return only items if column name contains a specific string.
- Column
Names 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<Get
Target Databases Columns Filter> - Schema
Name stringContains - A filter to return only items if schema name contains a specific string.
- Schema
Names List<string> - A filter to return only items related to specific schema name.
- Table
Name stringContains - A filter to return only items if table name contains a specific string.
- Table
Names List<string> - A filter to return only items related to specific table name.
- Target
Database stringId - The OCID of the Data Safe target database.
- Column
Name stringContains - A filter to return only items if column name contains a specific string.
- Column
Names []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
[]Get
Target Databases Columns Filter - Schema
Name stringContains - A filter to return only items if schema name contains a specific string.
- Schema
Names []string - A filter to return only items related to specific schema name.
- Table
Name stringContains - A filter to return only items if table name contains a specific string.
- Table
Names []string - A filter to return only items related to specific table name.
- target
Database StringId - The OCID of the Data Safe target database.
- column
Name StringContains - A filter to return only items if column name contains a specific string.
- column
Names 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<Get
Target Databases Columns Filter> - schema
Name StringContains - A filter to return only items if schema name contains a specific string.
- schema
Names List<String> - A filter to return only items related to specific schema name.
- table
Name StringContains - A filter to return only items if table name contains a specific string.
- table
Names List<String> - A filter to return only items related to specific table name.
- target
Database stringId - The OCID of the Data Safe target database.
- column
Name stringContains - A filter to return only items if column name contains a specific string.
- column
Names 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
Get
Target Databases Columns Filter[] - schema
Name stringContains - A filter to return only items if schema name contains a specific string.
- schema
Names string[] - A filter to return only items related to specific schema name.
- table
Name stringContains - A filter to return only items if table name contains a specific string.
- table
Names string[] - A filter to return only items related to specific table name.
- target_
database_ strid - The OCID of the Data Safe target database.
- column_
name_ strcontains - 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[Get
Target Databases Columns Filter] - schema_
name_ strcontains - 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_ strcontains - 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.
- target
Database StringId - The OCID of the Data Safe target database.
- column
Name StringContains - A filter to return only items if column name contains a specific string.
- column
Names 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>
- schema
Name StringContains - A filter to return only items if schema name contains a specific string.
- schema
Names List<String> - A filter to return only items related to specific schema name.
- table
Name StringContains - A filter to return only items if table name contains a specific string.
- table
Names List<String> - A filter to return only items related to specific table name.
getTargetDatabasesColumns Result
The following output properties are available:
- Columns
List<Get
Target Databases Columns Column> - The list of columns.
- Id string
- The provider-assigned unique ID for this managed resource.
- Target
Database stringId - Column
Name stringContains - Column
Names List<string> - Name of the column.
- Datatypes List<string>
- Filters
List<Get
Target Databases Columns Filter> - Schema
Name stringContains - Schema
Names List<string> - Name of the schema.
- Table
Name stringContains - Table
Names List<string> - Name of the table.
- Columns
[]Get
Target Databases Columns Column - The list of columns.
- Id string
- The provider-assigned unique ID for this managed resource.
- Target
Database stringId - Column
Name stringContains - Column
Names []string - Name of the column.
- Datatypes []string
- Filters
[]Get
Target Databases Columns Filter - Schema
Name stringContains - Schema
Names []string - Name of the schema.
- Table
Name stringContains - Table
Names []string - Name of the table.
- columns
List<Get
Target Databases Columns Column> - The list of columns.
- id String
- The provider-assigned unique ID for this managed resource.
- target
Database StringId - column
Name StringContains - column
Names List<String> - Name of the column.
- datatypes List<String>
- filters
List<Get
Target Databases Columns Filter> - schema
Name StringContains - schema
Names List<String> - Name of the schema.
- table
Name StringContains - table
Names List<String> - Name of the table.
- columns
Get
Target Databases Columns Column[] - The list of columns.
- id string
- The provider-assigned unique ID for this managed resource.
- target
Database stringId - column
Name stringContains - column
Names string[] - Name of the column.
- datatypes string[]
- filters
Get
Target Databases Columns Filter[] - schema
Name stringContains - schema
Names string[] - Name of the schema.
- table
Name stringContains - table
Names string[] - Name of the table.
- columns
Sequence[Get
Target Databases Columns Column] - The list of columns.
- id str
- The provider-assigned unique ID for this managed resource.
- target_
database_ strid - column_
name_ strcontains - column_
names Sequence[str] - Name of the column.
- datatypes Sequence[str]
- filters
Sequence[Get
Target Databases Columns Filter] - schema_
name_ strcontains - schema_
names Sequence[str] - Name of the schema.
- table_
name_ strcontains - 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.
- target
Database StringId - column
Name StringContains - column
Names List<String> - Name of the column.
- datatypes List<String>
- filters List<Property Map>
- schema
Name StringContains - schema
Names List<String> - Name of the schema.
- table
Name StringContains - table
Names List<String> - Name of the table.
Supporting Types
GetTargetDatabasesColumnsColumn
- Character
Length int - Character length.
- Column
Name string - A filter to return only a specific column based on column name.
- Data
Type 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.
- Schema
Name string - A filter to return only items related to specific schema name.
- Table
Name string - A filter to return only items related to specific table name.
- Character
Length int - Character length.
- Column
Name string - A filter to return only a specific column based on column name.
- Data
Type 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.
- Schema
Name string - A filter to return only items related to specific schema name.
- Table
Name string - A filter to return only items related to specific table name.
- character
Length Integer - Character length.
- column
Name String - A filter to return only a specific column based on column name.
- data
Type 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.
- schema
Name String - A filter to return only items related to specific schema name.
- table
Name String - A filter to return only items related to specific table name.
- character
Length number - Character length.
- column
Name string - A filter to return only a specific column based on column name.
- data
Type 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.
- schema
Name string - A filter to return only items related to specific schema name.
- table
Name 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.
- character
Length Number - Character length.
- column
Name String - A filter to return only a specific column based on column name.
- data
Type 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.
- schema
Name String - A filter to return only items related to specific schema name.
- table
Name String - A filter to return only items related to specific table name.
GetTargetDatabasesColumnsFilter
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
ociTerraform Provider.
