Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
oci.DataSafe.getMaskingReportsMaskedColumn
Explore with Pulumi AI
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: testMaskingReport.id,
    columnNames: maskingReportsMaskedColumnColumnName,
    maskingColumnGroups: maskingReportsMaskedColumnMaskingColumnGroup,
    objects: maskingReportsMaskedColumnObject,
    objectTypes: maskingReportsMaskedColumnObjectType,
    schemaNames: maskingReportsMaskedColumnSchemaName,
    sensitiveTypeId: testSensitiveType.id,
});
import pulumi
import pulumi_oci as oci
test_masking_reports_masked_column = oci.DataSafe.get_masking_reports_masked_column(masking_report_id=test_masking_report["id"],
    column_names=masking_reports_masked_column_column_name,
    masking_column_groups=masking_reports_masked_column_masking_column_group,
    objects=masking_reports_masked_column_object,
    object_types=masking_reports_masked_column_object_type,
    schema_names=masking_reports_masked_column_schema_name,
    sensitive_type_id=test_sensitive_type["id"])
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.GetMaskingReportsMaskedColumn(ctx, &datasafe.GetMaskingReportsMaskedColumnArgs{
			MaskingReportId:     testMaskingReport.Id,
			ColumnNames:         maskingReportsMaskedColumnColumnName,
			MaskingColumnGroups: maskingReportsMaskedColumnMaskingColumnGroup,
			Objects:             maskingReportsMaskedColumnObject,
			ObjectTypes:         maskingReportsMaskedColumnObjectType,
			SchemaNames:         maskingReportsMaskedColumnSchemaName,
			SensitiveTypeId:     pulumi.StringRef(testSensitiveType.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 = testMaskingReport.Id,
        ColumnNames = maskingReportsMaskedColumnColumnName,
        MaskingColumnGroups = maskingReportsMaskedColumnMaskingColumnGroup,
        Objects = maskingReportsMaskedColumnObject,
        ObjectTypes = maskingReportsMaskedColumnObjectType,
        SchemaNames = maskingReportsMaskedColumnSchemaName,
        SensitiveTypeId = testSensitiveType.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(testMaskingReport.id())
            .columnNames(maskingReportsMaskedColumnColumnName)
            .maskingColumnGroups(maskingReportsMaskedColumnMaskingColumnGroup)
            .objects(maskingReportsMaskedColumnObject)
            .objectTypes(maskingReportsMaskedColumnObjectType)
            .schemaNames(maskingReportsMaskedColumnSchemaName)
            .sensitiveTypeId(testSensitiveType.id())
            .build());
    }
}
variables:
  testMaskingReportsMaskedColumn:
    fn::invoke:
      function: oci:DataSafe:getMaskingReportsMaskedColumn
      arguments:
        maskingReportId: ${testMaskingReport.id}
        columnNames: ${maskingReportsMaskedColumnColumnName}
        maskingColumnGroups: ${maskingReportsMaskedColumnMaskingColumnGroup}
        objects: ${maskingReportsMaskedColumnObject}
        objectTypes: ${maskingReportsMaskedColumnObjectType}
        schemaNames: ${maskingReportsMaskedColumnSchemaName}
        sensitiveTypeId: ${testSensitiveType.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)
