Control: Azure > Synapse Analytics > SQL Pool > Approved

Take an action when an Azure Synapse Analytics sql pool is not approved based on Azure > Synapse Analytics > SQL Pool > Approved > * policies.

The Approved control checks the status of the defined Approved sub-policies for the resource. If the resource is not approved according to any of these policies, this control raises an alarm and takes the defined enforcement action.

For any enforcement actions that specify if new, e.g., Enforce: Delete unapproved if new, this control will only take the enforcement actions for resources created within the last 60 minutes.

See Approved for more information.

Resource Types

This control targets the following resource types:

Azure > Synapse Analytics > SQL Pool

Policies

The following policies can be used to configure this control:

Azure > Synapse Analytics > SQL Pool > Approved

This control type relies on these other policies when running actions:

Permissions

Cloud permissions used by this control and its actions:

microsoft.synapse/workspaces/sqlpools/delete

In Your Workspace

Developers

Control Type URI

tmod:@turbot/azure-synapseanalytics#/control/types/sqlPoolApproved

Category URI

tmod:@turbot/turbot#/control/categories/resourceApproved

GraphQL

query controlType(id: "tmod:@turbot/azure-synapseanalytics#/control/types/sqlPoolApproved") { … }

query controls(filter: "controlTypeId:'tmod:@turbot/azure-synapseanalytics#/control/types/sqlPoolApproved'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-synapseanalytics#/control/types/sqlPoolApproved"