Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DataSafe
  6. SubsettingPolicySubsettingSchemaRelation
Viewing docs for Oracle Cloud Infrastructure v5.5.0
published on Thursday, Oct 22, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DataSafe.SubsettingPolicySubsettingSchemaRelation

oci logo oci logo
Viewing docs for Oracle Cloud Infrastructure v5.5.0
published on Thursday, Oct 22, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This resource provides the Subsetting Policy Subsetting Schema Relation resource in Oracle Cloud Infrastructure Data Safe service. Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/data-safe/latest/SubsettingSchemaRelation

    Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/datasafe

    Details to create a new referential relation.

    Example Usage

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

const testSubsettingPolicySubsettingSchemaRelation = new oci.datasafe.SubsettingPolicySubsettingSchemaRelation("test_subsetting_policy_subsetting_schema_relation", {
    childColumns: subsettingPolicySubsettingSchemaRelationChildColumns,
    childObjectName: testObject.name,
    childSchemaName: subsettingPolicySubsettingSchemaRelationChildSchemaName,
    parentColumns: subsettingPolicySubsettingSchemaRelationParentColumns,
    parentObjectName: testObject.name,
    parentSchemaName: subsettingPolicySubsettingSchemaRelationParentSchemaName,
    subsettingPolicyId: testSubsettingPolicy.id,
    childObjectKey: subsettingPolicySubsettingSchemaRelationChildObjectKey,
    parentObjectKey: subsettingPolicySubsettingSchemaRelationParentObjectKey,
});

    import pulumi
import pulumi_oci as oci

