managed_instance_encryption_protectors

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

Overview

Name	managed_instance_encryption_protectors
Type	Resource
Id	azure.sql.managed_instance_encryption_protectors

Fields

vw_managed_instance_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.
managedInstanceName	text	field from the properties object
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
subscriptionId	text	field from the properties object
thumbprint	text	field from the properties object
uri	text	field from the properties object

managed_instance_encryption_protectors

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	encryptionProtectorName, managedInstanceName, resourceGroupName, subscriptionId	Gets a managed instance encryption protector.
create_or_update	INSERT	encryptionProtectorName, managedInstanceName, resourceGroupName, subscriptionId	Updates an existing encryption protector.
revalidate	EXEC	encryptionProtectorName, managedInstanceName, resourceGroupName, subscriptionId	Revalidates an existing encryption protector.

SELECT examples

Gets a managed instance encryption protector.

vw_managed_instance_encryption_protectors

SELECT
auto_rotation_enabled,
encryptionProtectorName,
kind,
managedInstanceName,
resourceGroupName,
server_key_name,
server_key_type,
subscriptionId,
thumbprint,
uri
FROM azure.sql.vw_managed_instance_encryption_protectors
WHERE encryptionProtectorName = '{{ encryptionProtectorName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_encryption_protectors

SELECT
kind,
properties
FROM azure.sql.managed_instance_encryption_protectors
WHERE encryptionProtectorName = '{{ encryptionProtectorName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.managed_instance_encryption_protectors (
encryptionProtectorName,
managedInstanceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ encryptionProtectorName }}',
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: kind
      value: string
    - name: properties
      value:
        - name: serverKeyName
          value: string
        - name: serverKeyType
          value: string
        - name: uri
          value: string
        - name: thumbprint
          value: string
        - name: autoRotationEnabled
          value: boolean