Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
oci.GoldenGate.getPipelineSchemaTables
Explore with Pulumi AI
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,
});
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)
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
	})
}
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,
    });
});
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());
    }
}
variables:
  testPipelineSchemaTables:
    fn::invoke:
      function: oci:GoldenGate:getPipelineSchemaTables
      arguments:
        pipelineId: ${testPipeline.id}
        sourceSchemaName: ${pipelineSchemaTableSourceSchemaName}
        targetSchemaName: ${pipelineSchemaTableTargetSchemaName}
        displayName: ${pipelineSchemaTableDisplayName}
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>def get_pipeline_schema_tables(display_name: Optional[str] = None,
                               filters: Optional[Sequence[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[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]func GetPipelineSchemaTables(ctx *Context, args *GetPipelineSchemaTablesArgs, opts ...InvokeOption) (*GetPipelineSchemaTablesResult, error)
func GetPipelineSchemaTablesOutput(ctx *Context, args *GetPipelineSchemaTablesOutputArgs, opts ...InvokeOption) GetPipelineSchemaTablesResultOutput> 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)
}public static CompletableFuture<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)
public static Output<GetPipelineSchemaTablesResult> getPipelineSchemaTables(GetPipelineSchemaTablesArgs args, InvokeOptions options)
fn::invoke:
  function: oci:GoldenGate/getPipelineSchemaTables:getPipelineSchemaTables
  arguments:
    # arguments dictionaryThe following arguments are supported:
- PipelineId string
- The OCID of the pipeline created.
- SourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- TargetSchema stringName 
- 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
List<GetPipeline Schema Tables Filter> 
- PipelineId string
- The OCID of the pipeline created.
- SourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- TargetSchema stringName 
- 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
[]GetPipeline Schema Tables Filter 
- pipelineId String
- The OCID of the pipeline created.
- sourceSchema StringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema StringName 
- 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
List<GetPipeline Schema Tables Filter> 
- pipelineId string
- The OCID of the pipeline created.
- sourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema stringName 
- 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
GetPipeline Schema Tables Filter[] 
- pipeline_id str
- The OCID of the pipeline created.
- source_schema_ strname 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- target_schema_ strname 
- 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
Sequence[GetPipeline Schema Tables Filter] 
- pipelineId String
- The OCID of the pipeline created.
- sourceSchema StringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema StringName 
- 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 List<Property Map>
getPipelineSchemaTables Result
The following output properties are available:
- Id string
- The provider-assigned unique ID for this managed resource.
- PipelineId string
- PipelineSchema List<GetTable Collections Pipeline Schema Tables Pipeline Schema Table Collection> 
- The list of pipeline_schema_table_collection.
- SourceSchema stringName 
- The schema name from the database connection.
- TargetSchema stringName 
- The schema name from the database connection.
- DisplayName string
- Filters
List<GetPipeline Schema Tables Filter> 
- Id string
- The provider-assigned unique ID for this managed resource.
- PipelineId string
- PipelineSchema []GetTable Collections Pipeline Schema Tables Pipeline Schema Table Collection 
- The list of pipeline_schema_table_collection.
- SourceSchema stringName 
- The schema name from the database connection.
- TargetSchema stringName 
- The schema name from the database connection.
- DisplayName string
- Filters
[]GetPipeline Schema Tables Filter 
- id String
- The provider-assigned unique ID for this managed resource.
- pipelineId String
- pipelineSchema List<GetTable Collections Pipeline Schema Tables Pipeline Schema Table Collection> 
- The list of pipeline_schema_table_collection.
- sourceSchema StringName 
- The schema name from the database connection.
- targetSchema StringName 
- The schema name from the database connection.
- displayName String
- filters
List<GetPipeline Schema Tables Filter> 
- id string
- The provider-assigned unique ID for this managed resource.
- pipelineId string
- pipelineSchema GetTable Collections Pipeline Schema Tables Pipeline Schema Table Collection[] 
- The list of pipeline_schema_table_collection.
- sourceSchema stringName 
- The schema name from the database connection.
- targetSchema stringName 
- The schema name from the database connection.
- displayName string
- filters
GetPipeline Schema Tables Filter[] 
- id str
- The provider-assigned unique ID for this managed resource.
- pipeline_id str
- pipeline_schema_ Sequence[Gettable_ collections Pipeline Schema Tables Pipeline Schema Table Collection] 
- The list of pipeline_schema_table_collection.
- source_schema_ strname 
- The schema name from the database connection.
- target_schema_ strname 
- The schema name from the database connection.
- display_name str
- filters
Sequence[GetPipeline Schema Tables Filter] 
- id String
- The provider-assigned unique ID for this managed resource.
- pipelineId String
- pipelineSchema List<Property Map>Table Collections 
- The list of pipeline_schema_table_collection.
- sourceSchema StringName 
- The schema name from the database connection.
- targetSchema StringName 
- The schema name from the database connection.
- displayName String
- filters List<Property Map>
Supporting Types
GetPipelineSchemaTablesFilter    
GetPipelineSchemaTablesPipelineSchemaTableCollection       
- Items
List<GetPipeline Schema Tables Pipeline Schema Table Collection Item> 
- Array of source or target schema tables of a pipeline's assigned connection.
- SourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- TargetSchema stringName 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
- Items
[]GetPipeline Schema Tables Pipeline Schema Table Collection Item 
- Array of source or target schema tables of a pipeline's assigned connection.
- SourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- TargetSchema stringName 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
- items
List<GetPipeline Schema Tables Pipeline Schema Table Collection Item> 
- Array of source or target schema tables of a pipeline's assigned connection.
- sourceSchema StringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema StringName 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
- items
GetPipeline Schema Tables Pipeline Schema Table Collection Item[] 
- Array of source or target schema tables of a pipeline's assigned connection.
- sourceSchema stringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema stringName 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
- items
Sequence[GetPipeline Schema Tables Pipeline Schema Table Collection Item] 
- Array of source or target schema tables of a pipeline's assigned connection.
- source_schema_ strname 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- target_schema_ strname 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
- items List<Property Map>
- Array of source or target schema tables of a pipeline's assigned connection.
- sourceSchema StringName 
- Name of the source schema obtained from get schema endpoint of the created pipeline.
- targetSchema StringName 
- Name of the target schema obtained from get schema endpoint of the created pipeline.
GetPipelineSchemaTablesPipelineSchemaTableCollectionItem        
- SourceTable stringName 
- The table name from the schema of database connection.
- TargetTable stringName 
- The table name from the schema of database connection.
- SourceTable stringName 
- The table name from the schema of database connection.
- TargetTable stringName 
- The table name from the schema of database connection.
- sourceTable StringName 
- The table name from the schema of database connection.
- targetTable StringName 
- The table name from the schema of database connection.
- sourceTable stringName 
- The table name from the schema of database connection.
- targetTable stringName 
- The table name from the schema of database connection.
- source_table_ strname 
- The table name from the schema of database connection.
- target_table_ strname 
- The table name from the schema of database connection.
- sourceTable StringName 
- The table name from the schema of database connection.
- targetTable StringName 
- 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 ociTerraform Provider.