ledger_digest_uploads

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

Overview

Name	ledger_digest_uploads
Type	Resource
Id	azure.sql.ledger_digest_uploads

Fields

vw_ledger_digest_uploads

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

ledger_digest_uploads

Name	Datatype	Description
properties	object	The properties of a database ledger digest upload settings.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, ledgerDigestUploads, resourceGroupName, serverName, subscriptionId	Gets the current ledger digest upload configuration for a database.
list_by_database	SELECT	databaseName, resourceGroupName, serverName, subscriptionId	Gets all ledger digest upload settings on a database.
create_or_update	INSERT	databaseName, ledgerDigestUploads, resourceGroupName, serverName, subscriptionId	Enables upload ledger digests to an Azure Storage account or an Azure Confidential Ledger instance.
disable	EXEC	databaseName, ledgerDigestUploads, resourceGroupName, serverName, subscriptionId	Disables uploading ledger digests to an Azure Storage account or an Azure Confidential Ledger instance.

SELECT examples

Gets all ledger digest upload settings on a database.

vw_ledger_digest_uploads

SELECT
databaseName,
digest_storage_endpoint,
ledgerDigestUploads,
resourceGroupName,
serverName,
state,
subscriptionId
FROM azure.sql.vw_ledger_digest_uploads
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

ledger_digest_uploads

SELECT
properties
FROM azure.sql.ledger_digest_uploads
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 ledger_digest_uploads resource.

All Properties

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

Manifest

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