data_masking_policies

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

Overview

Name	data_masking_policies
Type	Resource
Id	azure.synapse.data_masking_policies

Fields

vw_data_masking_policies

Name	Datatype	Description
application_principals	text	field from the properties object
dataMaskingPolicyName	text	field from the properties object
data_masking_state	text	field from the properties object
exempt_principals	text	field from the properties object
kind	text	The kind of data masking policy. Metadata, used for Azure portal.
location	text	The location of the data masking policy.
managed_by	text	field from the properties object
masking_level	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

data_masking_policies

Name	Datatype	Description
kind	string	The kind of data masking policy. Metadata, used for Azure portal.
location	string	The location of the data masking policy.
managedBy	string	Fully qualified resource ID of the sql pool
properties	object	The properties of a database data masking policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dataMaskingPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Gets a Sql pool data masking policy.
create_or_update	INSERT	dataMaskingPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Creates or updates a Sql pool data masking policy

SELECT examples

Gets a Sql pool data masking policy.

vw_data_masking_policies

SELECT
application_principals,
dataMaskingPolicyName,
data_masking_state,
exempt_principals,
kind,
location,
managed_by,
masking_level,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName
FROM azure.synapse.vw_data_masking_policies
WHERE dataMaskingPolicyName = '{{ dataMaskingPolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

data_masking_policies

SELECT
kind,
location,
managedBy,
properties
FROM azure.synapse.data_masking_policies
WHERE dataMaskingPolicyName = '{{ dataMaskingPolicyName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

Use the following StackQL query and manifest file to create a new data_masking_policies resource.

All Properties

/*+ create */
INSERT INTO azure.synapse.data_masking_policies (
dataMaskingPolicyName,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName,
properties
)
SELECT 
'{{ dataMaskingPolicyName }}',
'{{ resourceGroupName }}',
'{{ sqlPoolName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: dataMaskingState
          value: string
        - name: exemptPrincipals
          value: string
        - name: applicationPrincipals
          value: string
        - name: maskingLevel
          value: string
    - name: location
      value: string
    - name: kind
      value: string
    - name: managedBy
      value: string