test_subsetting_policy_subsetting_schema_relation = oci.datasafe.SubsettingPolicySubsettingSchemaRelation("test_subsetting_policy_subsetting_schema_relation",
    child_columns=subsetting_policy_subsetting_schema_relation_child_columns,
    child_object_name=test_object["name"],
    child_schema_name=subsetting_policy_subsetting_schema_relation_child_schema_name,
    parent_columns=subsetting_policy_subsetting_schema_relation_parent_columns,
    parent_object_name=test_object["name"],
    parent_schema_name=subsetting_policy_subsetting_schema_relation_parent_schema_name,
    subsetting_policy_id=test_subsetting_policy["id"],
    child_object_key=subsetting_policy_subsetting_schema_relation_child_object_key,
    parent_object_key=subsetting_policy_subsetting_schema_relation_parent_object_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.NewSubsettingPolicySubsettingSchemaRelation(ctx, "test_subsetting_policy_subsetting_schema_relation", &datasafe.SubsettingPolicySubsettingSchemaRelationArgs{
			ChildColumns:       pulumi.Any(subsettingPolicySubsettingSchemaRelationChildColumns),
			ChildObjectName:    pulumi.Any(testObject.Name),
			ChildSchemaName:    pulumi.Any(subsettingPolicySubsettingSchemaRelationChildSchemaName),
			ParentColumns:      pulumi.Any(subsettingPolicySubsettingSchemaRelationParentColumns),
			ParentObjectName:   pulumi.Any(testObject.Name),
			ParentSchemaName:   pulumi.Any(subsettingPolicySubsettingSchemaRelationParentSchemaName),
			SubsettingPolicyId: pulumi.Any(testSubsettingPolicy.Id),
			ChildObjectKey:     pulumi.Any(subsettingPolicySubsettingSchemaRelationChildObjectKey),
			ParentObjectKey:    pulumi.Any(subsettingPolicySubsettingSchemaRelationParentObjectKey),
		})
		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 = new Oci.DataSafe.SubsettingPolicySubsettingSchemaRelation("test_subsetting_policy_subsetting_schema_relation", new()
    {
        ChildColumns = subsettingPolicySubsettingSchemaRelationChildColumns,
        ChildObjectName = testObject.Name,
        ChildSchemaName = subsettingPolicySubsettingSchemaRelationChildSchemaName,
        ParentColumns = subsettingPolicySubsettingSchemaRelationParentColumns,
        ParentObjectName = testObject.Name,
        ParentSchemaName = subsettingPolicySubsettingSchemaRelationParentSchemaName,
        SubsettingPolicyId = testSubsettingPolicy.Id,
        ChildObjectKey = subsettingPolicySubsettingSchemaRelationChildObjectKey,
        ParentObjectKey = subsettingPolicySubsettingSchemaRelationParentObjectKey,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DataSafe.SubsettingPolicySubsettingSchemaRelation;
import com.pulumi.oci.DataSafe.SubsettingPolicySubsettingSchemaRelationArgs;
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) {
        var testSubsettingPolicySubsettingSchemaRelation = new SubsettingPolicySubsettingSchemaRelation("testSubsettingPolicySubsettingSchemaRelation", SubsettingPolicySubsettingSchemaRelationArgs.builder()
            .childColumns(subsettingPolicySubsettingSchemaRelationChildColumns)
            .childObjectName(testObject.get("name"))
            .childSchemaName(subsettingPolicySubsettingSchemaRelationChildSchemaName)
            .parentColumns(subsettingPolicySubsettingSchemaRelationParentColumns)
            .parentObjectName(testObject.get("name"))
            .parentSchemaName(subsettingPolicySubsettingSchemaRelationParentSchemaName)
            .subsettingPolicyId(testSubsettingPolicy.get("id"))
            .childObjectKey(subsettingPolicySubsettingSchemaRelationChildObjectKey)
            .parentObjectKey(subsettingPolicySubsettingSchemaRelationParentObjectKey)
            .build());

    }
}

    resources:
  testSubsettingPolicySubsettingSchemaRelation:
    type: oci:DataSafe:SubsettingPolicySubsettingSchemaRelation
    name: test_subsetting_policy_subsetting_schema_relation
    properties:
      childColumns: ${subsettingPolicySubsettingSchemaRelationChildColumns}
      childObjectName: ${testObject.name}
      childSchemaName: ${subsettingPolicySubsettingSchemaRelationChildSchemaName}
      parentColumns: ${subsettingPolicySubsettingSchemaRelationParentColumns}
      parentObjectName: ${testObject.name}
      parentSchemaName: ${subsettingPolicySubsettingSchemaRelationParentSchemaName}
      subsettingPolicyId: ${testSubsettingPolicy.id}
      childObjectKey: ${subsettingPolicySubsettingSchemaRelationChildObjectKey}
      parentObjectKey: ${subsettingPolicySubsettingSchemaRelationParentObjectKey}

    terraform {
  required_providers {
    oci = {
      source = "pulumi/oci"
    }
  }
}

resource "oci_data_safe_subsetting_policy_subsetting_schema_relation" "test_subsetting_policy_subsetting_schema_relation" {
  lifecycle {
    create_before_destroy = true
  }
  child_columns        = subsettingPolicySubsettingSchemaRelationChildColumns
  child_object_name    = testObject.name
  child_schema_name    = subsettingPolicySubsettingSchemaRelationChildSchemaName
  parent_columns       = subsettingPolicySubsettingSchemaRelationParentColumns
  parent_object_name   = testObject.name
  parent_schema_name   = subsettingPolicySubsettingSchemaRelationParentSchemaName
  subsetting_policy_id = testSubsettingPolicy.id
  child_object_key     = subsettingPolicySubsettingSchemaRelationChildObjectKey
  parent_object_key    = subsettingPolicySubsettingSchemaRelationParentObjectKey
}

    Create SubsettingPolicySubsettingSchemaRelation Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SubsettingPolicySubsettingSchemaRelation(name: string, args: SubsettingPolicySubsettingSchemaRelationArgs, opts?: CustomResourceOptions);
    @overload
def SubsettingPolicySubsettingSchemaRelation(resource_name: str,
                                             args: SubsettingPolicySubsettingSchemaRelationArgs,
                                             opts: Optional[ResourceOptions] = None)

@overload
def SubsettingPolicySubsettingSchemaRelation(resource_name: str,
                                             opts: Optional[ResourceOptions] = None,
                                             child_columns: Optional[Sequence[str]] = None,
                                             child_object_name: Optional[str] = None,
                                             child_schema_name: Optional[str] = None,
                                             parent_columns: Optional[Sequence[str]] = None,
                                             parent_object_name: Optional[str] = None,
                                             parent_schema_name: Optional[str] = None,
                                             subsetting_policy_id: Optional[str] = None,
                                             child_object_key: Optional[str] = None,
                                             parent_object_key: Optional[str] = None)
    func NewSubsettingPolicySubsettingSchemaRelation(ctx *Context, name string, args SubsettingPolicySubsettingSchemaRelationArgs, opts ...ResourceOption) (*SubsettingPolicySubsettingSchemaRelation, error)
    public SubsettingPolicySubsettingSchemaRelation(string name, SubsettingPolicySubsettingSchemaRelationArgs args, CustomResourceOptions? opts = null)
    public SubsettingPolicySubsettingSchemaRelation(String name, SubsettingPolicySubsettingSchemaRelationArgs args)
public SubsettingPolicySubsettingSchemaRelation(String name, SubsettingPolicySubsettingSchemaRelationArgs args, CustomResourceOptions options)

    type: oci:DataSafe:SubsettingPolicySubsettingSchemaRelation
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.


    resource "oci_data_safe_subsetting_policy_subsetting_schema_relation" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args SubsettingPolicySubsettingSchemaRelationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SubsettingPolicySubsettingSchemaRelationArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SubsettingPolicySubsettingSchemaRelationArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SubsettingPolicySubsettingSchemaRelationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SubsettingPolicySubsettingSchemaRelationArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var subsettingPolicySubsettingSchemaRelationResource = new Oci.DataSafe.SubsettingPolicySubsettingSchemaRelation("subsettingPolicySubsettingSchemaRelationResource", new()
{
    ChildColumns = new[]
    {
        "string",
    },
    ChildObjectName = "string",
    ChildSchemaName = "string",
    ParentColumns = new[]
    {
        "string",
    },
    ParentObjectName = "string",
    ParentSchemaName = "string",
    SubsettingPolicyId = "string",
    ChildObjectKey = "string",
    ParentObjectKey = "string",
});

    example, err := datasafe.NewSubsettingPolicySubsettingSchemaRelation(ctx, "subsettingPolicySubsettingSchemaRelationResource", &datasafe.SubsettingPolicySubsettingSchemaRelationArgs{
	ChildColumns: pulumi.StringArray{
		pulumi.String("string"),
	},
	ChildObjectName: pulumi.String("string"),
	ChildSchemaName: pulumi.String("string"),
	ParentColumns: pulumi.StringArray{
		pulumi.String("string"),
	},
	ParentObjectName:   pulumi.String("string"),
	ParentSchemaName:   pulumi.String("string"),
	SubsettingPolicyId: pulumi.String("string"),
	ChildObjectKey:     pulumi.String("string"),
	ParentObjectKey:    pulumi.String("string"),
})

    resource "oci_data_safe_subsetting_policy_subsetting_schema_relation" "subsettingPolicySubsettingSchemaRelationResource" {
  lifecycle {
    create_before_destroy = true
  }
  child_columns        = ["string"]
  child_object_name    = "string"
  child_schema_name    = "string"
  parent_columns       = ["string"]
  parent_object_name   = "string"
  parent_schema_name   = "string"
  subsetting_policy_id = "string"
  child_object_key     = "string"
  parent_object_key    = "string"
}

    var subsettingPolicySubsettingSchemaRelationResource = new SubsettingPolicySubsettingSchemaRelation("subsettingPolicySubsettingSchemaRelationResource", SubsettingPolicySubsettingSchemaRelationArgs.builder()
    .childColumns("string")
    .childObjectName("string")
    .childSchemaName("string")
    .parentColumns("string")
    .parentObjectName("string")
    .parentSchemaName("string")
    .subsettingPolicyId("string")
    .childObjectKey("string")
    .parentObjectKey("string")
    .build());

    subsetting_policy_subsetting_schema_relation_resource = oci.datasafe.SubsettingPolicySubsettingSchemaRelation("subsettingPolicySubsettingSchemaRelationResource",
    child_columns=["string"],
    child_object_name="string",
    child_schema_name="string",
    parent_columns=["string"],
    parent_object_name="string",
    parent_schema_name="string",
    subsetting_policy_id="string",
    child_object_key="string",
    parent_object_key="string")

    const subsettingPolicySubsettingSchemaRelationResource = new oci.datasafe.SubsettingPolicySubsettingSchemaRelation("subsettingPolicySubsettingSchemaRelationResource", {
    childColumns: ["string"],
    childObjectName: "string",
    childSchemaName: "string",
    parentColumns: ["string"],
    parentObjectName: "string",
    parentSchemaName: "string",
    subsettingPolicyId: "string",
    childObjectKey: "string",
    parentObjectKey: "string",
});

    type: oci:DataSafe:SubsettingPolicySubsettingSchemaRelation
properties:
    childColumns:
        - string
    childObjectKey: string
    childObjectName: string
    childSchemaName: string
    parentColumns:
        - string
    parentObjectKey: string
    parentObjectName: string
    parentSchemaName: string
    subsettingPolicyId: string

    SubsettingPolicySubsettingSchemaRelation Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The SubsettingPolicySubsettingSchemaRelation resource accepts the following input properties:

    ChildColumns List<string>
    Unique identifiers identifying the child columns in the relation.
    ChildObjectName string
    The name of the child subsetting table
    ChildSchemaName string
    The database schema that contains the child subsetting table
    ParentColumns List<string>
    Unique identifiers identifying the parents columns in the relation.
    ParentObjectName string
    The name of the parent subsetting table
    ParentSchemaName string
    The database schema that contains the parent subsetting table
    SubsettingPolicyId string

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    ChildObjectKey string
    The key that identifies the child subsetting table in this relation.
    ParentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    ChildColumns []string
    Unique identifiers identifying the child columns in the relation.
    ChildObjectName string
    The name of the child subsetting table
    ChildSchemaName string
    The database schema that contains the child subsetting table
    ParentColumns []string
    Unique identifiers identifying the parents columns in the relation.
    ParentObjectName string
    The name of the parent subsetting table
    ParentSchemaName string
    The database schema that contains the parent subsetting table
    SubsettingPolicyId string

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    ChildObjectKey string
    The key that identifies the child subsetting table in this relation.
    ParentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    child_columns list(string)
    Unique identifiers identifying the child columns in the 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
    parent_columns list(string)
    Unique identifiers identifying the parents columns in the 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
    subsetting_policy_id string

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    child_object_key string
    The key that identifies the child subsetting table in this relation.
    parent_object_key string
    The key that identifies the parent subsetting table in this relation.
    childColumns List<String>
    Unique identifiers identifying the child columns in the relation.
    childObjectName String
    The name of the child subsetting table
    childSchemaName String
    The database schema that contains the child subsetting table
    parentColumns List<String>
    Unique identifiers identifying the parents columns in the relation.
    parentObjectName String
    The name of the parent subsetting table
    parentSchemaName String
    The database schema that contains the parent subsetting table
    subsettingPolicyId String

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    childObjectKey String
    The key that identifies the child subsetting table in this relation.
    parentObjectKey String
    The key that identifies the parent subsetting table in this relation.
    childColumns string[]
    Unique identifiers identifying the child columns in the relation.
    childObjectName string
    The name of the child subsetting table
    childSchemaName string
    The database schema that contains the child subsetting table
    parentColumns string[]
    Unique identifiers identifying the parents columns in the relation.
    parentObjectName string
    The name of the parent subsetting table
    parentSchemaName string
    The database schema that contains the parent subsetting table
    subsettingPolicyId string

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    childObjectKey string
    The key that identifies the child subsetting table in this relation.
    parentObjectKey string
    The key that identifies the parent subsetting table in this relation.
    child_columns Sequence[str]
    Unique identifiers identifying the child columns in the 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
    parent_columns Sequence[str]
    Unique identifiers identifying the parents columns in the 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
    subsetting_policy_id str

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    child_object_key str
    The key that identifies the child subsetting table in this relation.
    parent_object_key str
    The key that identifies the parent subsetting table in this relation.
    childColumns List<String>
    Unique identifiers identifying the child columns in the relation.
    childObjectName String
    The name of the child subsetting table
    childSchemaName String
    The database schema that contains the child subsetting table
    parentColumns List<String>
    Unique identifiers identifying the parents columns in the relation.
    parentObjectName String
    The name of the parent subsetting table
    parentSchemaName String
    The database schema that contains the parent subsetting table
    subsettingPolicyId String

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    childObjectKey String
    The key that identifies the child subsetting table in this relation.
    parentObjectKey String
    The key that identifies the parent subsetting table in this relation.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SubsettingPolicySubsettingSchemaRelation resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    Id string
    The provider-assigned unique ID for this managed resource.
    Key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    id string
    The provider-assigned unique ID for this managed resource.
    key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    id String
    The provider-assigned unique ID for this managed resource.
    key String
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    id string
    The provider-assigned unique ID for this managed resource.
    key string
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    id str
    The provider-assigned unique ID for this managed resource.
    key str
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.
    id String
    The provider-assigned unique ID for this managed resource.
    key String
    The unique key that identifies a relation between subsetting tables. The key is numeric and unique within a subsetting policy.
    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.
    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.

    Look up Existing SubsettingPolicySubsettingSchemaRelation Resource

    Get an existing SubsettingPolicySubsettingSchemaRelation resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: SubsettingPolicySubsettingSchemaRelationState, opts?: CustomResourceOptions): SubsettingPolicySubsettingSchemaRelation
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        child_columns: Optional[Sequence[str]] = None,
        child_object_key: Optional[str] = None,
        child_object_name: Optional[str] = None,
        child_schema_name: Optional[str] = None,
        key: Optional[str] = None,
        parent_columns: Optional[Sequence[str]] = None,
        parent_object_key: Optional[str] = None,
        parent_object_name: Optional[str] = None,
        parent_schema_name: Optional[str] = None,
        relation_type: Optional[str] = None,
        subsetting_policy_id: Optional[str] = None,
        time_created: Optional[str] = None,
        time_updated: Optional[str] = None) -> SubsettingPolicySubsettingSchemaRelation
    func GetSubsettingPolicySubsettingSchemaRelation(ctx *Context, name string, id IDInput, state *SubsettingPolicySubsettingSchemaRelationState, opts ...ResourceOption) (*SubsettingPolicySubsettingSchemaRelation, error)
    public static SubsettingPolicySubsettingSchemaRelation Get(string name, Input<string> id, SubsettingPolicySubsettingSchemaRelationState? state, CustomResourceOptions? opts = null)
    public static SubsettingPolicySubsettingSchemaRelation get(String name, Output<String> id, SubsettingPolicySubsettingSchemaRelationState state, CustomResourceOptions options)
    resources:  _:    type: oci:DataSafe:SubsettingPolicySubsettingSchemaRelation    get:      id: ${id}
    import {
  to = oci_data_safe_subsetting_policy_subsetting_schema_relation.example
  id = "${id}"
}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    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
    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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

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

    The OCID of the subsetting policy.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    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.

    Import

    SubsettingPolicySubsettingSchemaRelations can be imported using the id, e.g.

    $ pulumi import oci:DataSafe/subsettingPolicySubsettingSchemaRelation:SubsettingPolicySubsettingSchemaRelation test_subsetting_policy_subsetting_schema_relation "subsettingPolicies/{subsettingPolicyId}/subsettingSchemaRelations/{subsettingSchemaRelationKey}"

    To learn more about importing existing cloud resources, see Importing resources.

    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.5.0
    published on Thursday, Oct 22, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial