vw_private_stores

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

Overview

Name	vw_private_stores
Type	View
Id	azure_extras.marketplace.vw_private_stores

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.availability') as "availability",
JSON_EXTRACT(properties, '$.privateStoreId') as "private_store_id",
JSON_EXTRACT(properties, '$.eTag') as "e_tag",
JSON_EXTRACT(properties, '$.privateStoreName') as "private_store_name",
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.isGov') as "is_gov",
JSON_EXTRACT(properties, '$.collectionIds') as "collection_ids",
JSON_EXTRACT(properties, '$.branding') as "branding",
JSON_EXTRACT(properties, '$.notificationsSettings') as "notifications_settings",
privateStoreId
FROM azure_extras.marketplace.private_stores
WHERE privateStoreId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.availability') as "availability",
json_extract_path_text(properties, '$.privateStoreId') as "private_store_id",
json_extract_path_text(properties, '$.eTag') as "e_tag",
json_extract_path_text(properties, '$.privateStoreName') as "private_store_name",
json_extract_path_text(properties, '$.tenantId') as "tenant_id",
json_extract_path_text(properties, '$.isGov') as "is_gov",
json_extract_path_text(properties, '$.collectionIds') as "collection_ids",
json_extract_path_text(properties, '$.branding') as "branding",
json_extract_path_text(properties, '$.notificationsSettings') as "notifications_settings",
privateStoreId
FROM azure_extras.marketplace.private_stores
WHERE privateStoreId = 'replace-me';