Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getMaskingPoliciesMaskingColumns
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getMaskingPoliciesMaskingColumns

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of Masking Policies Masking Columns in Oracle Cloud Infrastructure Data Safe service.

    Gets a list of masking columns present in the specified masking policy and based on the specified query parameters.

    Example Usage

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

const testMaskingPoliciesMaskingColumns = oci.DataSafe.getMaskingPoliciesMaskingColumns({
    maskingPolicyId: testMaskingPolicy.id,
    columnNames: maskingPoliciesMaskingColumnColumnName,
    dataTypes: maskingPoliciesMaskingColumnDataType,
    isMaskingEnabled: maskingPoliciesMaskingColumnIsMaskingEnabled,
    isSeedRequired: maskingPoliciesMaskingColumnIsSeedRequired,
    maskingColumnGroups: maskingPoliciesMaskingColumnMaskingColumnGroup,
    maskingColumnLifecycleState: maskingPoliciesMaskingColumnMaskingColumnLifecycleState,
    objects: maskingPoliciesMaskingColumnObject,
    objectTypes: maskingPoliciesMaskingColumnObjectType,
    schemaNames: maskingPoliciesMaskingColumnSchemaName,
    sensitiveTypeId: testSensitiveType.id,
    timeCreatedGreaterThanOrEqualTo: maskingPoliciesMaskingColumnTimeCreatedGreaterThanOrEqualTo,
    timeCreatedLessThan: maskingPoliciesMaskingColumnTimeCreatedLessThan,
    timeUpdatedGreaterThanOrEqualTo: maskingPoliciesMaskingColumnTimeUpdatedGreaterThanOrEqualTo,
    timeUpdatedLessThan: maskingPoliciesMaskingColumnTimeUpdatedLessThan,
});

    import pulumi
import pulumi_oci as oci

