location_based_performance_tiers

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

Overview

Name	location_based_performance_tiers
Type	Resource
Id	azure.maria_db.location_based_performance_tiers

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
id	string	ID of the performance tier.
maxBackupRetentionDays	integer (int32)	Maximum Backup retention in days for the performance tier edition
maxLargeStorageMB	integer (int32)	Max storage allowed for a server.
maxStorageMB	integer (int32)	Max storage allowed for a server.
minBackupRetentionDays	integer (int32)	Minimum Backup retention in days for the performance tier edition
minLargeStorageMB	integer (int32)	Max storage allowed for a server.
minStorageMB	integer (int32)	Max storage allowed for a server.
serviceLevelObjectives	array	Service level objectives associated with the performance tier

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, locationName		List all the performance tiers 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.

Name	Datatype	Description
locationName	string	The name of the location.
subscriptionId	string	The ID of the target subscription.

SELECT examples

list

List all the performance tiers at specified location in a given subscription.

SELECT
id,
maxBackupRetentionDays,
maxLargeStorageMB,
maxStorageMB,
minBackupRetentionDays,
minLargeStorageMB,
minStorageMB,
serviceLevelObjectives
FROM azure.maria_db.location_based_performance_tiers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND locationName = '{{ locationName }}' -- required
;