Control: Azure > SQL > Elastic Pool > Allowed > Region

Take an action when an Azure SQL elastic pool is created in a region that is not allowed.

The Allowed > Region control checks if the elastic pool is created in an allowed region based on the Allowed > Region > * policies. If the elastic pool is created in a region that is not in the allowed list, this control raises an alarm and takes the defined enforcement action.

For any enforcement actions that specify if new, e.g., Enforce: Delete if region not allowed and elastic pool is new, this control will only take the enforcement actions for resources created within the last 60 minutes.

Resource Types

This control targets the following resource types:

Azure > SQL > Elastic Pool

Policies

The following policies can be used to configure this control:

Azure > SQL > Elastic Pool > Allowed > Region

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

Azure > SQL > Elastic Pool > Allowed > Region > Regions

Permissions

Cloud permissions used by this control and its actions:

microsoft.sql/servers/elasticpools/delete

In Your Workspace

Developers

Control Type URI

tmod:@turbot/azure-sql#/control/types/elasticPoolAllowedRegion

Category URI

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

GraphQL

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

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

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-sql#/control/types/elasticPoolAllowedRegion"