test_masking_policies_masking_columns = oci.DataSafe.get_masking_policies_masking_columns(masking_policy_id=test_masking_policy["id"],
    column_names=masking_policies_masking_column_column_name,
    data_types=masking_policies_masking_column_data_type,
    is_masking_enabled=masking_policies_masking_column_is_masking_enabled,
    is_seed_required=masking_policies_masking_column_is_seed_required,
    masking_column_groups=masking_policies_masking_column_masking_column_group,
    masking_column_lifecycle_state=masking_policies_masking_column_masking_column_lifecycle_state,
    objects=masking_policies_masking_column_object,
    object_types=masking_policies_masking_column_object_type,
    schema_names=masking_policies_masking_column_schema_name,
    sensitive_type_id=test_sensitive_type["id"],
    time_created_greater_than_or_equal_to=masking_policies_masking_column_time_created_greater_than_or_equal_to,
    time_created_less_than=masking_policies_masking_column_time_created_less_than,
    time_updated_greater_than_or_equal_to=masking_policies_masking_column_time_updated_greater_than_or_equal_to,
    time_updated_less_than=masking_policies_masking_column_time_updated_less_than)

    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.GetMaskingPoliciesMaskingColumns(ctx, &datasafe.GetMaskingPoliciesMaskingColumnsArgs{
			MaskingPolicyId:                 testMaskingPolicy.Id,
			ColumnNames:                     maskingPoliciesMaskingColumnColumnName,
			DataTypes:                       maskingPoliciesMaskingColumnDataType,
			IsMaskingEnabled:                pulumi.BoolRef(maskingPoliciesMaskingColumnIsMaskingEnabled),
			IsSeedRequired:                  pulumi.BoolRef(maskingPoliciesMaskingColumnIsSeedRequired),
			MaskingColumnGroups:             maskingPoliciesMaskingColumnMaskingColumnGroup,
			MaskingColumnLifecycleState:     pulumi.StringRef(maskingPoliciesMaskingColumnMaskingColumnLifecycleState),
			Objects:                         maskingPoliciesMaskingColumnObject,
			ObjectTypes:                     maskingPoliciesMaskingColumnObjectType,
			SchemaNames:                     maskingPoliciesMaskingColumnSchemaName,
			SensitiveTypeId:                 pulumi.StringRef(testSensitiveType.Id),
			TimeCreatedGreaterThanOrEqualTo: pulumi.StringRef(maskingPoliciesMaskingColumnTimeCreatedGreaterThanOrEqualTo),
			TimeCreatedLessThan:             pulumi.StringRef(maskingPoliciesMaskingColumnTimeCreatedLessThan),
			TimeUpdatedGreaterThanOrEqualTo: pulumi.StringRef(maskingPoliciesMaskingColumnTimeUpdatedGreaterThanOrEqualTo),
			TimeUpdatedLessThan:             pulumi.StringRef(maskingPoliciesMaskingColumnTimeUpdatedLessThan),
		}, 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 testMaskingPoliciesMaskingColumns = Oci.DataSafe.GetMaskingPoliciesMaskingColumns.Invoke(new()
    {
        MaskingPolicyId = testMaskingPolicy.Id,
        ColumnNames = maskingPoliciesMaskingColumnColumnName,
        DataTypes = maskingPoliciesMaskingColumnDataType,
        IsMaskingEnabled = maskingPoliciesMaskingColumnIsMaskingEnabled,
        IsSeedRequired = maskingPoliciesMaskingColumnIsSeedRequired,
        MaskingColumnGroups = maskingPoliciesMaskingColumnMaskingColumnGroup,
        MaskingColumnLifecycleState = maskingPoliciesMaskingColumnMaskingColumnLifecycleState,
        Objects = maskingPoliciesMaskingColumnObject,
        ObjectTypes = maskingPoliciesMaskingColumnObjectType,
        SchemaNames = maskingPoliciesMaskingColumnSchemaName,
        SensitiveTypeId = testSensitiveType.Id,
        TimeCreatedGreaterThanOrEqualTo = maskingPoliciesMaskingColumnTimeCreatedGreaterThanOrEqualTo,
        TimeCreatedLessThan = maskingPoliciesMaskingColumnTimeCreatedLessThan,
        TimeUpdatedGreaterThanOrEqualTo = maskingPoliciesMaskingColumnTimeUpdatedGreaterThanOrEqualTo,
        TimeUpdatedLessThan = maskingPoliciesMaskingColumnTimeUpdatedLessThan,
    });

});

    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.GetMaskingPoliciesMaskingColumnsArgs;
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 testMaskingPoliciesMaskingColumns = DataSafeFunctions.getMaskingPoliciesMaskingColumns(GetMaskingPoliciesMaskingColumnsArgs.builder()
            .maskingPolicyId(testMaskingPolicy.id())
            .columnNames(maskingPoliciesMaskingColumnColumnName)
            .dataTypes(maskingPoliciesMaskingColumnDataType)
            .isMaskingEnabled(maskingPoliciesMaskingColumnIsMaskingEnabled)
            .isSeedRequired(maskingPoliciesMaskingColumnIsSeedRequired)
            .maskingColumnGroups(maskingPoliciesMaskingColumnMaskingColumnGroup)
            .maskingColumnLifecycleState(maskingPoliciesMaskingColumnMaskingColumnLifecycleState)
            .objects(maskingPoliciesMaskingColumnObject)
            .objectTypes(maskingPoliciesMaskingColumnObjectType)
            .schemaNames(maskingPoliciesMaskingColumnSchemaName)
            .sensitiveTypeId(testSensitiveType.id())
            .timeCreatedGreaterThanOrEqualTo(maskingPoliciesMaskingColumnTimeCreatedGreaterThanOrEqualTo)
            .timeCreatedLessThan(maskingPoliciesMaskingColumnTimeCreatedLessThan)
            .timeUpdatedGreaterThanOrEqualTo(maskingPoliciesMaskingColumnTimeUpdatedGreaterThanOrEqualTo)
            .timeUpdatedLessThan(maskingPoliciesMaskingColumnTimeUpdatedLessThan)
            .build());

    }
}

    variables:
  testMaskingPoliciesMaskingColumns:
    fn::invoke:
      function: oci:DataSafe:getMaskingPoliciesMaskingColumns
      arguments:
        maskingPolicyId: ${testMaskingPolicy.id}
        columnNames: ${maskingPoliciesMaskingColumnColumnName}
        dataTypes: ${maskingPoliciesMaskingColumnDataType}
        isMaskingEnabled: ${maskingPoliciesMaskingColumnIsMaskingEnabled}
        isSeedRequired: ${maskingPoliciesMaskingColumnIsSeedRequired}
        maskingColumnGroups: ${maskingPoliciesMaskingColumnMaskingColumnGroup}
        maskingColumnLifecycleState: ${maskingPoliciesMaskingColumnMaskingColumnLifecycleState}
        objects: ${maskingPoliciesMaskingColumnObject}
        objectTypes: ${maskingPoliciesMaskingColumnObjectType}
        schemaNames: ${maskingPoliciesMaskingColumnSchemaName}
        sensitiveTypeId: ${testSensitiveType.id}
        timeCreatedGreaterThanOrEqualTo: ${maskingPoliciesMaskingColumnTimeCreatedGreaterThanOrEqualTo}
        timeCreatedLessThan: ${maskingPoliciesMaskingColumnTimeCreatedLessThan}
        timeUpdatedGreaterThanOrEqualTo: ${maskingPoliciesMaskingColumnTimeUpdatedGreaterThanOrEqualTo}
        timeUpdatedLessThan: ${maskingPoliciesMaskingColumnTimeUpdatedLessThan}

    Using getMaskingPoliciesMaskingColumns

    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 getMaskingPoliciesMaskingColumns(args: GetMaskingPoliciesMaskingColumnsArgs, opts?: InvokeOptions): Promise<GetMaskingPoliciesMaskingColumnsResult>
