Oracle Cloud Infrastructure v2.28.0, Mar 27 25

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

oci.DataSafe.getSensitiveDataModelReferentialRelations

Explore with Pulumi AI

Oracle Cloud Infrastructure v2.28.0 published on Thursday, Mar 27, 2025 by Pulumi

Example Usage

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

const testSensitiveDataModelReferentialRelations = oci.DataSafe.getSensitiveDataModelReferentialRelations({
    sensitiveDataModelId: testSensitiveDataModel.id,
    columnNames: sensitiveDataModelReferentialRelationColumnName,
    isSensitive: sensitiveDataModelReferentialRelationIsSensitive,
    objects: sensitiveDataModelReferentialRelationObject,
    relationTypes: sensitiveDataModelReferentialRelationRelationType,
    schemaNames: sensitiveDataModelReferentialRelationSchemaName,
});

import pulumi
import pulumi_oci as oci

test_sensitive_data_model_referential_relations = oci.DataSafe.get_sensitive_data_model_referential_relations(sensitive_data_model_id=test_sensitive_data_model["id"],
    column_names=sensitive_data_model_referential_relation_column_name,
    is_sensitive=sensitive_data_model_referential_relation_is_sensitive,
    objects=sensitive_data_model_referential_relation_object,
    relation_types=sensitive_data_model_referential_relation_relation_type,
    schema_names=sensitive_data_model_referential_relation_schema_name)

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSensitiveDataModelReferentialRelations(ctx, &datasafe.GetSensitiveDataModelReferentialRelationsArgs{
			SensitiveDataModelId: testSensitiveDataModel.Id,
			ColumnNames:          sensitiveDataModelReferentialRelationColumnName,
			IsSensitive:          pulumi.BoolRef(sensitiveDataModelReferentialRelationIsSensitive),
			Objects:              sensitiveDataModelReferentialRelationObject,
			RelationTypes:        sensitiveDataModelReferentialRelationRelationType,
			SchemaNames:          sensitiveDataModelReferentialRelationSchemaName,
		}, 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 testSensitiveDataModelReferentialRelations = Oci.DataSafe.GetSensitiveDataModelReferentialRelations.Invoke(new()
    {
        SensitiveDataModelId = testSensitiveDataModel.Id,
        ColumnNames = sensitiveDataModelReferentialRelationColumnName,
        IsSensitive = sensitiveDataModelReferentialRelationIsSensitive,
        Objects = sensitiveDataModelReferentialRelationObject,
        RelationTypes = sensitiveDataModelReferentialRelationRelationType,
        SchemaNames = sensitiveDataModelReferentialRelationSchemaName,
    });

});

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.GetSensitiveDataModelReferentialRelationsArgs;
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 testSensitiveDataModelReferentialRelations = DataSafeFunctions.getSensitiveDataModelReferentialRelations(GetSensitiveDataModelReferentialRelationsArgs.builder()
            .sensitiveDataModelId(testSensitiveDataModel.id())
            .columnNames(sensitiveDataModelReferentialRelationColumnName)
            .isSensitive(sensitiveDataModelReferentialRelationIsSensitive)
            .objects(sensitiveDataModelReferentialRelationObject)
            .relationTypes(sensitiveDataModelReferentialRelationRelationType)
            .schemaNames(sensitiveDataModelReferentialRelationSchemaName)
            .build());

    }
}

variables:
  testSensitiveDataModelReferentialRelations:
    fn::invoke:
      function: oci:DataSafe:getSensitiveDataModelReferentialRelations
      arguments:
        sensitiveDataModelId: ${testSensitiveDataModel.id}
        columnNames: ${sensitiveDataModelReferentialRelationColumnName}
        isSensitive: ${sensitiveDataModelReferentialRelationIsSensitive}
        objects: ${sensitiveDataModelReferentialRelationObject}
        relationTypes: ${sensitiveDataModelReferentialRelationRelationType}
        schemaNames: ${sensitiveDataModelReferentialRelationSchemaName}

Using getSensitiveDataModelReferentialRelations

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 getSensitiveDataModelReferentialRelations(args: GetSensitiveDataModelReferentialRelationsArgs, opts?: InvokeOptions): Promise<GetSensitiveDataModelReferentialRelationsResult>
function getSensitiveDataModelReferentialRelationsOutput(args: GetSensitiveDataModelReferentialRelationsOutputArgs, opts?: InvokeOptions): Output<GetSensitiveDataModelReferentialRelationsResult>

