Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getTargetDatabasesTables
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getTargetDatabasesTables

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 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: oci_data_safe_target_database.test_target_database.id,
    schemaNames: _var.target_databases_table_schema_name,
    schemaNameContains: _var.target_databases_table_schema_name_contains,
    tableNames: oci_nosql_table.test_table.name,
    tableNameContains: _var.target_databases_table_table_name_contains,
});

    import pulumi
import pulumi_oci as oci

test_target_databases_tables = oci.DataSafe.get_target_databases_tables(target_database_id=oci_data_safe_target_database["test_target_database"]["id"],
    schema_names=var["target_databases_table_schema_name"],
    schema_name_contains=var["target_databases_table_schema_name_contains"],
    table_names=oci_nosql_table["test_table"]["name"],
    table_name_contains=var["target_databases_table_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.GetTargetDatabasesTables(ctx, &datasafe.GetTargetDatabasesTablesArgs{
			TargetDatabaseId:   oci_data_safe_target_database.Test_target_database.Id,
			SchemaNames:        _var.Target_databases_table_schema_name,
			SchemaNameContains: pulumi.StringRef(_var.Target_databases_table_schema_name_contains),
			TableNames:         oci_nosql_table.Test_table.Name,
			TableNameContains:  pulumi.StringRef(_var.Target_databases_table_table_name_contains),
		}, 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 = oci_data_safe_target_database.Test_target_database.Id,
        SchemaNames = @var.Target_databases_table_schema_name,
        SchemaNameContains = @var.Target_databases_table_schema_name_contains,
        TableNames = oci_nosql_table.Test_table.Name,
        TableNameContains = @var.Target_databases_table_table_name_contains,
    });

});

    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(oci_data_safe_target_database.test_target_database().id())
            .schemaNames(var_.target_databases_table_schema_name())
            .schemaNameContains(var_.target_databases_table_schema_name_contains())
            .tableNames(oci_nosql_table.test_table().name())
            .tableNameContains(var_.target_databases_table_table_name_contains())
            .build());

    }
}

    variables:
  testTargetDatabasesTables:
    fn::invoke:
      Function: oci:DataSafe:getTargetDatabasesTables
      Arguments:
        targetDatabaseId: ${oci_data_safe_target_database.test_target_database.id}
        schemaNames: ${var.target_databases_table_schema_name}
        schemaNameContains: ${var.target_databases_table_schema_name_contains}
        tableNames: ${oci_nosql_table.test_table.name}
        tableNameContains: ${var.target_databases_table_table_name_contains}

    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[_datasafe.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[_datasafe.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)
// Output-based functions aren't available in Java yet

    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[datasafe.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[datasafe.GetTargetDatabasesTablesTable]
    The list of tables.
    target_database_id str
    filters Sequence[datasafe.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 v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi
    pulumi/pulumi-oci