function getMaskingPoliciesMaskingColumnsOutput(args: GetMaskingPoliciesMaskingColumnsOutputArgs, opts?: InvokeOptions): Output<GetMaskingPoliciesMaskingColumnsResult>
    def get_masking_policies_masking_columns(column_names: Optional[Sequence[str]] = None,
                                         data_types: Optional[Sequence[str]] = None,
                                         filters: Optional[Sequence[GetMaskingPoliciesMaskingColumnsFilter]] = None,
                                         is_masking_enabled: Optional[bool] = None,
                                         is_seed_required: Optional[bool] = None,
                                         masking_column_groups: Optional[Sequence[str]] = None,
                                         masking_column_lifecycle_state: Optional[str] = None,
                                         masking_policy_id: Optional[str] = None,
                                         object_types: Optional[Sequence[str]] = None,
                                         objects: Optional[Sequence[str]] = None,
                                         schema_names: Optional[Sequence[str]] = None,
                                         sensitive_type_id: Optional[str] = None,
                                         time_created_greater_than_or_equal_to: Optional[str] = None,
                                         time_created_less_than: Optional[str] = None,
                                         time_updated_greater_than_or_equal_to: Optional[str] = None,
                                         time_updated_less_than: Optional[str] = None,
                                         opts: Optional[InvokeOptions] = None) -> GetMaskingPoliciesMaskingColumnsResult
def get_masking_policies_masking_columns_output(column_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         data_types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetMaskingPoliciesMaskingColumnsFilterArgs]]]] = None,
                                         is_masking_enabled: Optional[pulumi.Input[bool]] = None,
                                         is_seed_required: Optional[pulumi.Input[bool]] = None,
                                         masking_column_groups: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         masking_column_lifecycle_state: Optional[pulumi.Input[str]] = None,
                                         masking_policy_id: Optional[pulumi.Input[str]] = None,
                                         object_types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         objects: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         schema_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                         sensitive_type_id: Optional[pulumi.Input[str]] = None,
                                         time_created_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                         time_created_less_than: Optional[pulumi.Input[str]] = None,
                                         time_updated_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                                         time_updated_less_than: Optional[pulumi.Input[str]] = None,
                                         opts: Optional[InvokeOptions] = None) -> Output[GetMaskingPoliciesMaskingColumnsResult]
    func GetMaskingPoliciesMaskingColumns(ctx *Context, args *GetMaskingPoliciesMaskingColumnsArgs, opts ...InvokeOption) (*GetMaskingPoliciesMaskingColumnsResult, error)
