vw_data_masking_rules

Creates, updates, deletes, gets or lists a vw_data_masking_rules resource.

Overview

Name	vw_data_masking_rules
Type	View
Id	azure.synapse.vw_data_masking_rules

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
location as location,
kind as kind,
JSON_EXTRACT(properties, '$.id') as "id",
JSON_EXTRACT(properties, '$.aliasName') as "alias_name",
JSON_EXTRACT(properties, '$.ruleState') as "rule_state",
JSON_EXTRACT(properties, '$.schemaName') as "schema_name",
JSON_EXTRACT(properties, '$.tableName') as "table_name",
JSON_EXTRACT(properties, '$.columnName') as "column_name",
JSON_EXTRACT(properties, '$.maskingFunction') as "masking_function",
JSON_EXTRACT(properties, '$.numberFrom') as "number_from",
JSON_EXTRACT(properties, '$.numberTo') as "number_to",
JSON_EXTRACT(properties, '$.prefixSize') as "prefix_size",
JSON_EXTRACT(properties, '$.suffixSize') as "suffix_size",
JSON_EXTRACT(properties, '$.replacementString') as "replacement_string",
subscriptionId,
resourceGroupName,
workspaceName,
sqlPoolName,
dataMaskingPolicyName,
dataMaskingRuleName
FROM azure.synapse.data_masking_rules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND sqlPoolName = 'replace-me' AND dataMaskingPolicyName = 'replace-me';

Postgres

SELECT
location as location,
kind as kind,
json_extract_path_text(properties, '$.id') as "id",
json_extract_path_text(properties, '$.aliasName') as "alias_name",
json_extract_path_text(properties, '$.ruleState') as "rule_state",
json_extract_path_text(properties, '$.schemaName') as "schema_name",
json_extract_path_text(properties, '$.tableName') as "table_name",
json_extract_path_text(properties, '$.columnName') as "column_name",
json_extract_path_text(properties, '$.maskingFunction') as "masking_function",
json_extract_path_text(properties, '$.numberFrom') as "number_from",
json_extract_path_text(properties, '$.numberTo') as "number_to",
json_extract_path_text(properties, '$.prefixSize') as "prefix_size",
json_extract_path_text(properties, '$.suffixSize') as "suffix_size",
json_extract_path_text(properties, '$.replacementString') as "replacement_string",
subscriptionId,
resourceGroupName,
workspaceName,
sqlPoolName,
dataMaskingPolicyName,
dataMaskingRuleName
FROM azure.synapse.data_masking_rules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me' AND sqlPoolName = 'replace-me' AND dataMaskingPolicyName = 'replace-me';