Skip to main content

location_based_capabilities

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

Overview

Namelocation_based_capabilities
TypeResource
Idazure.mysql.location_based_capabilities

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
supportedFlexibleServerEditionsarrayA list of supported flexible server editions.
supportedGeoBackupRegionsarraysupported geo backup regions
supportedHAModearraySupported high availability mode
zonestringzone name

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectsubscriptionId, locationNameGet capabilities at specified location in a given subscription.

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.

NameDatatypeDescription
locationNamestringThe name of the location.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get capabilities at specified location in a given subscription.

SELECT
supportedFlexibleServerEditions,
supportedGeoBackupRegions,
supportedHAMode,
zone
FROM azure.mysql.location_based_capabilities
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND locationName = '{{ locationName }}' -- required
;