1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. GoldenGate
  5. getPipelineSchemaTables
Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

oci.GoldenGate.getPipelineSchemaTables

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.32.0 published on Thursday, Apr 24, 2025 by Pulumi

This data source provides the list of Pipeline Schema Tables in Oracle Cloud Infrastructure Golden Gate service.

Returns an array of tables under the given schemas of the pipeline for given source and target schemas passed as query params.

Example Usage

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

const testPipelineSchemaTables = oci.GoldenGate.getPipelineSchemaTables({
    pipelineId: testPipeline.id,
    sourceSchemaName: pipelineSchemaTableSourceSchemaName,
    targetSchemaName: pipelineSchemaTableTargetSchemaName,
    displayName: pipelineSchemaTableDisplayName,
});
Copy
import pulumi
import pulumi_oci as oci

test_pipeline_schema_tables = oci.GoldenGate.get_pipeline_schema_tables(pipeline_id=test_pipeline["id"],
    source_schema_name=pipeline_schema_table_source_schema_name,
    target_schema_name=pipeline_schema_table_target_schema_name,
    display_name=pipeline_schema_table_display_name)
Copy
package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/goldengate"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := goldengate.GetPipelineSchemaTables(ctx, &goldengate.GetPipelineSchemaTablesArgs{
			PipelineId:       testPipeline.Id,
			SourceSchemaName: pipelineSchemaTableSourceSchemaName,
			TargetSchemaName: pipelineSchemaTableTargetSchemaName,
			DisplayName:      pulumi.StringRef(pipelineSchemaTableDisplayName),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testPipelineSchemaTables = Oci.GoldenGate.GetPipelineSchemaTables.Invoke(new()
    {
        PipelineId = testPipeline.Id,
        SourceSchemaName = pipelineSchemaTableSourceSchemaName,
        TargetSchemaName = pipelineSchemaTableTargetSchemaName,
        DisplayName = pipelineSchemaTableDisplayName,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.GoldenGate.GoldenGateFunctions;
import com.pulumi.oci.GoldenGate.inputs.GetPipelineSchemaTablesArgs;
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 testPipelineSchemaTables = GoldenGateFunctions.getPipelineSchemaTables(GetPipelineSchemaTablesArgs.builder()
            .pipelineId(testPipeline.id())
            .sourceSchemaName(pipelineSchemaTableSourceSchemaName)
            .targetSchemaName(pipelineSchemaTableTargetSchemaName)
            .displayName(pipelineSchemaTableDisplayName)
            .build());

    }
}
Copy
variables:
  testPipelineSchemaTables:
    fn::invoke:
      function: oci:GoldenGate:getPipelineSchemaTables
      arguments:
        pipelineId: ${testPipeline.id}
        sourceSchemaName: ${pipelineSchemaTableSourceSchemaName}
        targetSchemaName: ${pipelineSchemaTableTargetSchemaName}
        displayName: ${pipelineSchemaTableDisplayName}
Copy

Using getPipelineSchemaTables

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 getPipelineSchemaTables(args: GetPipelineSchemaTablesArgs, opts?: InvokeOptions): Promise<GetPipelineSchemaTablesResult>
function getPipelineSchemaTablesOutput(args: GetPipelineSchemaTablesOutputArgs, opts?: InvokeOptions): Output<GetPipelineSchemaTablesResult>
Copy
def get_pipeline_schema_tables(display_name: Optional[str] = None,
                               filters: Optional[Sequence[_goldengate.GetPipelineSchemaTablesFilter]] = None,
                               pipeline_id: Optional[str] = None,
                               source_schema_name: Optional[str] = None,
                               target_schema_name: Optional[str] = None,
                               opts: Optional[InvokeOptions] = None) -> GetPipelineSchemaTablesResult