def get_sensitive_data_model_referential_relations(column_names: Optional[Sequence[str]] = None,
                                                   filters: Optional[Sequence[_datasafe.GetSensitiveDataModelReferentialRelationsFilter]] = None,
                                                   is_sensitive: Optional[bool] = None,
                                                   objects: Optional[Sequence[str]] = None,
                                                   relation_types: Optional[Sequence[str]] = None,
                                                   schema_names: Optional[Sequence[str]] = None,
                                                   sensitive_data_model_id: Optional[str] = None,
                                                   opts: Optional[InvokeOptions] = None) -> GetSensitiveDataModelReferentialRelationsResult
def get_sensitive_data_model_referential_relations_output(column_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                                   filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetSensitiveDataModelReferentialRelationsFilterArgs]]]] = None,
                                                   is_sensitive: Optional[pulumi.Input[bool]] = None,
                                                   objects: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                                   relation_types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                                   schema_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                                   sensitive_data_model_id: Optional[pulumi.Input[str]] = None,
                                                   opts: Optional[InvokeOptions] = None) -> Output[GetSensitiveDataModelReferentialRelationsResult]

func GetSensitiveDataModelReferentialRelations(ctx *Context, args *GetSensitiveDataModelReferentialRelationsArgs, opts ...InvokeOption) (*GetSensitiveDataModelReferentialRelationsResult, error)
func GetSensitiveDataModelReferentialRelationsOutput(ctx *Context, args *GetSensitiveDataModelReferentialRelationsOutputArgs, opts ...InvokeOption) GetSensitiveDataModelReferentialRelationsResultOutput

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

