capabilities

Creates, updates, deletes, gets or lists a capabilities resource.

Overview

Name	capabilities
Type	Resource
Id	azure.sql.capabilities

Fields

The following fields are returned by SELECT queries:

list_by_location

Name	Datatype	Description
name	string	The location name.
isZoneResilientProvisioningAllowed	boolean	Whether or not the subscription is allowed to provision zone resilient resources.
reason	string	The reason for the capability not being available.
status	string	The status of the capability. Known values are: "Visible", "Available", "Default", and "Disabled". (Visible, Available, Default, Disabled)
supportedJobAgentVersions	array	The list of supported job agent versions.
supportedManagedInstanceVersions	array	The list of supported managed instance versions.
supportedServerVersions	array	The list of supported server versions.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_location	select	location_name, subscription_id	include	Gets the subscription capabilities available for the specified location.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
location_name	string	The location name whose capabilities are retrieved. Required.
subscription_id	string
include	string	If specified, restricts the response to only include the selected item. Known values are: "supportedEditions", "supportedElasticPoolEditions", "supportedManagedInstanceVersions", "supportedInstancePoolEditions", "supportedManagedInstanceEditions", and "supportedJobAgentVersions". Default value is None.

SELECT examples

list_by_location

Gets the subscription capabilities available for the specified location.

SELECT
name,
isZoneResilientProvisioningAllowed,
reason,
status,
supportedJobAgentVersions,
supportedManagedInstanceVersions,
supportedServerVersions
FROM azure.sql.capabilities
WHERE location_name = '{{ location_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND include = '{{ include }}'
;