vw_elastic_pools

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

Overview

Name	vw_elastic_pools
Type	View
Id	azure.sql.vw_elastic_pools

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
sku as sku,
kind as kind,
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.maxSizeBytes') as "max_size_bytes",
JSON_EXTRACT(properties, '$.minCapacity') as "min_capacity",
JSON_EXTRACT(properties, '$.perDatabaseSettings') as "per_database_settings",
JSON_EXTRACT(properties, '$.zoneRedundant') as "zone_redundant",
JSON_EXTRACT(properties, '$.licenseType') as "license_type",
JSON_EXTRACT(properties, '$.maintenanceConfigurationId') as "maintenance_configuration_id",
JSON_EXTRACT(properties, '$.highAvailabilityReplicaCount') as "high_availability_replica_count",
JSON_EXTRACT(properties, '$.preferredEnclaveType') as "preferred_enclave_type",
JSON_EXTRACT(properties, '$.availabilityZone') as "availability_zone",
subscriptionId,
resourceGroupName,
serverName,
elasticPoolName
FROM azure.sql.elastic_pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
sku as sku,
kind as kind,
json_extract_path_text(properties, '$.state') as "state",
json_extract_path_text(properties, '$.creationDate') as "creation_date",
json_extract_path_text(properties, '$.maxSizeBytes') as "max_size_bytes",
json_extract_path_text(properties, '$.minCapacity') as "min_capacity",
json_extract_path_text(properties, '$.perDatabaseSettings') as "per_database_settings",
json_extract_path_text(properties, '$.zoneRedundant') as "zone_redundant",
json_extract_path_text(properties, '$.licenseType') as "license_type",
json_extract_path_text(properties, '$.maintenanceConfigurationId') as "maintenance_configuration_id",
json_extract_path_text(properties, '$.highAvailabilityReplicaCount') as "high_availability_replica_count",
json_extract_path_text(properties, '$.preferredEnclaveType') as "preferred_enclave_type",
json_extract_path_text(properties, '$.availabilityZone') as "availability_zone",
subscriptionId,
resourceGroupName,
serverName,
elasticPoolName
FROM azure.sql.elastic_pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me';