Policy: Azure > SQL > Database > Approved > Regions

A list of Azure regions in which Azure SQL databases are approved for use.

The expected format is an array of regions names. You may use the '*' and '?' wildcard characters.

This policy will be evaluated by the Approved control. If an Azure SQL database is created in a region that is not in the approved list, it will be subject to the action specified in the Azure > SQL > Database > Approved policy.

See Approved for more information.

Resource Types

This policy targets the following resource types:

Azure > SQL > Database

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Database > Approved

Controls

Azure > SQL > Database > Approved

Policy Specification

Default template	`{% if $.regions.value \| length == 0 %} [] {% endif %}{% for item in $.regions.value %}- '{{ item }}' {% endfor %}`
Default template input	`\| { regions: policyValue(uri:"tmod:@turbot/azure-sql#/policy/types/sqlApprovedRegionsDefault") { value } }`

Default template

{% if $.regions.value | length == 0 %} [] {% endif %}{% for item in $.regions.value %}- '{{ item }}'
{% endfor %}

Default template input

|
  {
    regions: policyValue(uri:"tmod:@turbot/azure-sql#/policy/types/sqlApprovedRegionsDefault") {
      value
    }
  }

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/databaseApprovedRegions"