1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getMaskingReportsMaskedColumn
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

oci.DataSafe.getMaskingReportsMaskedColumn

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

    This data source provides details about a specific Masking Reports Masked Column resource in Oracle Cloud Infrastructure Data Safe service.

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

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testMaskingReportsMaskedColumn = oci.DataSafe.getMaskingReportsMaskedColumn({
        maskingReportId: oci_data_safe_masking_report.test_masking_report.id,
        columnNames: _var.masking_reports_masked_column_column_name,
        maskingColumnGroups: _var.masking_reports_masked_column_masking_column_group,
        objects: _var.masking_reports_masked_column_object,
        objectTypes: _var.masking_reports_masked_column_object_type,
        schemaNames: _var.masking_reports_masked_column_schema_name,
        sensitiveTypeId: oci_data_safe_sensitive_type.test_sensitive_type.id,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_masking_reports_masked_column = oci.DataSafe.get_masking_reports_masked_column(masking_report_id=oci_data_safe_masking_report["test_masking_report"]["id"],
        column_names=var["masking_reports_masked_column_column_name"],
        masking_column_groups=var["masking_reports_masked_column_masking_column_group"],
        objects=var["masking_reports_masked_column_object"],
        object_types=var["masking_reports_masked_column_object_type"],
        schema_names=var["masking_reports_masked_column_schema_name"],
        sensitive_type_id=oci_data_safe_sensitive_type["test_sensitive_type"]["id"])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/DataSafe"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DataSafe.GetMaskingReportsMaskedColumn(ctx, &datasafe.GetMaskingReportsMaskedColumnArgs{
    			MaskingReportId:     oci_data_safe_masking_report.Test_masking_report.Id,
    			ColumnNames:         _var.Masking_reports_masked_column_column_name,
    			MaskingColumnGroups: _var.Masking_reports_masked_column_masking_column_group,
    			Objects:             _var.Masking_reports_masked_column_object,
    			ObjectTypes:         _var.Masking_reports_masked_column_object_type,
    			SchemaNames:         _var.Masking_reports_masked_column_schema_name,
    			SensitiveTypeId:     pulumi.StringRef(oci_data_safe_sensitive_type.Test_sensitive_type.Id),
    		}, 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 testMaskingReportsMaskedColumn = Oci.DataSafe.GetMaskingReportsMaskedColumn.Invoke(new()
        {
            MaskingReportId = oci_data_safe_masking_report.Test_masking_report.Id,
            ColumnNames = @var.Masking_reports_masked_column_column_name,
            MaskingColumnGroups = @var.Masking_reports_masked_column_masking_column_group,
            Objects = @var.Masking_reports_masked_column_object,
            ObjectTypes = @var.Masking_reports_masked_column_object_type,
            SchemaNames = @var.Masking_reports_masked_column_schema_name,
            SensitiveTypeId = oci_data_safe_sensitive_type.Test_sensitive_type.Id,
        });
    
    });
    
    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.GetMaskingReportsMaskedColumnArgs;
    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 testMaskingReportsMaskedColumn = DataSafeFunctions.getMaskingReportsMaskedColumn(GetMaskingReportsMaskedColumnArgs.builder()
                .maskingReportId(oci_data_safe_masking_report.test_masking_report().id())
                .columnNames(var_.masking_reports_masked_column_column_name())
                .maskingColumnGroups(var_.masking_reports_masked_column_masking_column_group())
                .objects(var_.masking_reports_masked_column_object())
                .objectTypes(var_.masking_reports_masked_column_object_type())
                .schemaNames(var_.masking_reports_masked_column_schema_name())
                .sensitiveTypeId(oci_data_safe_sensitive_type.test_sensitive_type().id())
                .build());
    
        }
    }
    
    variables:
      testMaskingReportsMaskedColumn:
        fn::invoke:
          Function: oci:DataSafe:getMaskingReportsMaskedColumn
          Arguments:
            maskingReportId: ${oci_data_safe_masking_report.test_masking_report.id}
            columnNames: ${var.masking_reports_masked_column_column_name}
            maskingColumnGroups: ${var.masking_reports_masked_column_masking_column_group}
            objects: ${var.masking_reports_masked_column_object}
            objectTypes: ${var.masking_reports_masked_column_object_type}
            schemaNames: ${var.masking_reports_masked_column_schema_name}
            sensitiveTypeId: ${oci_data_safe_sensitive_type.test_sensitive_type.id}
    

    Using getMaskingReportsMaskedColumn

    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 getMaskingReportsMaskedColumn(args: GetMaskingReportsMaskedColumnArgs, opts?: InvokeOptions): Promise<GetMaskingReportsMaskedColumnResult>
    function getMaskingReportsMaskedColumnOutput(args: GetMaskingReportsMaskedColumnOutputArgs, opts?: InvokeOptions): Output<GetMaskingReportsMaskedColumnResult>
    def get_masking_reports_masked_column(column_names: Optional[Sequence[str]] = None,
                                          masking_column_groups: Optional[Sequence[str]] = None,
                                          masking_report_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,
                                          opts: Optional[InvokeOptions] = None) -> GetMaskingReportsMaskedColumnResult
    def get_masking_reports_masked_column_output(column_names: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                          masking_column_groups: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                                          masking_report_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,
                                          opts: Optional[InvokeOptions] = None) -> Output[GetMaskingReportsMaskedColumnResult]
    func GetMaskingReportsMaskedColumn(ctx *Context, args *GetMaskingReportsMaskedColumnArgs, opts ...InvokeOption) (*GetMaskingReportsMaskedColumnResult, error)
    func GetMaskingReportsMaskedColumnOutput(ctx *Context, args *GetMaskingReportsMaskedColumnOutputArgs, opts ...InvokeOption) GetMaskingReportsMaskedColumnResultOutput

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

    public static class GetMaskingReportsMaskedColumn 
    {
        public static Task<GetMaskingReportsMaskedColumnResult> InvokeAsync(GetMaskingReportsMaskedColumnArgs args, InvokeOptions? opts = null)
        public static Output<GetMaskingReportsMaskedColumnResult> Invoke(GetMaskingReportsMaskedColumnInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetMaskingReportsMaskedColumnResult> getMaskingReportsMaskedColumn(GetMaskingReportsMaskedColumnArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DataSafe/getMaskingReportsMaskedColumn:getMaskingReportsMaskedColumn
      arguments:
        # arguments dictionary

    The following arguments are supported:

    MaskingReportId string
    The OCID of the masking report.
    ColumnNames List<string>
    A filter to return only a specific column based on column name.
    MaskingColumnGroups List<string>
    A filter to return only the resources that match the specified masking column group.
    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.
    MaskingReportId string
    The OCID of the masking report.
    ColumnNames []string
    A filter to return only a specific column based on column name.
    MaskingColumnGroups []string
    A filter to return only the resources that match the specified masking column group.
    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.
    maskingReportId String
    The OCID of the masking report.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    maskingColumnGroups List<String>
    A filter to return only the resources that match the specified masking column group.
    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.
    maskingReportId string
    The OCID of the masking report.
    columnNames string[]
    A filter to return only a specific column based on column name.
    maskingColumnGroups string[]
    A filter to return only the resources that match the specified masking column group.
    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.
    masking_report_id str
    The OCID of the masking report.
    column_names Sequence[str]
    A filter to return only a specific column based on column name.
    masking_column_groups Sequence[str]
    A filter to return only the resources that match the specified masking column group.
    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.
    maskingReportId String
    The OCID of the masking report.
    columnNames List<String>
    A filter to return only a specific column based on column name.
    maskingColumnGroups List<String>
    A filter to return only the resources that match the specified masking column group.
    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.

    getMaskingReportsMaskedColumn Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    Items List<GetMaskingReportsMaskedColumnItem>
    An array of masking column summary objects.
    MaskingReportId string
    ColumnNames List<string>
    The name of the masked column.
    MaskingColumnGroups List<string>
    The masking group of the masked column.
    ObjectTypes List<string>
    The type of the object (table or editioning view) that contains the masked column.
    Objects List<string>
    The name of the object (table or editioning view) that contains the masked column.
    SchemaNames List<string>
    The name of the schema that contains the masked column.
    SensitiveTypeId string
    The OCID of the sensitive type associated with the masked column.
    Id string
    The provider-assigned unique ID for this managed resource.
    Items []GetMaskingReportsMaskedColumnItem
    An array of masking column summary objects.
    MaskingReportId string
    ColumnNames []string
    The name of the masked column.
    MaskingColumnGroups []string
    The masking group of the masked column.
    ObjectTypes []string
    The type of the object (table or editioning view) that contains the masked column.
    Objects []string
    The name of the object (table or editioning view) that contains the masked column.
    SchemaNames []string
    The name of the schema that contains the masked column.
    SensitiveTypeId string
    The OCID of the sensitive type associated with the masked column.
    id String
    The provider-assigned unique ID for this managed resource.
    items List<GetMaskingReportsMaskedColumnItem>
    An array of masking column summary objects.
    maskingReportId String
    columnNames List<String>
    The name of the masked column.
    maskingColumnGroups List<String>
    The masking group of the masked column.
    objectTypes List<String>
    The type of the object (table or editioning view) that contains the masked column.
    objects List<String>
    The name of the object (table or editioning view) that contains the masked column.
    schemaNames List<String>
    The name of the schema that contains the masked column.
    sensitiveTypeId String
    The OCID of the sensitive type associated with the masked column.
    id string
    The provider-assigned unique ID for this managed resource.
    items GetMaskingReportsMaskedColumnItem[]
    An array of masking column summary objects.
    maskingReportId string
    columnNames string[]
    The name of the masked column.
    maskingColumnGroups string[]
    The masking group of the masked column.
    objectTypes string[]
    The type of the object (table or editioning view) that contains the masked column.
    objects string[]
    The name of the object (table or editioning view) that contains the masked column.
    schemaNames string[]
    The name of the schema that contains the masked column.
    sensitiveTypeId string
    The OCID of the sensitive type associated with the masked column.
    id str
    The provider-assigned unique ID for this managed resource.
    items GetMaskingReportsMaskedColumnItem]
    An array of masking column summary objects.
    masking_report_id str
    column_names Sequence[str]
    The name of the masked column.
    masking_column_groups Sequence[str]
    The masking group of the masked column.
    object_types Sequence[str]
    The type of the object (table or editioning view) that contains the masked column.
    objects Sequence[str]
    The name of the object (table or editioning view) that contains the masked column.
    schema_names Sequence[str]
    The name of the schema that contains the masked column.
    sensitive_type_id str
    The OCID of the sensitive type associated with the masked column.
    id String
    The provider-assigned unique ID for this managed resource.
    items List<Property Map>
    An array of masking column summary objects.
    maskingReportId String
    columnNames List<String>
    The name of the masked column.
    maskingColumnGroups List<String>
    The masking group of the masked column.
    objectTypes List<String>
    The type of the object (table or editioning view) that contains the masked column.
    objects List<String>
    The name of the object (table or editioning view) that contains the masked column.
    schemaNames List<String>
    The name of the schema that contains the masked column.
    sensitiveTypeId String
    The OCID of the sensitive type associated with the masked column.

    Supporting Types

    GetMaskingReportsMaskedColumnItem

    ColumnName string
    A filter to return only a specific column based on column name.
    Key string
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    MaskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    MaskingFormatUsed string
    The masking format used for masking the column.
    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.
    ParentColumnKey string
    The unique key that identifies the parent column of the masked column.
    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.
    TotalMaskedValues string
    The total number of values masked in the column.
    ColumnName string
    A filter to return only a specific column based on column name.
    Key string
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    MaskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    MaskingFormatUsed string
    The masking format used for masking the column.
    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.
    ParentColumnKey string
    The unique key that identifies the parent column of the masked column.
    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.
    TotalMaskedValues string
    The total number of values masked in the column.
    columnName String
    A filter to return only a specific column based on column name.
    key String
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    maskingColumnGroup String
    A filter to return only the resources that match the specified masking column group.
    maskingFormatUsed String
    The masking format used for masking the column.
    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.
    parentColumnKey String
    The unique key that identifies the parent column of the masked column.
    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.
    totalMaskedValues String
    The total number of values masked in the column.
    columnName string
    A filter to return only a specific column based on column name.
    key string
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    maskingColumnGroup string
    A filter to return only the resources that match the specified masking column group.
    maskingFormatUsed string
    The masking format used for masking the column.
    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.
    parentColumnKey string
    The unique key that identifies the parent column of the masked column.
    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.
    totalMaskedValues string
    The total number of values masked in the column.
    column_name str
    A filter to return only a specific column based on column name.
    key str
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    masking_column_group str
    A filter to return only the resources that match the specified masking column group.
    masking_format_used str
    The masking format used for masking the column.
    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.
    parent_column_key str
    The unique key that identifies the parent column of the masked column.
    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.
    total_masked_values str
    The total number of values masked in the column.
    columnName String
    A filter to return only a specific column based on column name.
    key String
    The unique key that identifies the masked column. It's numeric and unique within a masking policy.
    maskingColumnGroup String
    A filter to return only the resources that match the specified masking column group.
    maskingFormatUsed String
    The masking format used for masking the column.
    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.
    parentColumnKey String
    The unique key that identifies the parent column of the masked column.
    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.
    totalMaskedValues String
    The total number of values masked in the column.

    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 v1.27.0 published on Friday, Mar 15, 2024 by Pulumi