vw_postgres_instances
Creates, updates, deletes, gets or lists a vw_postgres_instances resource.
Overview
| Name | vw_postgres_instances |
| Type | View |
| Id | azure.azure_arc_data.vw_postgres_instances |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
tags as tags,
extendedLocation as extended_location,
sku as sku,
JSON_EXTRACT(properties, '$.dataControllerId') as "data_controller_id",
JSON_EXTRACT(properties, '$.admin') as "admin",
JSON_EXTRACT(properties, '$.basicLoginInformation') as "basic_login_information",
JSON_EXTRACT(properties, '$.k8sRaw') as "k8s_raw",
JSON_EXTRACT(properties, '$.lastUploadedDate') as "last_uploaded_date",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
postgresInstanceName
FROM azure.azure_arc_data.postgres_instances
WHERE subscriptionId = 'replace-me';
SELECT
location as location,
tags as tags,
extendedLocation as extended_location,
sku as sku,
json_extract_path_text(properties, '$.dataControllerId') as "data_controller_id",
json_extract_path_text(properties, '$.admin') as "admin",
json_extract_path_text(properties, '$.basicLoginInformation') as "basic_login_information",
json_extract_path_text(properties, '$.k8sRaw') as "k8s_raw",
json_extract_path_text(properties, '$.lastUploadedDate') as "last_uploaded_date",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
postgresInstanceName
FROM azure.azure_arc_data.postgres_instances
WHERE subscriptionId = 'replace-me';