Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getTargetDatabasesTables
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getTargetDatabasesTables

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

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

    Returns a list of table metadata objects.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testTargetDatabasesTables = oci.DataSafe.getTargetDatabasesTables({
    targetDatabaseId: testTargetDatabase.id,
    schemaNames: targetDatabasesTableSchemaName,
    schemaNameContains: targetDatabasesTableSchemaNameContains,
    tableNames: testTable.name,
    tableNameContains: targetDatabasesTableTableNameContains,
});

    import pulumi
import pulumi_oci as oci

test_target_databases_tables = oci.DataSafe.get_target_databases_tables(target_database_id=test_target_database["id"],
    schema_names=target_databases_table_schema_name,
    schema_name_contains=target_databases_table_schema_name_contains,
    table_names=test_table["name"],
    table_name_contains=target_databases_table_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.GetTargetDatabasesTables(ctx, &datasafe.GetTargetDatabasesTablesArgs{
			TargetDatabaseId:   testTargetDatabase.Id,
			SchemaNames:        targetDatabasesTableSchemaName,
			SchemaNameContains: pulumi.StringRef(targetDatabasesTableSchemaNameContains),
			TableNames:         testTable.Name,
			TableNameContains:  pulumi.StringRef(targetDatabasesTableTableNameContains),
		}, 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 testTargetDatabasesTables = Oci.DataSafe.GetTargetDatabasesTables.Invoke(new()
    {
        TargetDatabaseId = testTargetDatabase.Id,
        SchemaNames = targetDatabasesTableSchemaName,
        SchemaNameContains = targetDatabasesTableSchemaNameContains,
        TableNames = testTable.Name,
        TableNameContains = targetDatabasesTableTableNameContains,
    });

});

    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.GetTargetDatabasesTablesArgs;
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 testTargetDatabasesTables = DataSafeFunctions.getTargetDatabasesTables(GetTargetDatabasesTablesArgs.builder()
            .targetDatabaseId(testTargetDatabase.id())
            .schemaNames(targetDatabasesTableSchemaName)
            .schemaNameContains(targetDatabasesTableSchemaNameContains)
            .tableNames(testTable.name())
            .tableNameContains(targetDatabasesTableTableNameContains)
            .build());

    }
}

    variables:
  testTargetDatabasesTables:
    fn::invoke:
      function: oci:DataSafe:getTargetDatabasesTables
      arguments:
        targetDatabaseId: ${testTargetDatabase.id}
        schemaNames: ${targetDatabasesTableSchemaName}
        schemaNameContains: ${targetDatabasesTableSchemaNameContains}
        tableNames: ${testTable.name}
        tableNameContains: ${targetDatabasesTableTableNameContains}

    Using getTargetDatabasesTables

    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 getTargetDatabasesTables(args: GetTargetDatabasesTablesArgs, opts?: InvokeOptions): Promise<GetTargetDatabasesTablesResult>
function getTargetDatabasesTablesOutput(args: GetTargetDatabasesTablesOutputArgs, opts?: InvokeOptions): Output<GetTargetDatabasesTablesResult>
    def get_target_databases_tables(filters: Optional[Sequence[GetTargetDatabasesTablesFilter]] = 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) -> GetTargetDatabasesTablesResult
def get_target_databases_tables_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetTargetDatabasesTablesFilterArgs]]]] = 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[GetTargetDatabasesTablesResult]
    func GetTargetDatabasesTables(ctx *Context, args *GetTargetDatabasesTablesArgs, opts ...InvokeOption) (*GetTargetDatabasesTablesResult, error)
func GetTargetDatabasesTablesOutput(ctx *Context, args *GetTargetDatabasesTablesOutputArgs, opts ...InvokeOption) GetTargetDatabasesTablesResultOutput

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

    public static class GetTargetDatabasesTables 
{
    public static Task<GetTargetDatabasesTablesResult> InvokeAsync(GetTargetDatabasesTablesArgs args, InvokeOptions? opts = null)
    public static Output<GetTargetDatabasesTablesResult> Invoke(GetTargetDatabasesTablesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetTargetDatabasesTablesResult> getTargetDatabasesTables(GetTargetDatabasesTablesArgs args, InvokeOptions options)
public static Output<GetTargetDatabasesTablesResult> getTargetDatabasesTables(GetTargetDatabasesTablesArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DataSafe/getTargetDatabasesTables:getTargetDatabasesTables
  arguments:
    # arguments dictionary

    The following arguments are supported:

    TargetDatabaseId string
    The OCID of the Data Safe target database.
    Filters List<GetTargetDatabasesTablesFilter>
    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.
    Filters []GetTargetDatabasesTablesFilter
    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.
    filters List<GetTargetDatabasesTablesFilter>
    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.
    filters GetTargetDatabasesTablesFilter[]
    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.
    filters Sequence[GetTargetDatabasesTablesFilter]
    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.
    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.

    getTargetDatabasesTables Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Tables List<GetTargetDatabasesTablesTable>
    The list of tables.
    TargetDatabaseId string
    Filters List<GetTargetDatabasesTablesFilter>
    SchemaNameContains string
    SchemaNames List<string>
    Name of the schema.
    TableNameContains string
    TableNames List<string>
    Name of the table.
    Id string
    The provider-assigned unique ID for this managed resource.
    Tables []GetTargetDatabasesTablesTable
    The list of tables.
    TargetDatabaseId string
    Filters []GetTargetDatabasesTablesFilter
    SchemaNameContains string
    SchemaNames []string
    Name of the schema.
    TableNameContains string
    TableNames []string
    Name of the table.
    id String
    The provider-assigned unique ID for this managed resource.
    tables List<GetTargetDatabasesTablesTable>
    The list of tables.
    targetDatabaseId String
    filters List<GetTargetDatabasesTablesFilter>
    schemaNameContains String
    schemaNames List<String>
    Name of the schema.
    tableNameContains String
    tableNames List<String>
    Name of the table.
    id string
    The provider-assigned unique ID for this managed resource.
    tables GetTargetDatabasesTablesTable[]
    The list of tables.
    targetDatabaseId string
    filters GetTargetDatabasesTablesFilter[]
    schemaNameContains string
    schemaNames string[]
    Name of the schema.
    tableNameContains string
    tableNames string[]
    Name of the table.
    id str
    The provider-assigned unique ID for this managed resource.
    tables Sequence[GetTargetDatabasesTablesTable]
    The list of tables.
    target_database_id str
    filters Sequence[GetTargetDatabasesTablesFilter]
    schema_name_contains str
    schema_names Sequence[str]
    Name of the schema.
    table_name_contains str
    table_names Sequence[str]
    Name of the table.
    id String
    The provider-assigned unique ID for this managed resource.
    tables List<Property Map>
    The list of tables.
    targetDatabaseId 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

    GetTargetDatabasesTablesFilter

    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

    GetTargetDatabasesTablesTable

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

    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 v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci