sql_pool_transparent_data_encryptions

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

Overview

Name	sql_pool_transparent_data_encryptions
Type	Resource
Id	azure.synapse.sql_pool_transparent_data_encryptions

Fields

vw_sql_pool_transparent_data_encryptions

Name	Datatype	Description
location	text	Resource location.
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
transparentDataEncryptionName	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_transparent_data_encryptions

Name	Datatype	Description
location	string	Resource location.
properties	object	Represents the properties of a database transparent data encryption.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlPoolName, subscriptionId, transparentDataEncryptionName, workspaceName	Get a SQL pool's transparent data encryption configuration.
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get list of SQL pool's transparent data encryption configurations.
create_or_update	INSERT	resourceGroupName, sqlPoolName, subscriptionId, transparentDataEncryptionName, workspaceName	Creates or updates a Sql pool's transparent data encryption configuration.

SELECT examples

Get list of SQL pool's transparent data encryption configurations.

vw_sql_pool_transparent_data_encryptions

SELECT
location,
resourceGroupName,
sqlPoolName,
status,
subscriptionId,
transparentDataEncryptionName,
workspaceName
FROM azure.synapse.vw_sql_pool_transparent_data_encryptions
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_transparent_data_encryptions

SELECT
location,
properties
FROM azure.synapse.sql_pool_transparent_data_encryptions
WHERE 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 sql_pool_transparent_data_encryptions resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: properties
      value:
        - name: status
          value: string