1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSensitiveDataModelReferentialRelations
Oracle Cloud Infrastructure v2.30.0 published on Monday, Apr 14, 2025 by Pulumi

oci.DataSafe.getSensitiveDataModelReferentialRelations

Explore with Pulumi AI

This data source provides the list of Sensitive Data Model Referential Relations in Oracle Cloud Infrastructure Data Safe service.

Gets a list of referential relations present in the specified sensitive data model based on the specified query parameters.

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,
});
Copy
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)
Copy
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
	})
}
Copy
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,
    });

});
Copy
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());

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

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>
Copy
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]
Copy
func GetSensitiveDataModelReferentialRelations(ctx *Context, args *GetSensitiveDataModelReferentialRelationsArgs, opts ...InvokeOption) (*GetSensitiveDataModelReferentialRelationsResult, error)
func GetSensitiveDataModelReferentialRelationsOutput(ctx *Context, args *GetSensitiveDataModelReferentialRelationsOutputArgs, opts ...InvokeOption) GetSensitiveDataModelReferentialRelationsResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetSensitiveDataModelReferentialRelationsResult> getSensitiveDataModelReferentialRelations(GetSensitiveDataModelReferentialRelationsArgs args, InvokeOptions options)
public static Output<GetSensitiveDataModelReferentialRelationsResult> getSensitiveDataModelReferentialRelations(GetSensitiveDataModelReferentialRelationsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: oci:DataSafe/getSensitiveDataModelReferentialRelations:getSensitiveDataModelReferentialRelations
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

SensitiveDataModelId This property is required. string
The OCID of the sensitive data model.
ColumnNames List<string>
A filter to return only a specific column based on column name.
Filters Changes to this property will trigger replacement. 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 This property is required. string
The OCID of the sensitive data model.
ColumnNames []string
A filter to return only a specific column based on column name.
Filters Changes to this property will trigger replacement. []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 This property is required. String
The OCID of the sensitive data model.
columnNames List<String>
A filter to return only a specific column based on column name.
filters Changes to this property will trigger replacement. 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 This property is required. string
The OCID of the sensitive data model.
columnNames string[]
A filter to return only a specific column based on column name.
filters Changes to this property will trigger replacement. 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 This property is required. 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 Changes to this property will trigger replacement. 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 This property is required. String
The OCID of the sensitive data model.
columnNames List<String>
A filter to return only a specific column based on column name.
filters Changes to this property will trigger replacement. 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 This property is required. string
Values This property is required. List<string>
Regex bool
Name This property is required. string
Values This property is required. []string
Regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean
name This property is required. string
values This property is required. string[]
regex boolean
name This property is required. str
values This property is required. Sequence[str]
regex bool
name This property is required. String
values This property is required. List<String>
regex Boolean

GetSensitiveDataModelReferentialRelationsReferentialRelationCollection

items This property is required. List<Property Map>

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItem

Child This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild
columnsInfo object has details of column group with schema details.
IsSensitive This property is required. bool
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Key This property is required. string
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
Parent This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent
columnsInfo object has details of column group with schema details.
RelationType This property is required. 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 This property is required. string
The OCID of the sensitive data model.
State This property is required. string
The current state of the referential relation.
Child This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild
columnsInfo object has details of column group with schema details.
IsSensitive This property is required. bool
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
Key This property is required. string
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
Parent This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent
columnsInfo object has details of column group with schema details.
RelationType This property is required. 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 This property is required. string
The OCID of the sensitive data model.
State This property is required. string
The current state of the referential relation.
child This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild
columnsInfo object has details of column group with schema details.
isSensitive This property is required. Boolean
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key This property is required. String
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent
columnsInfo object has details of column group with schema details.
relationType This property is required. 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 This property is required. String
The OCID of the sensitive data model.
state This property is required. String
The current state of the referential relation.
child This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild
columnsInfo object has details of column group with schema details.
isSensitive This property is required. boolean
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key This property is required. string
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent This property is required. GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent
columnsInfo object has details of column group with schema details.
relationType This property is required. 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 This property is required. string
The OCID of the sensitive data model.
state This property is required. string
The current state of the referential relation.
child This property is required. datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild
columnsInfo object has details of column group with schema details.
is_sensitive This property is required. bool
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key This property is required. str
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent This property is required. datasafe.GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemParent
columnsInfo object has details of column group with schema details.
relation_type This property is required. 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 This property is required. str
The OCID of the sensitive data model.
state This property is required. str
The current state of the referential relation.
child This property is required. Property Map
columnsInfo object has details of column group with schema details.
isSensitive This property is required. Boolean
Returns referential relations containing sensitive columns when true. Returns referential relations containing non sensitive columns when false.
key This property is required. String
The unique key that identifies the referential relation. It's numeric and unique within a sensitive data model.
parent This property is required. Property Map
columnsInfo object has details of column group with schema details.
relationType This property is required. 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 This property is required. String
The OCID of the sensitive data model.
state This property is required. String
The current state of the referential relation.

GetSensitiveDataModelReferentialRelationsReferentialRelationCollectionItemChild

AppName This property is required. string
The application name.
ColumnGroups This property is required. List<string>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object This property is required. string
A filter to return only items related to a specific object name.
ObjectType This property is required. string
The type of the database object that contains the sensitive column.
SchemaName This property is required. string
A filter to return only items related to specific schema name.
SensitiveTypeIds This property is required. 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 This property is required. string
The application name.
ColumnGroups This property is required. []string
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object This property is required. string
A filter to return only items related to a specific object name.
ObjectType This property is required. string
The type of the database object that contains the sensitive column.
SchemaName This property is required. string
A filter to return only items related to specific schema name.
SensitiveTypeIds This property is required. []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 This property is required. String
The application name.
columnGroups This property is required. List<String>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. String
A filter to return only items related to a specific object name.
objectType This property is required. String
The type of the database object that contains the sensitive column.
schemaName This property is required. String
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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 This property is required. string
The application name.
columnGroups This property is required. string[]
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. string
A filter to return only items related to a specific object name.
objectType This property is required. string
The type of the database object that contains the sensitive column.
schemaName This property is required. string
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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 This property is required. str
The application name.
column_groups This property is required. Sequence[str]
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. str
A filter to return only items related to a specific object name.
object_type This property is required. str
The type of the database object that contains the sensitive column.
schema_name This property is required. str
A filter to return only items related to specific schema name.
sensitive_type_ids This property is required. 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 This property is required. String
The application name.
columnGroups This property is required. List<String>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. String
A filter to return only items related to a specific object name.
objectType This property is required. String
The type of the database object that contains the sensitive column.
schemaName This property is required. String
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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 This property is required. string
The application name.
ColumnGroups This property is required. List<string>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object This property is required. string
A filter to return only items related to a specific object name.
ObjectType This property is required. string
The type of the database object that contains the sensitive column.
SchemaName This property is required. string
A filter to return only items related to specific schema name.
SensitiveTypeIds This property is required. 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 This property is required. string
The application name.
ColumnGroups This property is required. []string
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
Object This property is required. string
A filter to return only items related to a specific object name.
ObjectType This property is required. string
The type of the database object that contains the sensitive column.
SchemaName This property is required. string
A filter to return only items related to specific schema name.
SensitiveTypeIds This property is required. []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 This property is required. String
The application name.
columnGroups This property is required. List<String>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. String
A filter to return only items related to a specific object name.
objectType This property is required. String
The type of the database object that contains the sensitive column.
schemaName This property is required. String
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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 This property is required. string
The application name.
columnGroups This property is required. string[]
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. string
A filter to return only items related to a specific object name.
objectType This property is required. string
The type of the database object that contains the sensitive column.
schemaName This property is required. string
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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 This property is required. str
The application name.
column_groups This property is required. Sequence[str]
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. str
A filter to return only items related to a specific object name.
object_type This property is required. str
The type of the database object that contains the sensitive column.
schema_name This property is required. str
A filter to return only items related to specific schema name.
sensitive_type_ids This property is required. 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 This property is required. String
The application name.
columnGroups This property is required. List<String>
Group of columns in referential relation. Order needs to be maintained in the elements of the parent/child array listing.
object This property is required. String
A filter to return only items related to a specific object name.
objectType This property is required. String
The type of the database object that contains the sensitive column.
schemaName This property is required. String
A filter to return only items related to specific schema name.
sensitiveTypeIds This property is required. 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.