Policy: Azure > SQL > Server > Regions

Regions where Azure supports SQL Server. Guardrails updates this option as Azure expands their regional support. Unless there is an explicit requirement (e.g. accelerated regional support), it should not be set by Guardrails Administrators.

Targets

This policy targets the following resource types:

Azure > Subscription

Controls

Setting this policy configures these controls:

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/sqlRegionsDefault") { 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/sqlRegionsDefault") {
      value
    }
  }

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

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

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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