func GetMaskingPoliciesMaskingColumnsOutput(ctx *Context, args *GetMaskingPoliciesMaskingColumnsOutputArgs, opts ...InvokeOption) GetMaskingPoliciesMaskingColumnsResultOutput

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

    public static class GetMaskingPoliciesMaskingColumns 
{
    public static Task<GetMaskingPoliciesMaskingColumnsResult> InvokeAsync(GetMaskingPoliciesMaskingColumnsArgs args, InvokeOptions? opts = null)
    public static Output<GetMaskingPoliciesMaskingColumnsResult> Invoke(GetMaskingPoliciesMaskingColumnsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetMaskingPoliciesMaskingColumnsResult> getMaskingPoliciesMaskingColumns(GetMaskingPoliciesMaskingColumnsArgs args, InvokeOptions options)
public static Output<GetMaskingPoliciesMaskingColumnsResult> getMaskingPoliciesMaskingColumns(GetMaskingPoliciesMaskingColumnsArgs args, InvokeOptions options)

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

    The following arguments are supported:

    MaskingPolicyId string
    The OCID of the masking policy.
    ColumnNames List<string>
    A filter to return only a specific column based on column name.
    DataTypes List<string>
    A filter to return only resources that match the specified data types.
    Filters List<GetMaskingPoliciesMaskingColumnsFilter>
    IsMaskingEnabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    IsSeedRequired bool
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    MaskingColumnGroups List<string>
    A filter to return only the resources that match the specified masking column group.
    MaskingColumnLifecycleState string
    A filter to return only the resources that match the specified lifecycle states.
    ObjectTypes List<string>
    A filter to return only items related to a specific object type.
    Objects List<string>
    A filter to return only items related to a specific object name.
    SchemaNames List<string>
    A filter to return only items related to specific schema name.
    SensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    TimeCreatedGreaterThanOrEqualTo string

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    TimeCreatedLessThan string

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    TimeUpdatedGreaterThanOrEqualTo string
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    TimeUpdatedLessThan string
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    MaskingPolicyId string
    The OCID of the masking policy.
    ColumnNames []string
    A filter to return only a specific column based on column name.
    DataTypes []string
    A filter to return only resources that match the specified data types.
    Filters []GetMaskingPoliciesMaskingColumnsFilter
    IsMaskingEnabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    IsSeedRequired bool
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    MaskingColumnGroups []string
    A filter to return only the resources that match the specified masking column group.
    MaskingColumnLifecycleState string
    A filter to return only the resources that match the specified lifecycle states.
    ObjectTypes []string
    A filter to return only items related to a specific object type.
    Objects []string
    A filter to return only items related to a specific object name.
    SchemaNames []string
    A filter to return only items related to specific schema name.
    SensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    TimeCreatedGreaterThanOrEqualTo string

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    TimeCreatedLessThan string

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    TimeUpdatedGreaterThanOrEqualTo string
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    TimeUpdatedLessThan string
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    maskingPolicyId String
    The OCID of the masking policy.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    dataTypes List<String>
    A filter to return only resources that match the specified data types.
    filters List<GetMaskingPoliciesMaskingColumnsFilter>
    isMaskingEnabled Boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    isSeedRequired Boolean
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    maskingColumnGroups List<String>
    A filter to return only the resources that match the specified masking column group.
    maskingColumnLifecycleState String
    A filter to return only the resources that match the specified lifecycle states.
    objectTypes List<String>
    A filter to return only items related to a specific object type.
    objects List<String>
    A filter to return only items related to a specific object name.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    sensitiveTypeId String
    A filter to return only items related to a specific sensitive type OCID.
    timeCreatedGreaterThanOrEqualTo String

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    timeCreatedLessThan String

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    timeUpdatedGreaterThanOrEqualTo String
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    timeUpdatedLessThan String
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    maskingPolicyId string
    The OCID of the masking policy.
    columnNames string[]
    A filter to return only a specific column based on column name.
    dataTypes string[]
    A filter to return only resources that match the specified data types.
    filters GetMaskingPoliciesMaskingColumnsFilter[]
    isMaskingEnabled boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    isSeedRequired boolean
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    maskingColumnGroups string[]
    A filter to return only the resources that match the specified masking column group.
    maskingColumnLifecycleState string
    A filter to return only the resources that match the specified lifecycle states.
    objectTypes string[]
    A filter to return only items related to a specific object type.
    objects string[]
    A filter to return only items related to a specific object name.
    schemaNames string[]
    A filter to return only items related to specific schema name.
    sensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    timeCreatedGreaterThanOrEqualTo string

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    timeCreatedLessThan string

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    timeUpdatedGreaterThanOrEqualTo string
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    timeUpdatedLessThan string
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    masking_policy_id str
    The OCID of the masking policy.
    column_names Sequence[str]
    A filter to return only a specific column based on column name.
    data_types Sequence[str]
    A filter to return only resources that match the specified data types.
    filters Sequence[GetMaskingPoliciesMaskingColumnsFilter]
    is_masking_enabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    is_seed_required bool
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    masking_column_groups Sequence[str]
    A filter to return only the resources that match the specified masking column group.
    masking_column_lifecycle_state str
    A filter to return only the resources that match the specified lifecycle states.
    object_types Sequence[str]
    A filter to return only items related to a specific object type.
    objects Sequence[str]
    A filter to return only items related to a specific object name.
    schema_names Sequence[str]
    A filter to return only items related to specific schema name.
    sensitive_type_id str
    A filter to return only items related to a specific sensitive type OCID.
    time_created_greater_than_or_equal_to str

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    time_created_less_than str

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    time_updated_greater_than_or_equal_to str
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    time_updated_less_than str
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    maskingPolicyId String
    The OCID of the masking policy.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    dataTypes List<String>
    A filter to return only resources that match the specified data types.
    filters List<Property Map>
    isMaskingEnabled Boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    isSeedRequired Boolean
    A filter to return masking columns based on whether the assigned masking formats need a seed value for masking. A value of true returns those masking columns that are using Deterministic Encryption or Deterministic Substitution masking format.
    maskingColumnGroups List<String>
    A filter to return only the resources that match the specified masking column group.
    maskingColumnLifecycleState String
    A filter to return only the resources that match the specified lifecycle states.
    objectTypes List<String>
    A filter to return only items related to a specific object type.
    objects List<String>
    A filter to return only items related to a specific object name.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    sensitiveTypeId String
    A filter to return only items related to a specific sensitive type OCID.
    timeCreatedGreaterThanOrEqualTo String

    A filter to return only the resources that were created after the specified date and time, as defined by RFC3339. Using TimeCreatedGreaterThanOrEqualToQueryParam parameter retrieves all resources created after that date.

    Example: 2016-12-19T16:39:57.600Z

    timeCreatedLessThan String

    Search for resources that were created before a specific date. Specifying this parameter corresponding timeCreatedLessThan parameter will retrieve all resources created before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    Example: 2016-12-19T16:39:57.600Z

    timeUpdatedGreaterThanOrEqualTo String
    Search for resources that were updated after a specific date. Specifying this parameter corresponding timeUpdatedGreaterThanOrEqualTo parameter will retrieve all resources updated after the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.
    timeUpdatedLessThan String
    Search for resources that were updated before a specific date. Specifying this parameter corresponding timeUpdatedLessThan parameter will retrieve all resources updated before the specified created date, in "YYYY-MM-ddThh:mmZ" format with a Z offset, as defined by RFC 3339.

    getMaskingPoliciesMaskingColumns Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    MaskingColumnCollections List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollection>
    The list of masking_column_collection.
    MaskingPolicyId string
    The OCID of the masking policy that contains the masking column.
    ColumnNames List<string>
    The name of the substitution column.
    DataTypes List<string>
    The data type of the masking column.
    Filters List<GetMaskingPoliciesMaskingColumnsFilter>
    IsMaskingEnabled bool
    Indicates whether data masking is enabled for the masking column.
    IsSeedRequired bool
    MaskingColumnGroups List<string>
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    MaskingColumnLifecycleState string
    ObjectTypes List<string>
    The type of the object that contains the database column.
    Objects List<string>
    The name of the object (table or editioning view) that contains the database column.
    SchemaNames List<string>
    The name of the schema that contains the database column.
    SensitiveTypeId string
    The OCID of the sensitive type associated with the masking column.
    TimeCreatedGreaterThanOrEqualTo string
    TimeCreatedLessThan string
    TimeUpdatedGreaterThanOrEqualTo string
    TimeUpdatedLessThan string
    Id string
    The provider-assigned unique ID for this managed resource.
    MaskingColumnCollections []GetMaskingPoliciesMaskingColumnsMaskingColumnCollection
    The list of masking_column_collection.
    MaskingPolicyId string
    The OCID of the masking policy that contains the masking column.
    ColumnNames []string
    The name of the substitution column.
    DataTypes []string
    The data type of the masking column.
    Filters []GetMaskingPoliciesMaskingColumnsFilter
    IsMaskingEnabled bool
    Indicates whether data masking is enabled for the masking column.
    IsSeedRequired bool
    MaskingColumnGroups []string
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    MaskingColumnLifecycleState string
    ObjectTypes []string
    The type of the object that contains the database column.
    Objects []string
    The name of the object (table or editioning view) that contains the database column.
    SchemaNames []string
    The name of the schema that contains the database column.
    SensitiveTypeId string
    The OCID of the sensitive type associated with the masking column.
    TimeCreatedGreaterThanOrEqualTo string
    TimeCreatedLessThan string
    TimeUpdatedGreaterThanOrEqualTo string
    TimeUpdatedLessThan string
    id String
    The provider-assigned unique ID for this managed resource.
    maskingColumnCollections List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollection>
    The list of masking_column_collection.
    maskingPolicyId String
    The OCID of the masking policy that contains the masking column.
    columnNames List<String>
    The name of the substitution column.
    dataTypes List<String>
    The data type of the masking column.
    filters List<GetMaskingPoliciesMaskingColumnsFilter>
    isMaskingEnabled Boolean
    Indicates whether data masking is enabled for the masking column.
    isSeedRequired Boolean
    maskingColumnGroups List<String>
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    maskingColumnLifecycleState String
    objectTypes List<String>
    The type of the object that contains the database column.
    objects List<String>
    The name of the object (table or editioning view) that contains the database column.
    schemaNames List<String>
    The name of the schema that contains the database column.
    sensitiveTypeId String
    The OCID of the sensitive type associated with the masking column.
    timeCreatedGreaterThanOrEqualTo String
    timeCreatedLessThan String
    timeUpdatedGreaterThanOrEqualTo String
    timeUpdatedLessThan String
    id string
    The provider-assigned unique ID for this managed resource.
    maskingColumnCollections GetMaskingPoliciesMaskingColumnsMaskingColumnCollection[]
    The list of masking_column_collection.
    maskingPolicyId string
    The OCID of the masking policy that contains the masking column.
    columnNames string[]
    The name of the substitution column.
    dataTypes string[]
    The data type of the masking column.
    filters GetMaskingPoliciesMaskingColumnsFilter[]
    isMaskingEnabled boolean
    Indicates whether data masking is enabled for the masking column.
    isSeedRequired boolean
    maskingColumnGroups string[]
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    maskingColumnLifecycleState string
    objectTypes string[]
    The type of the object that contains the database column.
    objects string[]
    The name of the object (table or editioning view) that contains the database column.
    schemaNames string[]
    The name of the schema that contains the database column.
    sensitiveTypeId string
    The OCID of the sensitive type associated with the masking column.
    timeCreatedGreaterThanOrEqualTo string
    timeCreatedLessThan string
    timeUpdatedGreaterThanOrEqualTo string
    timeUpdatedLessThan string
    id str
    The provider-assigned unique ID for this managed resource.
    masking_column_collections Sequence[GetMaskingPoliciesMaskingColumnsMaskingColumnCollection]
    The list of masking_column_collection.
    masking_policy_id str
    The OCID of the masking policy that contains the masking column.
    column_names Sequence[str]
    The name of the substitution column.
    data_types Sequence[str]
    The data type of the masking column.
    filters Sequence[GetMaskingPoliciesMaskingColumnsFilter]
    is_masking_enabled bool
    Indicates whether data masking is enabled for the masking column.
    is_seed_required bool
    masking_column_groups Sequence[str]
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    masking_column_lifecycle_state str
    object_types Sequence[str]
    The type of the object that contains the database column.
    objects Sequence[str]
    The name of the object (table or editioning view) that contains the database column.
    schema_names Sequence[str]
    The name of the schema that contains the database column.
    sensitive_type_id str
    The OCID of the sensitive type associated with the masking column.
    time_created_greater_than_or_equal_to str
    time_created_less_than str
    time_updated_greater_than_or_equal_to str
    time_updated_less_than str
    id String
    The provider-assigned unique ID for this managed resource.
    maskingColumnCollections List<Property Map>
    The list of masking_column_collection.
    maskingPolicyId String
    The OCID of the masking policy that contains the masking column.
    columnNames List<String>
    The name of the substitution column.
    dataTypes List<String>
    The data type of the masking column.
    filters List<Property Map>
    isMaskingEnabled Boolean
    Indicates whether data masking is enabled for the masking column.
    isSeedRequired Boolean
    maskingColumnGroups List<String>
    The group of the masking column. All the columns in a group are masked together to ensure that the masked data across these columns continue to retain the same logical relationship. For more details, check Group Masking in the Data Safe documentation.
    maskingColumnLifecycleState String
    objectTypes List<String>
    The type of the object that contains the database column.
    objects List<String>
    The name of the object (table or editioning view) that contains the database column.
    schemaNames List<String>
    The name of the schema that contains the database column.
    sensitiveTypeId String
    The OCID of the sensitive type associated with the masking column.
    timeCreatedGreaterThanOrEqualTo String
    timeCreatedLessThan String
    timeUpdatedGreaterThanOrEqualTo String
    timeUpdatedLessThan String

    Supporting Types

    GetMaskingPoliciesMaskingColumnsFilter

    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

    GetMaskingPoliciesMaskingColumnsMaskingColumnCollection

    GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItem

    ChildColumns List<string>
    An array of child columns that are in referential relationship with the masking column.
    ColumnName string
    A filter to return only a specific column based on column name.
    DataType string
    A filter to return only resources that match the specified data types.
    IsMaskingEnabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    Key string
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    LifecycleDetails string
    Details about the current state of the masking column.
    MaskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    MaskingFormats List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat>
    An array of masking formats assigned to the masking column.
    MaskingPolicyId string
    The OCID of the masking policy.
    Object string
    A filter to return only items related to a specific object name.
    ObjectType string
    A filter to return only items related to a specific object type.
    SchemaName string
    A filter to return only items related to specific schema name.
    SensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    State string
    The current state of the masking column.
    TimeCreated string
    The date and time the masking column was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the masking column was last updated, in the format defined by RFC3339.
    ChildColumns []string
    An array of child columns that are in referential relationship with the masking column.
    ColumnName string
    A filter to return only a specific column based on column name.
    DataType string
    A filter to return only resources that match the specified data types.
    IsMaskingEnabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    Key string
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    LifecycleDetails string
    Details about the current state of the masking column.
    MaskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    MaskingFormats []GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat
    An array of masking formats assigned to the masking column.
    MaskingPolicyId string
    The OCID of the masking policy.
    Object string
    A filter to return only items related to a specific object name.
    ObjectType string
    A filter to return only items related to a specific object type.
    SchemaName string
    A filter to return only items related to specific schema name.
    SensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    State string
    The current state of the masking column.
    TimeCreated string
    The date and time the masking column was created, in the format defined by RFC3339.
    TimeUpdated string
    The date and time the masking column was last updated, in the format defined by RFC3339.
    childColumns List<String>
    An array of child columns that are in referential relationship with the masking column.
    columnName String
    A filter to return only a specific column based on column name.
    dataType String
    A filter to return only resources that match the specified data types.
    isMaskingEnabled Boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    key String
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    lifecycleDetails String
    Details about the current state of the masking column.
    maskingColumnGroup String
    A filter to return only the resources that match the specified masking column group.
    maskingFormats List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat>
    An array of masking formats assigned to the masking column.
    maskingPolicyId String
    The OCID of the masking policy.
    object String
    A filter to return only items related to a specific object name.
    objectType String
    A filter to return only items related to a specific object type.
    schemaName String
    A filter to return only items related to specific schema name.
    sensitiveTypeId String
    A filter to return only items related to a specific sensitive type OCID.
    state String
    The current state of the masking column.
    timeCreated String
    The date and time the masking column was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the masking column was last updated, in the format defined by RFC3339.
    childColumns string[]
    An array of child columns that are in referential relationship with the masking column.
    columnName string
    A filter to return only a specific column based on column name.
    dataType string
    A filter to return only resources that match the specified data types.
    isMaskingEnabled boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    key string
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    lifecycleDetails string
    Details about the current state of the masking column.
    maskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    maskingFormats GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat[]
    An array of masking formats assigned to the masking column.
    maskingPolicyId string
    The OCID of the masking policy.
    object string
    A filter to return only items related to a specific object name.
    objectType string
    A filter to return only items related to a specific object type.
    schemaName string
    A filter to return only items related to specific schema name.
    sensitiveTypeId string
    A filter to return only items related to a specific sensitive type OCID.
    state string
    The current state of the masking column.
    timeCreated string
    The date and time the masking column was created, in the format defined by RFC3339.
    timeUpdated string
    The date and time the masking column was last updated, in the format defined by RFC3339.
    child_columns Sequence[str]
    An array of child columns that are in referential relationship with the masking column.
    column_name str
    A filter to return only a specific column based on column name.
    data_type str
    A filter to return only resources that match the specified data types.
    is_masking_enabled bool
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    key str
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    lifecycle_details str
    Details about the current state of the masking column.
    masking_column_group str
    A filter to return only the resources that match the specified masking column group.
    masking_formats Sequence[GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat]
    An array of masking formats assigned to the masking column.
    masking_policy_id str
    The OCID of the masking policy.
    object str
    A filter to return only items related to a specific object name.
    object_type str
    A filter to return only items related to a specific object type.
    schema_name str
    A filter to return only items related to specific schema name.
    sensitive_type_id str
    A filter to return only items related to a specific sensitive type OCID.
    state str
    The current state of the masking column.
    time_created str
    The date and time the masking column was created, in the format defined by RFC3339.
    time_updated str
    The date and time the masking column was last updated, in the format defined by RFC3339.
    childColumns List<String>
    An array of child columns that are in referential relationship with the masking column.
    columnName String
    A filter to return only a specific column based on column name.
    dataType String
    A filter to return only resources that match the specified data types.
    isMaskingEnabled Boolean
    A filter to return the masking column resources based on the value of their isMaskingEnabled attribute. A value of true returns only those columns for which masking is enabled. A value of false returns only those columns for which masking is disabled. Omitting this parameter returns all the masking columns in a masking policy.
    key String
    The unique key that identifies the masking column. It's numeric and unique within a masking policy.
    lifecycleDetails String
    Details about the current state of the masking column.
    maskingColumnGroup String
    A filter to return only the resources that match the specified masking column group.
    maskingFormats List<Property Map>
    An array of masking formats assigned to the masking column.
    maskingPolicyId String
    The OCID of the masking policy.
    object String
    A filter to return only items related to a specific object name.
    objectType String
    A filter to return only items related to a specific object type.
    schemaName String
    A filter to return only items related to specific schema name.
    sensitiveTypeId String
    A filter to return only items related to a specific sensitive type OCID.
    state String
    The current state of the masking column.
    timeCreated String
    The date and time the masking column was created, in the format defined by RFC3339.
    timeUpdated String
    The date and time the masking column was last updated, in the format defined by RFC3339.

    GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormat

    Condition string
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    Description string
    The description of the format entry.
    FormatEntries List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry>
    An array of format entries. The combined output of all the format entries is used for masking the column data values.
    Condition string
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    Description string
    The description of the format entry.
    FormatEntries []GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry
    An array of format entries. The combined output of all the format entries is used for masking the column data values.
    condition String
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    description String
    The description of the format entry.
    formatEntries List<GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry>
    An array of format entries. The combined output of all the format entries is used for masking the column data values.
    condition string
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    description string
    The description of the format entry.
    formatEntries GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry[]
    An array of format entries. The combined output of all the format entries is used for masking the column data values.
    condition str
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    description str
    The description of the format entry.
    format_entries Sequence[GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry]
    An array of format entries. The combined output of all the format entries is used for masking the column data values.
    condition String
    A condition that must be true for applying the masking format. It can be any valid SQL construct that can be used in a SQL predicate. It enables you to do conditional masking so that you can mask the column data values differently using different masking formats and the associated conditions.
    description String
    The description of the format entry.
    formatEntries List<Property Map>
    An array of format entries. The combined output of all the format entries is used for masking the column data values.

    GetMaskingPoliciesMaskingColumnsMaskingColumnCollectionItemMaskingFormatFormatEntry

    ColumnName string
    A filter to return only a specific column based on column name.
    Description string
    The description of the format entry.
    EndDate string
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    EndLength int
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    EndValue double
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    FixedNumber double
    The constant number to be used for masking.
    FixedString string
    The constant string to be used for masking.
    GroupingColumns List<string>
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    Length int
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    LibraryMaskingFormatId string
    The OCID of the library masking format.
    Pattern string
    The pattern that should be used to mask data.
    PostProcessingFunction string
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    RandomLists List<string>
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    RegularExpression string
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    ReplaceWith string
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    SchemaName string
    A filter to return only items related to specific schema name.
    SqlExpression string
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    StartDate string
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    StartLength int
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    StartPosition int
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    StartValue double
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    TableName string
    The name of the table that contains the substitution column.
    Type string
    The type of the format entry.
    UserDefinedFunction string
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    ColumnName string
    A filter to return only a specific column based on column name.
    Description string
    The description of the format entry.
    EndDate string
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    EndLength int
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    EndValue float64
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    FixedNumber float64
    The constant number to be used for masking.
    FixedString string
    The constant string to be used for masking.
    GroupingColumns []string
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    Length int
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    LibraryMaskingFormatId string
    The OCID of the library masking format.
    Pattern string
    The pattern that should be used to mask data.
    PostProcessingFunction string
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    RandomLists []string
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    RegularExpression string
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    ReplaceWith string
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    SchemaName string
    A filter to return only items related to specific schema name.
    SqlExpression string
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    StartDate string
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    StartLength int
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    StartPosition int
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    StartValue float64
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    TableName string
    The name of the table that contains the substitution column.
    Type string
    The type of the format entry.
    UserDefinedFunction string
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    columnName String
    A filter to return only a specific column based on column name.
    description String
    The description of the format entry.
    endDate String
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    endLength Integer
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    endValue Double
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    fixedNumber Double
    The constant number to be used for masking.
    fixedString String
    The constant string to be used for masking.
    groupingColumns List<String>
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    length Integer
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    libraryMaskingFormatId String
    The OCID of the library masking format.
    pattern String
    The pattern that should be used to mask data.
    postProcessingFunction String
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    randomLists List<String>
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    regularExpression String
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    replaceWith String
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    schemaName String
    A filter to return only items related to specific schema name.
    sqlExpression String
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    startDate String
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    startLength Integer
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    startPosition Integer
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    startValue Double
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    tableName String
    The name of the table that contains the substitution column.
    type String
    The type of the format entry.
    userDefinedFunction String
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    columnName string
    A filter to return only a specific column based on column name.
    description string
    The description of the format entry.
    endDate string
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    endLength number
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    endValue number
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    fixedNumber number
    The constant number to be used for masking.
    fixedString string
    The constant string to be used for masking.
    groupingColumns string[]
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    length number
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    libraryMaskingFormatId string
    The OCID of the library masking format.
    pattern string
    The pattern that should be used to mask data.
    postProcessingFunction string
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    randomLists string[]
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    regularExpression string
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    replaceWith string
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    schemaName string
    A filter to return only items related to specific schema name.
    sqlExpression string
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    startDate string
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    startLength number
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    startPosition number
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    startValue number
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    tableName string
    The name of the table that contains the substitution column.
    type string
    The type of the format entry.
    userDefinedFunction string
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    column_name str
    A filter to return only a specific column based on column name.
    description str
    The description of the format entry.
    end_date str
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    end_length int
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    end_value float
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    fixed_number float
    The constant number to be used for masking.
    fixed_string str
    The constant string to be used for masking.
    grouping_columns Sequence[str]
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    length int
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    library_masking_format_id str
    The OCID of the library masking format.
    pattern str
    The pattern that should be used to mask data.
    post_processing_function str
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    random_lists Sequence[str]
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    regular_expression str
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    replace_with str
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    schema_name str
    A filter to return only items related to specific schema name.
    sql_expression str
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    start_date str
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    start_length int
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    start_position int
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    start_value float
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    table_name str
    The name of the table that contains the substitution column.
    type str
    The type of the format entry.
    user_defined_function str
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    columnName String
    A filter to return only a specific column based on column name.
    description String
    The description of the format entry.
    endDate String
    The upper bound of the range within which all the original column values fall. The end date must be greater than or equal to the start date.
    endLength Number
    The maximum number of characters the generated strings should have. It can be any integer greater than zero, but it must be greater than or equal to the start length.
    endValue Number
    The upper bound of the range within which random decimal numbers should be generated. It must be greater than or equal to the start value. It supports input of double type.
    fixedNumber Number
    The constant number to be used for masking.
    fixedString String
    The constant string to be used for masking.
    groupingColumns List<String>
    One or more reference columns to be used to group column values so that they can be shuffled within their own group. The grouping columns and the column to be masked must belong to the same table.
    length Number
    The number of characters that should be there in the substring. It should be an integer and greater than zero.
    libraryMaskingFormatId String
    The OCID of the library masking format.
    pattern String
    The pattern that should be used to mask data.
    postProcessingFunction String
    The post processing function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.
    randomLists List<String>
    A comma-separated list of values to be used to replace column values. The list can be of strings, numbers, or dates. The data type of each value in the list must be compatible with the data type of the column. The number of entries in the list cannot be more than 999.
    regularExpression String
    The regular expression to be used for masking. For data with characters in the ASCII character set, providing a regular expression is optional. However, it is required if the data contains multi-byte characters. If not provided, an error is returned when a multi-byte character is found.
    replaceWith String
    The value that should be used to replace the data matching the regular expression. It can be a fixed string, fixed number or null value.
    schemaName String
    A filter to return only items related to specific schema name.
    sqlExpression String
    The SQL expression to be used to generate the masked values. It can consist of one or more values, operators, and SQL functions that evaluate to a value. It can also contain substitution columns from the same table. Specify the substitution columns within percent (%) symbols.
    startDate String
    The lower bound of the range within which all the original column values fall. The start date must be less than or equal to the end date.
    startLength Number
    The minimum number of characters the generated strings should have. It can be any integer greater than zero, but it must be less than or equal to the end length.
    startPosition Number
    The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It's negative, the counting starts from the end of the string.
    startValue Number
    The lower bound of the range within which random decimal numbers should be generated. It must be less than or equal to the end value. It supports input of double type.
    tableName String
    The name of the table that contains the substitution column.
    type String
    The type of the format entry.
    userDefinedFunction String
    The user-defined function in SCHEMA_NAME.PACKAGE_NAME.FUNCTION_NAME format. It can be a standalone or packaged function, so PACKAGE_NAME is optional.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci