workspace_managed_sql_server_extended_blob_auditing_policies

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

Overview

Name	workspace_managed_sql_server_extended_blob_auditing_policies
Type	Resource
Id	azure.synapse.workspace_managed_sql_server_extended_blob_auditing_policies

Fields

vw_workspace_managed_sql_server_extended_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_devops_audit_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
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

workspace_managed_sql_server_extended_blob_auditing_policies

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	blobAuditingPolicyName, resourceGroupName, subscriptionId, workspaceName	Get a workspace SQL server's extended blob auditing policy.
list_by_workspace	SELECT	resourceGroupName, subscriptionId, workspaceName	List workspace managed sql server's extended blob auditing policies.
create_or_update	INSERT	blobAuditingPolicyName, resourceGroupName, subscriptionId, workspaceName	Create or Update a workspace managed sql server's extended blob auditing policy.

SELECT examples

List workspace managed sql server's extended blob auditing policies.

vw_workspace_managed_sql_server_extended_blob_auditing_policies

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

workspace_managed_sql_server_extended_blob_auditing_policies

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.workspace_managed_sql_server_extended_blob_auditing_policies (
blobAuditingPolicyName,
resourceGroupName,
subscriptionId,
workspaceName,
properties
)
SELECT 
'{{ blobAuditingPolicyName }}',
'{{ resourceGroupName }}',
'{{ 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
        - name: isDevopsAuditEnabled
          value: boolean