Policy: Azure > SQL > Server > Approved > Regions

A list of Azure regions in which Azure SQL servers 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 server is created in a region that is not in the approved list, it will be subject to the action specified in the Azure > SQL > Server > Approved policy.

See Approved for more information.

Resource Types

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Approved

Controls

Azure > SQL > Server > 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/serverApprovedRegions

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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