public static Output<GetMaskingReportsMaskedColumnResult> getMaskingReportsMaskedColumn(GetMaskingReportsMaskedColumnArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DataSafe/getMaskingReportsMaskedColumn:getMaskingReportsMaskedColumn
  arguments:
    # arguments dictionaryThe following arguments are supported:
- MaskingReport stringId 
- The OCID of the masking report.
- ColumnNames List<string>
- A filter to return only a specific column based on column name.
- MaskingColumn List<string>Groups 
- 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.
- SensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- MaskingReport stringId 
- The OCID of the masking report.
- ColumnNames []string
- A filter to return only a specific column based on column name.
- MaskingColumn []stringGroups 
- 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.
- SensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- maskingReport StringId 
- The OCID of the masking report.
- columnNames List<String>
- A filter to return only a specific column based on column name.
- maskingColumn List<String>Groups 
- 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.
- sensitiveType StringId 
- A filter to return only items related to a specific sensitive type OCID.
- maskingReport stringId 
- The OCID of the masking report.
- columnNames string[]
- A filter to return only a specific column based on column name.
- maskingColumn string[]Groups 
- 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.
- sensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- masking_report_ strid 
- The OCID of the masking report.
- column_names Sequence[str]
- A filter to return only a specific column based on column name.
- masking_column_ Sequence[str]groups 
- 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_ strid 
- A filter to return only items related to a specific sensitive type OCID.
- maskingReport StringId 
- The OCID of the masking report.
- columnNames List<String>
- A filter to return only a specific column based on column name.
- maskingColumn List<String>Groups 
- 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.
- sensitiveType StringId 
- 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<GetMasking Reports Masked Column Item> 
- An array of masking column summary objects.
- MaskingReport stringId 
- ColumnNames List<string>
- The name of the masked column.
- MaskingColumn List<string>Groups 
- 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.
- SensitiveType stringId 
- The OCID of the sensitive type associated with the masked column.
- Id string
- The provider-assigned unique ID for this managed resource.
- Items
[]GetMasking Reports Masked Column Item 
- An array of masking column summary objects.
- MaskingReport stringId 
- ColumnNames []string
- The name of the masked column.
- MaskingColumn []stringGroups 
- 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.
- SensitiveType stringId 
- The OCID of the sensitive type associated with the masked column.
- id String
- The provider-assigned unique ID for this managed resource.
- items
List<GetMasking Reports Masked Column Item> 
- An array of masking column summary objects.
- maskingReport StringId 
- columnNames List<String>
- The name of the masked column.
- maskingColumn List<String>Groups 
- 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.
- sensitiveType StringId 
- The OCID of the sensitive type associated with the masked column.
- id string
- The provider-assigned unique ID for this managed resource.
- items
GetMasking Reports Masked Column Item[] 
- An array of masking column summary objects.
- maskingReport stringId 
- columnNames string[]
- The name of the masked column.
- maskingColumn string[]Groups 
- 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.
- sensitiveType stringId 
- The OCID of the sensitive type associated with the masked column.
- id str
- The provider-assigned unique ID for this managed resource.
- items
Sequence[GetMasking Reports Masked Column Item] 
- An array of masking column summary objects.
- masking_report_ strid 
- column_names Sequence[str]
- The name of the masked column.
- masking_column_ Sequence[str]groups 
- 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_ strid 
- 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.
- maskingReport StringId 
- columnNames List<String>
- The name of the masked column.
- maskingColumn List<String>Groups 
- 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.
- sensitiveType StringId 
- 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.
- MaskingColumn stringGroup 
- A filter to return only the resources that match the specified masking column group.
- MaskingFormat stringUsed 
- 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.
- ParentColumn stringKey 
- 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.
- SensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- TotalMasked stringValues 
- 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.
- MaskingColumn stringGroup 
- A filter to return only the resources that match the specified masking column group.
- MaskingFormat stringUsed 
- 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.
- ParentColumn stringKey 
- 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.
- SensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- TotalMasked stringValues 
- 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.
- maskingColumn StringGroup 
- A filter to return only the resources that match the specified masking column group.
- maskingFormat StringUsed 
- 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.
- parentColumn StringKey 
- 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.
- sensitiveType StringId 
- A filter to return only items related to a specific sensitive type OCID.
- totalMasked StringValues 
- 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.
- maskingColumn stringGroup 
- A filter to return only the resources that match the specified masking column group.
- maskingFormat stringUsed 
- 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.
- parentColumn stringKey 
- 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.
- sensitiveType stringId 
- A filter to return only items related to a specific sensitive type OCID.
- totalMasked stringValues 
- 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_ strgroup 
- A filter to return only the resources that match the specified masking column group.
- masking_format_ strused 
- 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_ strkey 
- 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_ strid 
- A filter to return only items related to a specific sensitive type OCID.
- total_masked_ strvalues 
- 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.
- maskingColumn StringGroup 
- A filter to return only the resources that match the specified masking column group.
- maskingFormat StringUsed 
- 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.
- parentColumn StringKey 
- 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.
- sensitiveType StringId 
- A filter to return only items related to a specific sensitive type OCID.
- totalMasked StringValues 
- 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 ociTerraform Provider.