workspace_managed_sql_server_encryption_protectors

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

Overview

Name	workspace_managed_sql_server_encryption_protectors
Type	Resource
Id	azure.synapse.workspace_managed_sql_server_encryption_protectors

Fields

vw_workspace_managed_sql_server_encryption_protectors

Name	Datatype	Description
encryptionProtectorName	text	field from the properties object
kind	text	Kind of encryption protector. This is metadata used for the Azure portal experience.
location	text	Resource location.
resourceGroupName	text	field from the properties object
server_key_name	text	field from the properties object
server_key_type	text	field from the properties object
subregion	text	field from the properties object
subscriptionId	text	field from the properties object
thumbprint	text	field from the properties object
uri	text	field from the properties object
workspaceName	text	field from the properties object

workspace_managed_sql_server_encryption_protectors

Name	Datatype	Description
kind	string	Kind of encryption protector. This is metadata used for the Azure portal experience.
location	string	Resource location.
properties	object	Properties for an encryption protector execution.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	encryptionProtectorName, resourceGroupName, subscriptionId, workspaceName	Get workspace managed sql server's encryption protector.
list	SELECT	resourceGroupName, subscriptionId, workspaceName	Get list of encryption protectors for workspace managed sql server.
create_or_update	INSERT	encryptionProtectorName, resourceGroupName, subscriptionId, workspaceName	Updates workspace managed sql server's encryption protector.
revalidate	EXEC	encryptionProtectorName, resourceGroupName, subscriptionId, workspaceName	Revalidates workspace managed sql server's existing encryption protector.

SELECT examples

Get list of encryption protectors for workspace managed sql server.

vw_workspace_managed_sql_server_encryption_protectors

SELECT
encryptionProtectorName,
kind,
location,
resourceGroupName,
server_key_name,
server_key_type,
subregion,
subscriptionId,
thumbprint,
uri,
workspaceName
FROM azure.synapse.vw_workspace_managed_sql_server_encryption_protectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

workspace_managed_sql_server_encryption_protectors

SELECT
kind,
location,
properties
FROM azure.synapse.workspace_managed_sql_server_encryption_protectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: kind
      value: string
    - name: location
      value: string
    - name: properties
      value:
        - name: subregion
          value: string
        - name: serverKeyName
          value: string
        - name: serverKeyType
          value: string
        - name: uri
          value: string
        - name: thumbprint
          value: string