1. Registry
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DataSafe
  6. getSubsettingPolicySubsettingSchemaRelation
Viewing docs for Oracle Cloud Infrastructure v5.3.1
published on Tuesday, Oct 13, 2026 by Pulumi
oci logo oci logo
Viewing docs for Oracle Cloud Infrastructure v5.3.1
published on Tuesday, Oct 13, 2026 by Pulumi

    This data source provides details about a specific Subsetting Policy Subsetting Schema Relation resource in Oracle Cloud Infrastructure Data Safe service.

    Gets the details of the specified referential relation in the subsetting policy.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testSubsettingPolicySubsettingSchemaRelation = oci.datasafe.getSubsettingPolicySubsettingSchemaRelation({
        subsettingPolicyId: testSubsettingPolicy.id,
        subsettingSchemaRelationKey: subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_subsetting_policy_subsetting_schema_relation = oci.datasafe.get_subsetting_policy_subsetting_schema_relation(subsetting_policy_id=test_subsetting_policy["id"],
        subsetting_schema_relation_key=subsetting_policy_subsetting_schema_relation_subsetting_schema_relation_key)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v5/go/oci/datasafe"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := datasafe.GetSubsettingPolicySubsettingSchemaRelation(ctx, &datasafe.GetSubsettingPolicySubsettingSchemaRelationArgs{
    			SubsettingPolicyId:          testSubsettingPolicy.Id,
    			SubsettingSchemaRelationKey: subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey,
    		}, 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 testSubsettingPolicySubsettingSchemaRelation = Oci.DataSafe.GetSubsettingPolicySubsettingSchemaRelation.Invoke(new()
        {
            SubsettingPolicyId = testSubsettingPolicy.Id,
            SubsettingSchemaRelationKey = subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey,
        });
    
    });
    
    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.GetSubsettingPolicySubsettingSchemaRelationArgs;
    import java.util.ArrayList;
    import java.util.Arrays;
    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 testSubsettingPolicySubsettingSchemaRelation = DataSafeFunctions.getSubsettingPolicySubsettingSchemaRelation(GetSubsettingPolicySubsettingSchemaRelationArgs.builder()
                .subsettingPolicyId(testSubsettingPolicy.get("id"))
                .subsettingSchemaRelationKey(subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey)
                .build());
    
        }
    }
    
    variables:
      testSubsettingPolicySubsettingSchemaRelation:
        fn::invoke:
          function: oci:DataSafe:getSubsettingPolicySubsettingSchemaRelation
          arguments:
            subsettingPolicyId: ${testSubsettingPolicy.id}
            subsettingSchemaRelationKey: ${subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey}
    
    terraform {
      required_providers {
        oci = {
          source = "pulumi/oci"
        }
      }
    }
    
    data "oci_data_safe_subsetting_policy_subsetting_schema_relation" "testSubsettingPolicySubsettingSchemaRelation" {
      subsetting_policy_id           = testSubsettingPolicy.id
      subsetting_schema_relation_key = subsettingPolicySubsettingSchemaRelationSubsettingSchemaRelationKey
    }
    

    Using getSubsettingPolicySubsettingSchemaRelation

    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 getSubsettingPolicySubsettingSchemaRelation(args: GetSubsettingPolicySubsettingSchemaRelationArgs, opts?: InvokeOptions): Promise<GetSubsettingPolicySubsettingSchemaRelationResult>
    function getSubsettingPolicySubsettingSchemaRelationOutput(args: GetSubsettingPolicySubsettingSchemaRelationOutputArgs, opts?: InvokeOutputOptions): Output<GetSubsettingPolicySubsettingSchemaRelationResult>
    def get_subsetting_policy_subsetting_schema_relation(subsetting_policy_id: Optional[str] = None,
                                                         subsetting_schema_relation_key: Optional[str] = None,
                                                         opts: Optional[InvokeOptions] = None) -> GetSubsettingPolicySubsettingSchemaRelationResult
    def get_subsetting_policy_subsetting_schema_relation_output(subsetting_policy_id: pulumi.Input[Optional[str]] = None,
                                                         subsetting_schema_relation_key: pulumi.Input[Optional[str]] = None,
                                                         opts: Optional[InvokeOutputOptions] = None) -> Output[GetSubsettingPolicySubsettingSchemaRelationResult]
    func LookupSubsettingPolicySubsettingSchemaRelation(ctx *Context, args *LookupSubsettingPolicySubsettingSchemaRelationArgs, opts ...InvokeOption) (*LookupSubsettingPolicySubsettingSchemaRelationResult, error)
    func LookupSubsettingPolicySubsettingSchemaRelationOutput(ctx *Context, args *LookupSubsettingPolicySubsettingSchemaRelationOutputArgs, opts ...InvokeOption) LookupSubsettingPolicySubsettingSchemaRelationResultOutput

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

    public static class GetSubsettingPolicySubsettingSchemaRelation 
    {
        public static Task<GetSubsettingPolicySubsettingSchemaRelationResult> InvokeAsync(GetSubsettingPolicySubsettingSchemaRelationArgs args, InvokeOptions? opts = null)
        public static Output<GetSubsettingPolicySubsettingSchemaRelationResult> Invoke(GetSubsettingPolicySubsettingSchemaRelationInvokeArgs args, InvokeOptions? opts = null)
        public static Output<GetSubsettingPolicySubsettingSchemaRelationResult> Invoke(GetSubsettingPolicySubsettingSchemaRelationInvokeArgs args, InvokeOutputOptions opts)
    }
    public static CompletableFuture<GetSubsettingPolicySubsettingSchemaRelationResult> getSubsettingPolicySubsettingSchemaRelation(GetSubsettingPolicySubsettingSchemaRelationArgs args, InvokeOptions options)
    public static Output<GetSubsettingPolicySubsettingSchemaRelationResult> getSubsettingPolicySubsettingSchemaRelation(GetSubsettingPolicySubsettingSchemaRelationArgs args, InvokeOptions options)
    public static Output<GetSubsettingPolicySubsettingSchemaRelationResult> getSubsettingPolicySubsettingSchemaRelation(GetSubsettingPolicySubsettingSchemaRelationArgs args, InvokeOutputOptions options)
    
    fn::invoke:
      function: oci:DataSafe/getSubsettingPolicySubsettingSchemaRelation:getSubsettingPolicySubsettingSchemaRelation
      arguments:
        # arguments dictionary
    data "oci_data_safe_get_subsetting_policy_subsetting_schema_relation" "name" {
        # arguments
    }

    The following arguments are supported:

    SubsettingPolicyId string
    The OCID of the subsetting policy.
    SubsettingSchemaRelationKey string
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    SubsettingPolicyId string
    The OCID of the subsetting policy.
    SubsettingSchemaRelationKey string
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    subsetting_policy_id string
    The OCID of the subsetting policy.
    subsetting_schema_relation_key string
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    subsettingPolicyId String
    The OCID of the subsetting policy.
    subsettingSchemaRelationKey String
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    subsettingPolicyId string
    The OCID of the subsetting policy.
    subsettingSchemaRelationKey string
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    subsetting_policy_id str
    The OCID of the subsetting policy.
    subsetting_schema_relation_key str
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.
    subsettingPolicyId String
    The OCID of the subsetting policy.
    subsettingSchemaRelationKey String
    The unique key that identifies the subsetting relation. It's numeric and unique within a subsetting policy.

    getSubsettingPolicySubsettingSchemaRelation Result

    The following output properties are available:

    ChildColumns List<string>
    Unique identifiers identifying the child columns in the relation.
    ChildObjectKey string
    The key that identifies the child subsetting table in this relation.
    ChildObjectName string
    The name of the child subsetting table
    ChildSchemaName string
    The database schema that contains the child subsetting table
    Id string
    Key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    ParentColumns List<string>
    Unique identifiers identifying the parents columns in the relation.
    ParentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    ParentObjectName string
    The name of the parent subsetting table
    ParentSchemaName string
    The database schema that contains the parent subsetting table
    RelationType string
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    SubsettingPolicyId string
    SubsettingSchemaRelationKey string
    TimeCreated string
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    ChildColumns []string
    Unique identifiers identifying the child columns in the relation.
    ChildObjectKey string
    The key that identifies the child subsetting table in this relation.
    ChildObjectName string
    The name of the child subsetting table
    ChildSchemaName string
    The database schema that contains the child subsetting table
    Id string
    Key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    ParentColumns []string
    Unique identifiers identifying the parents columns in the relation.
    ParentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    ParentObjectName string
    The name of the parent subsetting table
    ParentSchemaName string
    The database schema that contains the parent subsetting table
    RelationType string
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    SubsettingPolicyId string
    SubsettingSchemaRelationKey string
    TimeCreated string
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    child_columns list(string)
    Unique identifiers identifying the child columns in the relation.
    child_object_key string
    The key that identifies the child subsetting table in this relation.
    child_object_name string
    The name of the child subsetting table
    child_schema_name string
    The database schema that contains the child subsetting table
    id string
    key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    parent_columns list(string)
    Unique identifiers identifying the parents columns in the relation.
    parent_object_key string
    The key that identifies the parent subsetting table in this relation.
    parent_object_name string
    The name of the parent subsetting table
    parent_schema_name string
    The database schema that contains the parent subsetting table
    relation_type string
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    subsetting_policy_id string
    subsetting_schema_relation_key string
    time_created string
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    time_updated string
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    childColumns List<String>
    Unique identifiers identifying the child columns in the relation.
    childObjectKey String
    The key that identifies the child subsetting table in this relation.
    childObjectName String
    The name of the child subsetting table
    childSchemaName String
    The database schema that contains the child subsetting table
    id String
    key String
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    parentColumns List<String>
    Unique identifiers identifying the parents columns in the relation.
    parentObjectKey String
    The key that identifies the parent subsetting table in this relation.
    parentObjectName String
    The name of the parent subsetting table
    parentSchemaName String
    The database schema that contains the parent subsetting table
    relationType String
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    subsettingPolicyId String
    subsettingSchemaRelationKey String
    timeCreated String
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    childColumns string[]
    Unique identifiers identifying the child columns in the relation.
    childObjectKey string
    The key that identifies the child subsetting table in this relation.
    childObjectName string
    The name of the child subsetting table
    childSchemaName string
    The database schema that contains the child subsetting table
    id string
    key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    parentColumns string[]
    Unique identifiers identifying the parents columns in the relation.
    parentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    parentObjectName string
    The name of the parent subsetting table
    parentSchemaName string
    The database schema that contains the parent subsetting table
    relationType string
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    subsettingPolicyId string
    subsettingSchemaRelationKey string
    timeCreated string
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    timeUpdated string
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    child_columns Sequence[str]
    Unique identifiers identifying the child columns in the relation.
    child_object_key str
    The key that identifies the child subsetting table in this relation.
    child_object_name str
    The name of the child subsetting table
    child_schema_name str
    The database schema that contains the child subsetting table
    id str
    key str
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    parent_columns Sequence[str]
    Unique identifiers identifying the parents columns in the relation.
    parent_object_key str
    The key that identifies the parent subsetting table in this relation.
    parent_object_name str
    The name of the parent subsetting table
    parent_schema_name str
    The database schema that contains the parent subsetting table
    relation_type str
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    subsetting_policy_id str
    subsetting_schema_relation_key str
    time_created str
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    time_updated str
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.
    childColumns List<String>
    Unique identifiers identifying the child columns in the relation.
    childObjectKey String
    The key that identifies the child subsetting table in this relation.
    childObjectName String
    The name of the child subsetting table
    childSchemaName String
    The database schema that contains the child subsetting table
    id String
    key String
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    parentColumns List<String>
    Unique identifiers identifying the parents columns in the relation.
    parentObjectKey String
    The key that identifies the parent subsetting table in this relation.
    parentObjectName String
    The name of the parent subsetting table
    parentSchemaName String
    The database schema that contains the parent subsetting table
    relationType String
    The type of referential relationship the column has with its parent. NONE indicates that the sensitive column does not have a parent. DB_DEFINED indicates that the relationship is defined in the database dictionary. APP_DEFINED indicates that the relationship is defined at the application level and not in the database dictionary.
    subsettingPolicyId String
    subsettingSchemaRelationKey String
    timeCreated String
    The date and time the subsetting relation was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the subsetting relation was last updated, in the format defined by RFC3339.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo oci logo
    Viewing docs for Oracle Cloud Infrastructure v5.3.1
    published on Tuesday, Oct 13, 2026 by Pulumi

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial