Get-OCIDatasafeSensitiveColumnsList

SYNOPSIS

Invokes DataSafe service - ListSensitiveColumns operation.

SYNTAX

Limit

Get-OCIDatasafeSensitiveColumnsList -SensitiveDataModelId <String> [-TimeCreatedGreaterThanOrEqualTo <DateTime>] [-TimeCreatedLessThan <DateTime>] [-TimeUpdatedGreaterThanOrEqualTo <DateTime>] [-TimeUpdatedLessThan <DateTime>] [-SensitiveColumnLifecycleState <SensitiveColumnLifecycleState>] [-ColumnDataCountFilter <ColumnDataCountFilterEnum>] [-ConfidenceLevel <System.Collections.Generic.List`1[Oci.DatasafeService.Models.ConfidenceLevelEnum]>] [-SchemaName <System.Collections.Generic.List`1[System.String]>] [-ObjectName <System.Collections.Generic.List`1[System.String]>] [-ColumnName <System.Collections.Generic.List`1[System.String]>] [-ObjectType <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+ObjectTypeEnum]>] [-DataType <System.Collections.Generic.List`1[System.String]>] [-Status <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+StatusEnum]>] [-SensitiveTypeId <System.Collections.Generic.List`1[System.String]>] [-ParentColumnKey <System.Collections.Generic.List`1[System.String]>] [-RelationType <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+RelationTypeEnum]>] [-ColumnGroup <String>] [-Limit <Int32>] [-Page <String>] [-SortOrder <SortOrderEnum>] [-SortBy <SortByEnum>] [-OpcRequestId <String>] [-IsCaseInSensitive <Boolean>] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

AllPages

Get-OCIDatasafeSensitiveColumnsList -SensitiveDataModelId <String> [-TimeCreatedGreaterThanOrEqualTo <DateTime>] [-TimeCreatedLessThan <DateTime>] [-TimeUpdatedGreaterThanOrEqualTo <DateTime>] [-TimeUpdatedLessThan <DateTime>] [-SensitiveColumnLifecycleState <SensitiveColumnLifecycleState>] [-ColumnDataCountFilter <ColumnDataCountFilterEnum>] [-ConfidenceLevel <System.Collections.Generic.List`1[Oci.DatasafeService.Models.ConfidenceLevelEnum]>] [-SchemaName <System.Collections.Generic.List`1[System.String]>] [-ObjectName <System.Collections.Generic.List`1[System.String]>] [-ColumnName <System.Collections.Generic.List`1[System.String]>] [-ObjectType <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+ObjectTypeEnum]>] [-DataType <System.Collections.Generic.List`1[System.String]>] [-Status <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+StatusEnum]>] [-SensitiveTypeId <System.Collections.Generic.List`1[System.String]>] [-ParentColumnKey <System.Collections.Generic.List`1[System.String]>] [-RelationType <System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+RelationTypeEnum]>] [-ColumnGroup <String>] [-Page <String>] [-SortOrder <SortOrderEnum>] [-SortBy <SortByEnum>] [-OpcRequestId <String>] [-IsCaseInSensitive <Boolean>] [-All] [-ConfigFile <String>] [-Endpoint <String>] [-NoRetry] [-Profile <String>] [-Region <String>] [-FullResponse] [-TimeOutInMillis <Int32>] [-AuthType <AuthenticationType>] [<CommonParameters>]

DESCRIPTION

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

PARAMETERS

-All

Fetches all pages of results.

Type: SwitchParameter
Parameter Sets: AllPages
Aliases: None

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-AuthType

Type of authentication to use for making API requests. Default is Key based Authentication.

Type: AuthenticationType
Parameter Sets: (All)
Aliases: None
Accepted values: ApiKey, InstancePrincipal, SessionToken

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ColumnDataCountFilter

Filters the sensitive columns with respect to the estimated row count.

Type: ColumnDataCountFilterEnum
Parameter Sets: (All)
Aliases: None
Accepted values: ShowAllColumns, ShowColumnsWithData, ShowColumnsWithoutData

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ColumnGroup

A filter to return only the sensitive columns that belong to the specified column group.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ColumnName

A filter to return only a specific column based on column name.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ConfidenceLevel

A filter to return the sensitive columns with the specified confidence level. Confidence level of sensitive column associated with a seeded sensitive type can either be HIGH or LOW. While the confidence level of sensitive column associated with a user defined sensitive will be NONE. For sensitive columns added manually the confidence level will also be NONE.

Type: System.Collections.Generic.List`1[Oci.DatasafeService.Models.ConfidenceLevelEnum]
Parameter Sets: (All)
Aliases: None
Accepted values: UnknownEnumValue, None, High, Medium, Low

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ConfigFile

The path to the config file.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DataType

A filter to return only the resources that match the specified data types.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Endpoint

The value to use as the service endpoint, including any required API version path.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-FullResponse

Output the complete response returned by the API Operation. Using this switch will make this Cmdlet output an object containing response headers in-addition to an optional response body.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-IsCaseInSensitive

A boolean flag indicating whether the search should be case-insensitive. The search is case-sensitive by default. Set this parameter to true to do case-insensitive search.

Type: Boolean
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Limit

For list pagination. The maximum number of items to return per page in a paginated "List" call. For details about how pagination works, see List Pagination.

Type: Int32
Parameter Sets: Limit
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-NoRetry

Disable retry logic for calls to services.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ObjectName

A filter to return only items related to a specific object name.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ObjectType

A filter to return only items related to a specific object type.

Type: System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+ObjectTypeEnum]
Parameter Sets: (All)
Aliases: None
Accepted values: All, Table, EditioningView

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-OpcRequestId

Unique identifier for the request.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Page

For list pagination. The page token representing the page at which to start retrieving results. It is usually retrieved from a previous "List" call. For details about how pagination works, see List Pagination.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-ParentColumnKey

A filter to return only the sensitive columns that are children of one of the columns identified by the specified keys.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Profile

The profile in the config file to load.

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Region

Region-id of the region to make calls against. eg) us-phoenix-1, ap-singapore-1

Type: String
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-RelationType

A filter to return sensitive columns based on their relationship with their parent columns. If set to NONE, it returns the sensitive columns that do not have any parent. The response includes the parent columns as well as the independent columns that are not in any relationship. If set to APP_DEFINED, it returns all the child columns that have application-level (non-dictionary) relationship with their parents. If set to DB_DEFINED, it returns all the child columns that have database-level (dictionary-defined) relationship with their parents.

Type: System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+RelationTypeEnum]
Parameter Sets: (All)
Aliases: None
Accepted values: None, AppDefined, DbDefined

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SchemaName

A filter to return only items related to specific schema name.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SensitiveColumnLifecycleState

Filters the sensitive column resources with the given lifecycle state values.

Type: SensitiveColumnLifecycleState
Parameter Sets: (All)
Aliases: None
Accepted values: UnknownEnumValue, Creating, Active, Updating, Deleting, Failed

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SensitiveDataModelId

The OCID of the sensitive data model.

Type: String
Parameter Sets: (All)
Aliases: None

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SensitiveTypeId

A filter to return only the sensitive columns that are associated with one of the sensitive types identified by the specified OCIDs.

Type: System.Collections.Generic.List`1[System.String]
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SortBy

The field to sort by. You can specify only one sorting parameter (sortOrder). The default order for timeCreated is descending. The default order for schemaName, objectName, and columnName is ascending.

Type: SortByEnum
Parameter Sets: (All)
Aliases: None
Accepted values: TimeCreated, SchemaName, ObjectName, ColumnName, DataType, ConfidenceLevel

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-SortOrder

The sort order to use, either ascending (ASC) or descending (DESC).

Type: SortOrderEnum
Parameter Sets: (All)
Aliases: None
Accepted values: Asc, Desc

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-Status

A filter to return only the sensitive columns that match the specified status.

Type: System.Collections.Generic.List`1[Oci.DatasafeService.Requests.ListSensitiveColumnsRequest+StatusEnum]
Parameter Sets: (All)
Aliases: None
Accepted values: Valid, Invalid

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-TimeCreatedGreaterThanOrEqualTo

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

Type: DateTime
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-TimeCreatedLessThan

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

Type: DateTime
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-TimeOutInMillis

Max wait time in milliseconds for the API request to complete. Default is 100000 millis(100 secs).

Type: Int32
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-TimeUpdatedGreaterThanOrEqualTo

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.

Type: DateTime
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

-TimeUpdatedLessThan

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.

Type: DateTime
Parameter Sets: (All)
Aliases: None

Required: False
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName)
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

OUTPUTS

• Oci.DatasafeService.Models.SensitiveColumnCollection
• Oci.DatasafeService.Responses.ListSensitiveColumnsResponse

RELATED LINKS

• APIReference
• DotnetSDKAPI
• OCIModulesDocs
• OCIServiceConcepts
• Examples