managed_database_transparent_data_encryptions

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

Overview

Name	managed_database_transparent_data_encryptions
Type	Resource
Id	azure.sql.managed_database_transparent_data_encryptions

Fields

vw_managed_database_transparent_data_encryptions

Name	Datatype	Description
databaseName	text	field from the properties object
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
tdeName	text	field from the properties object

managed_database_transparent_data_encryptions

Name	Datatype	Description
properties	object	Properties of a transparent data encryption.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, managedInstanceName, resourceGroupName, subscriptionId, tdeName	Gets a managed database's transparent data encryption.
list_by_database	SELECT	databaseName, managedInstanceName, resourceGroupName, subscriptionId	Gets a list of managed database's transparent data encryptions.
create_or_update	INSERT	databaseName, managedInstanceName, resourceGroupName, subscriptionId, tdeName	Updates a database's transparent data encryption configuration.

SELECT examples

Gets a list of managed database's transparent data encryptions.

vw_managed_database_transparent_data_encryptions

SELECT
databaseName,
managedInstanceName,
resourceGroupName,
state,
subscriptionId,
tdeName
FROM azure.sql.vw_managed_database_transparent_data_encryptions
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_database_transparent_data_encryptions

SELECT
properties
FROM azure.sql.managed_database_transparent_data_encryptions
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: state
          value: string