vw_group_quota_limits

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

Overview

Name	vw_group_quota_limits
Type	View
Id	azure.quota.vw_group_quota_limits

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.region') as "region",
JSON_EXTRACT(properties, '$.limit') as "limit",
JSON_EXTRACT(properties, '$.comment') as "comment",
JSON_EXTRACT(properties, '$.name') as "name",
JSON_EXTRACT(properties, '$.unit') as "unit",
JSON_EXTRACT(properties, '$.availableLimit') as "available_limit",
JSON_EXTRACT(properties, '$.allocatedToSubscriptions') as "allocated_to_subscriptions",
managementGroupId,
groupQuotaName,
resourceProviderName,
resourceName,
$filter
FROM azure.quota.group_quota_limits
WHERE managementGroupId = 'replace-me' AND groupQuotaName = 'replace-me' AND resourceProviderName = 'replace-me' AND $filter = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.region') as "region",
json_extract_path_text(properties, '$.limit') as "limit",
json_extract_path_text(properties, '$.comment') as "comment",
json_extract_path_text(properties, '$.name') as "name",
json_extract_path_text(properties, '$.unit') as "unit",
json_extract_path_text(properties, '$.availableLimit') as "available_limit",
json_extract_path_text(properties, '$.allocatedToSubscriptions') as "allocated_to_subscriptions",
managementGroupId,
groupQuotaName,
resourceProviderName,
resourceName,
$filter
FROM azure.quota.group_quota_limits
WHERE managementGroupId = 'replace-me' AND groupQuotaName = 'replace-me' AND resourceProviderName = 'replace-me' AND $filter = 'replace-me';