vw_workspaces
Creates, updates, deletes, gets or lists a vw_workspaces resource.
Overview
| Name | vw_workspaces |
| Type | View |
| Id | azure.synapse.vw_workspaces |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
tags as tags,
identity as identity,
JSON_EXTRACT(properties, '$.defaultDataLakeStorage') as "default_data_lake_storage",
JSON_EXTRACT(properties, '$.sqlAdministratorLoginPassword') as "sql_administrator_login_password",
JSON_EXTRACT(properties, '$.managedResourceGroupName') as "managed_resource_group_name",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.sqlAdministratorLogin') as "sql_administrator_login",
JSON_EXTRACT(properties, '$.virtualNetworkProfile') as "virtual_network_profile",
JSON_EXTRACT(properties, '$.connectivityEndpoints') as "connectivity_endpoints",
JSON_EXTRACT(properties, '$.managedVirtualNetwork') as "managed_virtual_network",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.workspaceUID') as "workspace_uid",
JSON_EXTRACT(properties, '$.extraProperties') as "extra_properties",
JSON_EXTRACT(properties, '$.managedVirtualNetworkSettings') as "managed_virtual_network_settings",
JSON_EXTRACT(properties, '$.workspaceRepositoryConfiguration') as "workspace_repository_configuration",
JSON_EXTRACT(properties, '$.purviewConfiguration') as "purview_configuration",
JSON_EXTRACT(properties, '$.adlaResourceId') as "adla_resource_id",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.cspWorkspaceAdminProperties') as "csp_workspace_admin_properties",
JSON_EXTRACT(properties, '$.settings') as "settings",
JSON_EXTRACT(properties, '$.azureADOnlyAuthentication') as "azure_ad_only_authentication",
JSON_EXTRACT(properties, '$.trustedServiceBypassEnabled') as "trusted_service_bypass_enabled",
subscriptionId,
resourceGroupName,
workspaceName
FROM azure.synapse.workspaces
WHERE subscriptionId = 'replace-me';
SELECT
location as location,
tags as tags,
identity as identity,
json_extract_path_text(properties, '$.defaultDataLakeStorage') as "default_data_lake_storage",
json_extract_path_text(properties, '$.sqlAdministratorLoginPassword') as "sql_administrator_login_password",
json_extract_path_text(properties, '$.managedResourceGroupName') as "managed_resource_group_name",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.sqlAdministratorLogin') as "sql_administrator_login",
json_extract_path_text(properties, '$.virtualNetworkProfile') as "virtual_network_profile",
json_extract_path_text(properties, '$.connectivityEndpoints') as "connectivity_endpoints",
json_extract_path_text(properties, '$.managedVirtualNetwork') as "managed_virtual_network",
json_extract_path_text(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
json_extract_path_text(properties, '$.encryption') as "encryption",
json_extract_path_text(properties, '$.workspaceUID') as "workspace_uid",
json_extract_path_text(properties, '$.extraProperties') as "extra_properties",
json_extract_path_text(properties, '$.managedVirtualNetworkSettings') as "managed_virtual_network_settings",
json_extract_path_text(properties, '$.workspaceRepositoryConfiguration') as "workspace_repository_configuration",
json_extract_path_text(properties, '$.purviewConfiguration') as "purview_configuration",
json_extract_path_text(properties, '$.adlaResourceId') as "adla_resource_id",
json_extract_path_text(properties, '$.publicNetworkAccess') as "public_network_access",
json_extract_path_text(properties, '$.cspWorkspaceAdminProperties') as "csp_workspace_admin_properties",
json_extract_path_text(properties, '$.settings') as "settings",
json_extract_path_text(properties, '$.azureADOnlyAuthentication') as "azure_ad_only_authentication",
json_extract_path_text(properties, '$.trustedServiceBypassEnabled') as "trusted_service_bypass_enabled",
subscriptionId,
resourceGroupName,
workspaceName
FROM azure.synapse.workspaces
WHERE subscriptionId = 'replace-me';