public static class GetSensitiveDataModelReferentialRelations 
{
    public static Task<GetSensitiveDataModelReferentialRelationsResult> InvokeAsync(GetSensitiveDataModelReferentialRelationsArgs args, InvokeOptions? opts = null)
    public static Output<GetSensitiveDataModelReferentialRelationsResult> Invoke(GetSensitiveDataModelReferentialRelationsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetSensitiveDataModelReferentialRelationsResult> getSensitiveDataModelReferentialRelations(GetSensitiveDataModelReferentialRelationsArgs args, InvokeOptions options)
public static Output<GetSensitiveDataModelReferentialRelationsResult> getSensitiveDataModelReferentialRelations(GetSensitiveDataModelReferentialRelationsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:DataSafe/getSensitiveDataModelReferentialRelations:getSensitiveDataModelReferentialRelations
  arguments:
    # arguments dictionary

The following arguments are supported:

SensitiveDataModelId string: The OCID of the sensitive data model.
ColumnNames List<string>: A filter to return only a specific column based on column name.
Filters List<GetSensitiveDataModelReferentialRelationsFilter>
IsSensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Objects List<string>: A filter to return only items related to a specific object name.
RelationTypes List<string>: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
SchemaNames List<string>: A filter to return only items related to specific schema name.

SensitiveDataModelId string: The OCID of the sensitive data model.
ColumnNames []string: A filter to return only a specific column based on column name.
Filters []GetSensitiveDataModelReferentialRelationsFilter
IsSensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Objects []string: A filter to return only items related to a specific object name.
RelationTypes []string: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
SchemaNames []string: A filter to return only items related to specific schema name.

sensitiveDataModelId String: The OCID of the sensitive data model.
columnNames List<String>: A filter to return only a specific column based on column name.
filters List<GetSensitiveDataModelReferentialRelationsFilter>
isSensitive Boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
objects List<String>: A filter to return only items related to a specific object name.
relationTypes List<String>: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
schemaNames List<String>: A filter to return only items related to specific schema name.

sensitiveDataModelId string: The OCID of the sensitive data model.
columnNames string[]: A filter to return only a specific column based on column name.
filters GetSensitiveDataModelReferentialRelationsFilter[]
isSensitive boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
objects string[]: A filter to return only items related to a specific object name.
relationTypes string[]: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
schemaNames string[]: A filter to return only items related to specific schema name.

sensitive_data_model_id str: The OCID of the sensitive data model.
column_names Sequence[str]: A filter to return only a specific column based on column name.
filters Sequence[datasafe.GetSensitiveDataModelReferentialRelationsFilter]
is_sensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
objects Sequence[str]: A filter to return only items related to a specific object name.
relation_types Sequence[str]: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
schema_names Sequence[str]: A filter to return only items related to specific schema name.

sensitiveDataModelId String: The OCID of the sensitive data model.
columnNames List<String>: A filter to return only a specific column based on column name.
filters List<Property Map>
isSensitive Boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
objects List<String>: A filter to return only items related to a specific object name.
relationTypes List<String>: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
schemaNames List<String>: A filter to return only items related to specific schema name.

getSensitiveDataModelReferentialRelations Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
ReferentialRelationCollections List<GetSensitiveDataModelReferentialRelationsReferentialRelationCollection>: The list of referential_relation_collection.
SensitiveDataModelId string: The OCID of the sensitive data model that contains the sensitive column.
ColumnNames List<string>
Filters List<GetSensitiveDataModelReferentialRelationsFilter>
IsSensitive bool: Determines if the columns present in the referential relation is present in the sensitive data model
Objects List<string>: The database object that contains the columns.
RelationTypes List<string>: The type of referential relationship the sensitive 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.
SchemaNames List<string>: The schema name.

Id string: The provider-assigned unique ID for this managed resource.
ReferentialRelationCollections []GetSensitiveDataModelReferentialRelationsReferentialRelationCollection: The list of referential_relation_collection.
SensitiveDataModelId string: The OCID of the sensitive data model that contains the sensitive column.
ColumnNames []string
Filters []GetSensitiveDataModelReferentialRelationsFilter
IsSensitive bool: Determines if the columns present in the referential relation is present in the sensitive data model
Objects []string: The database object that contains the columns.
RelationTypes []string: The type of referential relationship the sensitive 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.
SchemaNames []string: The schema name.

id String: The provider-assigned unique ID for this managed resource.
referentialRelationCollections List<GetSensitiveDataModelReferentialRelationsReferentialRelationCollection>: The list of referential_relation_collection.
sensitiveDataModelId String: The OCID of the sensitive data model that contains the sensitive column.
columnNames List<String>
filters List<GetSensitiveDataModelReferentialRelationsFilter>
isSensitive Boolean: Determines if the columns present in the referential relation is present in the sensitive data model
objects List<String>: The database object that contains the columns.
relationTypes List<String>: The type of referential relationship the sensitive 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.
schemaNames List<String>: The schema name.

id string: The provider-assigned unique ID for this managed resource.
referentialRelationCollections GetSensitiveDataModelReferentialRelationsReferentialRelationCollection[]: The list of referential_relation_collection.
sensitiveDataModelId string: The OCID of the sensitive data model that contains the sensitive column.
columnNames string[]
filters GetSensitiveDataModelReferentialRelationsFilter[]
isSensitive boolean: Determines if the columns present in the referential relation is present in the sensitive data model
objects string[]: The database object that contains the columns.
relationTypes string[]: The type of referential relationship the sensitive 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.
schemaNames string[]: The schema name.

id str: The provider-assigned unique ID for this managed resource.
referential_relation_collections Sequence[datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollection]: The list of referential_relation_collection.
sensitive_data_model_id str: The OCID of the sensitive data model that contains the sensitive column.
column_names Sequence[str]
filters Sequence[datasafe.GetSensitiveDataModelReferentialRelationsFilter]
is_sensitive bool: Determines if the columns present in the referential relation is present in the sensitive data model
objects Sequence[str]: The database object that contains the columns.
relation_types Sequence[str]: The type of referential relationship the sensitive 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.
schema_names Sequence[str]: The schema name.

id String: The provider-assigned unique ID for this managed resource.
referentialRelationCollections List<Property Map>: The list of referential_relation_collection.
sensitiveDataModelId String: The OCID of the sensitive data model that contains the sensitive column.
columnNames List<String>
filters List<Property Map>
isSensitive Boolean: Determines if the columns present in the referential relation is present in the sensitive data model
objects List<String>: The database object that contains the columns.
relationTypes List<String>: The type of referential relationship the sensitive 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.
schemaNames List<String>: The schema name.

Supporting Types

GetSensitiveDataModelReferentialRelationsFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetSensitiveDataModelReferentialRelationsReferentialRelationCollection

Items List<GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem>

Items []GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem

items List<GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem>

items GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem[]

items Sequence[datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem]

items List<Property Map>

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem

Child GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild: columnsInfo object has details of column group with schema details.
IsSensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Key string: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
Parent GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent: columnsInfo object has details of column group with schema details.
RelationType string: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
SensitiveDataModelId string: The OCID of the sensitive data model.
State string: The current state of the referential relation.

Child GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild: columnsInfo object has details of column group with schema details.
IsSensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Key string: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
Parent GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent: columnsInfo object has details of column group with schema details.
RelationType string: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
SensitiveDataModelId string: The OCID of the sensitive data model.
State string: The current state of the referential relation.

child GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild: columnsInfo object has details of column group with schema details.
isSensitive Boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key String: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent: columnsInfo object has details of column group with schema details.
relationType String: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
sensitiveDataModelId String: The OCID of the sensitive data model.
state String: The current state of the referential relation.

child GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild: columnsInfo object has details of column group with schema details.
isSensitive boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key string: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent: columnsInfo object has details of column group with schema details.
relationType string: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
sensitiveDataModelId string: The OCID of the sensitive data model.
state string: The current state of the referential relation.

child datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild: columnsInfo object has details of column group with schema details.
is_sensitive bool: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key str: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent: columnsInfo object has details of column group with schema details.
relation_type str: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
sensitive_data_model_id str: The OCID of the sensitive data model.
state str: The current state of the referential relation.

child Property Map: columnsInfo object has details of column group with schema details.
isSensitive Boolean: Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key String: The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent Property Map: columnsInfo object has details of column group with schema details.
relationType String: A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.
sensitiveDataModelId String: The OCID of the sensitive data model.
state String: The current state of the referential relation.

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild

AppName string: The application name.
ColumnGroups List<string>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object string: A filter to return only items related to a specific object name.
ObjectType string: The type of the database object that contains the sensitive column.
SchemaName string: A filter to return only items related to specific schema name.
SensitiveTypeIds List<string>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

AppName string: The application name.
ColumnGroups []string: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object string: A filter to return only items related to a specific object name.
ObjectType string: The type of the database object that contains the sensitive column.
SchemaName string: A filter to return only items related to specific schema name.
SensitiveTypeIds []string: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName String: The application name.
columnGroups List<String>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object String: A filter to return only items related to a specific object name.
objectType String: The type of the database object that contains the sensitive column.
schemaName String: A filter to return only items related to specific schema name.
sensitiveTypeIds List<String>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName string: The application name.
columnGroups string[]: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object string: A filter to return only items related to a specific object name.
objectType string: The type of the database object that contains the sensitive column.
schemaName string: A filter to return only items related to specific schema name.
sensitiveTypeIds string[]: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

app_name str: The application name.
column_groups Sequence[str]: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object str: A filter to return only items related to a specific object name.
object_type str: The type of the database object that contains the sensitive column.
schema_name str: A filter to return only items related to specific schema name.
sensitive_type_ids Sequence[str]: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName String: The application name.
columnGroups List<String>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object String: A filter to return only items related to a specific object name.
objectType String: The type of the database object that contains the sensitive column.
schemaName String: A filter to return only items related to specific schema name.
sensitiveTypeIds List<String>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent

AppName string: The application name.
ColumnGroups List<string>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object string: A filter to return only items related to a specific object name.
ObjectType string: The type of the database object that contains the sensitive column.
SchemaName string: A filter to return only items related to specific schema name.
SensitiveTypeIds List<string>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

AppName string: The application name.
ColumnGroups []string: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object string: A filter to return only items related to a specific object name.
ObjectType string: The type of the database object that contains the sensitive column.
SchemaName string: A filter to return only items related to specific schema name.
SensitiveTypeIds []string: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName String: The application name.
columnGroups List<String>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object String: A filter to return only items related to a specific object name.
objectType String: The type of the database object that contains the sensitive column.
schemaName String: A filter to return only items related to specific schema name.
sensitiveTypeIds List<String>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName string: The application name.
columnGroups string[]: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object string: A filter to return only items related to a specific object name.
objectType string: The type of the database object that contains the sensitive column.
schemaName string: A filter to return only items related to specific schema name.
sensitiveTypeIds string[]: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

app_name str: The application name.
column_groups Sequence[str]: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object str: A filter to return only items related to a specific object name.
object_type str: The type of the database object that contains the sensitive column.
schema_name str: A filter to return only items related to specific schema name.
sensitive_type_ids Sequence[str]: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

appName String: The application name.
columnGroups List<String>: Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object String: A filter to return only items related to a specific object name.
objectType String: The type of the database object that contains the sensitive column.
schemaName String: A filter to return only items related to specific schema name.
sensitiveTypeIds List<String>: Sensitive type ocids of each column groups. Order needs to be maintained with the parent column group. For the DB defined referential relations identified during SDM creation, we cannot add sensitive types. Instead use the sensitiveColumn POST API to mark the columns sensitive.

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.28.0 published on Thursday, Mar 27, 2025 by Pulumi

pulumi/pulumi-oci

oci.DataSafe.getSensitiveDataModelReferentialRelations

On this page

On this page

Example Usage

Using getSensitiveDataModelReferentialRelations

getSensitiveDataModelReferentialRelations Result

Supporting Types

GetSensitiveDataModelReferentialRelationsFilter

GetSensitiveDataModelReferentialRelationsReferentialRelationCollection

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent

Package Details

On this page

On this page