vw_adc_catalogs

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

Overview

Name	vw_adc_catalogs
Type	View
Id	azure.data_catalog.vw_adc_catalogs

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
etag as etag,
JSON_EXTRACT(properties, '$.sku') as "sku",
JSON_EXTRACT(properties, '$.units') as "units",
JSON_EXTRACT(properties, '$.admins') as "admins",
JSON_EXTRACT(properties, '$.users') as "users",
JSON_EXTRACT(properties, '$.successfullyProvisioned') as "successfully_provisioned",
JSON_EXTRACT(properties, '$.enableAutomaticUnitAdjustment') as "enable_automatic_unit_adjustment",
subscriptionId,
resourceGroupName,
catalogName
FROM azure.data_catalog.adc_catalogs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND catalogName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
etag as etag,
json_extract_path_text(properties, '$.sku') as "sku",
json_extract_path_text(properties, '$.units') as "units",
json_extract_path_text(properties, '$.admins') as "admins",
json_extract_path_text(properties, '$.users') as "users",
json_extract_path_text(properties, '$.successfullyProvisioned') as "successfully_provisioned",
json_extract_path_text(properties, '$.enableAutomaticUnitAdjustment') as "enable_automatic_unit_adjustment",
subscriptionId,
resourceGroupName,
catalogName
FROM azure.data_catalog.adc_catalogs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND catalogName = 'replace-me';