encryption_protectors

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

Overview

Name	encryption_protectors
Type	Resource
Id	azure.sql.encryption_protectors

Fields

vw_encryption_protectors

Name	Datatype	Description
auto_rotation_enabled	text	field from the properties object
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
serverName	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

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, serverName, subscriptionId	Gets a server encryption protector.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Gets a list of server encryption protectors
create_or_update	INSERT	encryptionProtectorName, resourceGroupName, serverName, subscriptionId	Updates an existing encryption protector.
revalidate	EXEC	encryptionProtectorName, resourceGroupName, serverName, subscriptionId	Revalidates an existing encryption protector.

SELECT examples

Gets a list of server encryption protectors

vw_encryption_protectors

SELECT
auto_rotation_enabled,
encryptionProtectorName,
kind,
location,
resourceGroupName,
serverName,
server_key_name,
server_key_type,
subregion,
subscriptionId,
thumbprint,
uri
FROM azure.sql.vw_encryption_protectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

encryption_protectors

SELECT
kind,
location,
properties
FROM azure.sql.encryption_protectors
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.encryption_protectors (
encryptionProtectorName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ encryptionProtectorName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ 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
        - name: autoRotationEnabled
          value: boolean