Skip to main content

vw_accounts

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

Overview​

Namevw_accounts
TypeView
Idazure.purview.vw_accounts

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
location as location,
identity as identity,
systemData as system_data,
tags as tags,
type as type,
sku as sku,
JSON_EXTRACT(properties, '$.accountStatus') as "account_status",
JSON_EXTRACT(properties, '$.cloudConnectors') as "cloud_connectors",
JSON_EXTRACT(properties, '$.createdAt') as "created_at",
JSON_EXTRACT(properties, '$.createdBy') as "created_by",
JSON_EXTRACT(properties, '$.createdByObjectId') as "created_by_object_id",
JSON_EXTRACT(properties, '$.defaultDomain') as "default_domain",
JSON_EXTRACT(properties, '$.endpoints') as "endpoints",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.ingestionStorage') as "ingestion_storage",
JSON_EXTRACT(properties, '$.managedEventHubState') as "managed_event_hub_state",
JSON_EXTRACT(properties, '$.managedResourceGroupName') as "managed_resource_group_name",
JSON_EXTRACT(properties, '$.managedResources') as "managed_resources",
JSON_EXTRACT(properties, '$.managedResourcesPublicNetworkAccess') as "managed_resources_public_network_access",
JSON_EXTRACT(properties, '$.mergeInfo') as "merge_info",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.tenantEndpointState') as "tenant_endpoint_state",
subscriptionId,
resourceGroupName,
accountName
FROM azure.purview.accounts
WHERE subscriptionId = 'replace-me';