transparent_data_encryptions

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

Overview

Name	transparent_data_encryptions
Type	Resource
Id	azure.sql.transparent_data_encryptions

Fields

vw_transparent_data_encryptions

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

transparent_data_encryptions

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

Methods

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

SELECT examples

Gets a list of the logical database's transparent data encryption.

vw_transparent_data_encryptions

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

transparent_data_encryptions

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

INSERT example

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

All Properties

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

Manifest

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