extended_sql_pool_blob_auditing_policies

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

Overview

Name	extended_sql_pool_blob_auditing_policies
Type	Resource
Id	azure.synapse.extended_sql_pool_blob_auditing_policies

Fields

vw_extended_sql_pool_blob_auditing_policies

Name	Datatype	Description
audit_actions_and_groups	text	field from the properties object
blobAuditingPolicyName	text	field from the properties object
is_azure_monitor_target_enabled	text	field from the properties object
is_storage_secondary_key_in_use	text	field from the properties object
predicate_expression	text	field from the properties object
queue_delay_ms	text	field from the properties object
resourceGroupName	text	field from the properties object
retention_days	text	field from the properties object
sqlPoolName	text	field from the properties object
state	text	field from the properties object
storage_account_access_key	text	field from the properties object
storage_account_subscription_id	text	field from the properties object
storage_endpoint	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

extended_sql_pool_blob_auditing_policies

Name	Datatype	Description
properties	object	Properties of an extended Sql pool blob auditing policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	blobAuditingPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Gets an extended Sql pool's blob auditing policy.
list_by_sql_pool	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Lists extended auditing settings of a Sql pool.
create_or_update	INSERT	blobAuditingPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Creates or updates an extended Sql pool's blob auditing policy.

SELECT examples

Lists extended auditing settings of a Sql pool.

vw_extended_sql_pool_blob_auditing_policies

SELECT
audit_actions_and_groups,
blobAuditingPolicyName,
is_azure_monitor_target_enabled,
is_storage_secondary_key_in_use,
predicate_expression,
queue_delay_ms,
resourceGroupName,
retention_days,
sqlPoolName,
state,
storage_account_access_key,
storage_account_subscription_id,
storage_endpoint,
subscriptionId,
workspaceName
FROM azure.synapse.vw_extended_sql_pool_blob_auditing_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

extended_sql_pool_blob_auditing_policies

SELECT
properties
FROM azure.synapse.extended_sql_pool_blob_auditing_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.extended_sql_pool_blob_auditing_policies (
blobAuditingPolicyName,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName,
properties
)
SELECT 
'{{ blobAuditingPolicyName }}',
'{{ resourceGroupName }}',
'{{ sqlPoolName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: predicateExpression
          value: string
        - name: state
          value: string
        - name: storageEndpoint
          value: string
        - name: storageAccountAccessKey
          value: string
        - name: retentionDays
          value: integer
        - name: auditActionsAndGroups
          value:
            - string
        - name: storageAccountSubscriptionId
          value: string
        - name: isStorageSecondaryKeyInUse
          value: boolean
        - name: isAzureMonitorTargetEnabled
          value: boolean
        - name: queueDelayMs
          value: integer