def get_pipeline_schema_tables_output(display_name: Optional[pulumi.Input[str]] = None,
                               filters: Optional[pulumi.Input[Sequence[pulumi.Input[_goldengate.GetPipelineSchemaTablesFilterArgs]]]] = None,
                               pipeline_id: Optional[pulumi.Input[str]] = None,
                               source_schema_name: Optional[pulumi.Input[str]] = None,
                               target_schema_name: Optional[pulumi.Input[str]] = None,
                               opts: Optional[InvokeOptions] = None) -> Output[GetPipelineSchemaTablesResult]
Copy
func GetPipelineSchemaTables(ctx *Context, args *GetPipelineSchemaTablesArgs, opts ...InvokeOption) (*GetPipelineSchemaTablesResult, error)
func GetPipelineSchemaTablesOutput(ctx *Context, args *GetPipelineSchemaTablesOutputArgs, opts ...InvokeOption) GetPipelineSchemaTablesResultOutput
Copy

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

public static class GetPipelineSchemaTables 
{
    public static Task<GetPipelineSchemaTablesResult> InvokeAsync(GetPipelineSchemaTablesArgs args, InvokeOptions? opts = null)
    public static Output<GetPipelineSchemaTablesResult> Invoke(GetPipelineSchemaTablesInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)
public static Output<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:GoldenGate/getPipelineSchemaTables:getPipelineSchemaTables
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

PipelineId This property is required. string
The OCID of the pipeline created.
SourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
DisplayName string
A filter to return only the resources that match the entire 'displayName' given.
Filters Changes to this property will trigger replacement. List<GetPipelineSchemaTablesFilter>
PipelineId This property is required. string
The OCID of the pipeline created.
SourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
DisplayName string
A filter to return only the resources that match the entire 'displayName' given.
Filters Changes to this property will trigger replacement. []GetPipelineSchemaTablesFilter
pipelineId This property is required. String
The OCID of the pipeline created.
sourceSchemaName This property is required. String
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. String
Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName String
A filter to return only the resources that match the entire 'displayName' given.
filters Changes to this property will trigger replacement. List<GetPipelineSchemaTablesFilter>
pipelineId This property is required. string
The OCID of the pipeline created.
sourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName string
A filter to return only the resources that match the entire 'displayName' given.
filters Changes to this property will trigger replacement. GetPipelineSchemaTablesFilter[]
pipeline_id This property is required. str
The OCID of the pipeline created.
source_schema_name This property is required. str
Name of the source schema obtained from get schema endpoint of the created pipeline.
target_schema_name This property is required. str
Name of the target schema obtained from get schema endpoint of the created pipeline.
display_name str
A filter to return only the resources that match the entire 'displayName' given.
filters Changes to this property will trigger replacement. Sequence[goldengate.GetPipelineSchemaTablesFilter]
pipelineId This property is required. String
The OCID of the pipeline created.
sourceSchemaName This property is required. String
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. String
Name of the target schema obtained from get schema endpoint of the created pipeline.
displayName String
A filter to return only the resources that match the entire 'displayName' given.
filters Changes to this property will trigger replacement. List<Property Map>

getPipelineSchemaTables Result

The following output properties are available:

Id string
The provider-assigned unique ID for this managed resource.
PipelineId string
PipelineSchemaTableCollections List<GetPipelineSchemaTablesPipelineSchemaTableCollection>
The list of pipeline_schema_table_collection.
SourceSchemaName string
The schema name from the database connection.
TargetSchemaName string
The schema name from the database connection.
DisplayName string
Filters List<GetPipelineSchemaTablesFilter>
Id string
The provider-assigned unique ID for this managed resource.
PipelineId string
PipelineSchemaTableCollections []GetPipelineSchemaTablesPipelineSchemaTableCollection
The list of pipeline_schema_table_collection.
SourceSchemaName string
The schema name from the database connection.
TargetSchemaName string
The schema name from the database connection.
DisplayName string
Filters []GetPipelineSchemaTablesFilter
id String
The provider-assigned unique ID for this managed resource.
pipelineId String
pipelineSchemaTableCollections List<GetPipelineSchemaTablesPipelineSchemaTableCollection>
The list of pipeline_schema_table_collection.
sourceSchemaName String
The schema name from the database connection.
targetSchemaName String
The schema name from the database connection.
displayName String
filters List<GetPipelineSchemaTablesFilter>
id string
The provider-assigned unique ID for this managed resource.
pipelineId string
pipelineSchemaTableCollections GetPipelineSchemaTablesPipelineSchemaTableCollection[]
The list of pipeline_schema_table_collection.
sourceSchemaName string
The schema name from the database connection.
targetSchemaName string
The schema name from the database connection.
displayName string
filters GetPipelineSchemaTablesFilter[]
id str
The provider-assigned unique ID for this managed resource.
pipeline_id str
pipeline_schema_table_collections Sequence[goldengate.GetPipelineSchemaTablesPipelineSchemaTableCollection]
The list of pipeline_schema_table_collection.
source_schema_name str
The schema name from the database connection.
target_schema_name str
The schema name from the database connection.
display_name str
filters Sequence[goldengate.GetPipelineSchemaTablesFilter]
id String
The provider-assigned unique ID for this managed resource.
pipelineId String
pipelineSchemaTableCollections List<Property Map>
The list of pipeline_schema_table_collection.
sourceSchemaName String
The schema name from the database connection.
targetSchemaName String
The schema name from the database connection.
displayName String
filters List<Property Map>

Supporting Types

GetPipelineSchemaTablesFilter

Name This property is required. string
Values This property is required. List<string>
Regex bool
Name This property is required. string
Values This property is required. []string
Regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean
name This property is required. string
values This property is required. string[]
regex boolean
name This property is required. str
values This property is required. Sequence[str]
regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean

GetPipelineSchemaTablesPipelineSchemaTableCollection

Items This property is required. List<GetPipelineSchemaTablesPipelineSchemaTableCollectionItem>
Array of source or target schema tables of a pipeline's assigned connection.
SourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
Items This property is required. []GetPipelineSchemaTablesPipelineSchemaTableCollectionItem
Array of source or target schema tables of a pipeline's assigned connection.
SourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
TargetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
items This property is required. List<GetPipelineSchemaTablesPipelineSchemaTableCollectionItem>
Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName This property is required. String
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. String
Name of the target schema obtained from get schema endpoint of the created pipeline.
items This property is required. GetPipelineSchemaTablesPipelineSchemaTableCollectionItem[]
Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName This property is required. string
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. string
Name of the target schema obtained from get schema endpoint of the created pipeline.
items This property is required. Sequence[goldengate.GetPipelineSchemaTablesPipelineSchemaTableCollectionItem]
Array of source or target schema tables of a pipeline's assigned connection.
source_schema_name This property is required. str
Name of the source schema obtained from get schema endpoint of the created pipeline.
target_schema_name This property is required. str
Name of the target schema obtained from get schema endpoint of the created pipeline.
items This property is required. List<Property Map>
Array of source or target schema tables of a pipeline's assigned connection.
sourceSchemaName This property is required. String
Name of the source schema obtained from get schema endpoint of the created pipeline.
targetSchemaName This property is required. String
Name of the target schema obtained from get schema endpoint of the created pipeline.

GetPipelineSchemaTablesPipelineSchemaTableCollectionItem

SourceTableName This property is required. string
The table name from the schema of database connection.
TargetTableName This property is required. string
The table name from the schema of database connection.
SourceTableName This property is required. string
The table name from the schema of database connection.
TargetTableName This property is required. string
The table name from the schema of database connection.
sourceTableName This property is required. String
The table name from the schema of database connection.
targetTableName This property is required. String
The table name from the schema of database connection.
sourceTableName This property is required. string
The table name from the schema of database connection.
targetTableName This property is required. string
The table name from the schema of database connection.
source_table_name This property is required. str
The table name from the schema of database connection.
target_table_name This property is required. str
The table name from the schema of database connection.
sourceTableName This property is required. String
The table name from the schema of database connection.
targetTableName This property is required. String
The table name from the schema of database connection.

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.32.0 published on Thursday, Apr 24, 2025 by Pulumi