Skip to main content

vw_workspaces

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

Overview​

Namevw_workspaces
TypeView
Idazure.ml_services.vw_workspaces

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,
type as type,
systemData as system_data,
identity as identity,
kind as kind,
sku as sku,
tags as tags,
JSON_EXTRACT(properties, '$.allowPublicAccessWhenBehindVnet') as "allow_public_access_when_behind_vnet",
JSON_EXTRACT(properties, '$.allowRoleAssignmentOnRG') as "allow_role_assignment_on_rg",
JSON_EXTRACT(properties, '$.applicationInsights') as "application_insights",
JSON_EXTRACT(properties, '$.associatedWorkspaces') as "associated_workspaces",
JSON_EXTRACT(properties, '$.containerRegistries') as "container_registries",
JSON_EXTRACT(properties, '$.containerRegistry') as "container_registry",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.discoveryUrl') as "discovery_url",
JSON_EXTRACT(properties, '$.enableDataIsolation') as "enable_data_isolation",
JSON_EXTRACT(properties, '$.enableServiceSideCMKEncryption') as "enable_service_side_cmk_encryption",
JSON_EXTRACT(properties, '$.enableSimplifiedCmk') as "enable_simplified_cmk",
JSON_EXTRACT(properties, '$.enableSoftwareBillOfMaterials') as "enable_software_bill_of_materials",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.existingWorkspaces') as "existing_workspaces",
JSON_EXTRACT(properties, '$.featureStoreSettings') as "feature_store_settings",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.hbiWorkspace') as "hbi_workspace",
JSON_EXTRACT(properties, '$.hubResourceId') as "hub_resource_id",
JSON_EXTRACT(properties, '$.imageBuildCompute') as "image_build_compute",
JSON_EXTRACT(properties, '$.ipAllowlist') as "ip_allowlist",
JSON_EXTRACT(properties, '$.keyVault') as "key_vault",
JSON_EXTRACT(properties, '$.keyVaults') as "key_vaults",
JSON_EXTRACT(properties, '$.managedNetwork') as "managed_network",
JSON_EXTRACT(properties, '$.mlFlowTrackingUri') as "ml_flow_tracking_uri",
JSON_EXTRACT(properties, '$.notebookInfo') as "notebook_info",
JSON_EXTRACT(properties, '$.primaryUserAssignedIdentity') as "primary_user_assigned_identity",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.privateLinkCount') as "private_link_count",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.serverlessComputeSettings') as "serverless_compute_settings",
JSON_EXTRACT(properties, '$.serviceManagedResourcesSettings') as "service_managed_resources_settings",
JSON_EXTRACT(properties, '$.serviceProvisionedResourceGroup') as "service_provisioned_resource_group",
JSON_EXTRACT(properties, '$.sharedPrivateLinkResources') as "shared_private_link_resources",
JSON_EXTRACT(properties, '$.softDeleteRetentionInDays') as "soft_delete_retention_in_days",
JSON_EXTRACT(properties, '$.storageAccount') as "storage_account",
JSON_EXTRACT(properties, '$.storageAccounts') as "storage_accounts",
JSON_EXTRACT(properties, '$.storageHnsEnabled') as "storage_hns_enabled",
JSON_EXTRACT(properties, '$.systemDatastoresAuthMode') as "system_datastores_auth_mode",
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.v1LegacyMode') as "v1_legacy_mode",
JSON_EXTRACT(properties, '$.workspaceHubConfig') as "workspace_hub_config",
JSON_EXTRACT(properties, '$.workspaceId') as "workspace_id",
subscriptionId,
resourceGroupName,
workspaceName
FROM azure.ml_services.workspaces
WHERE subscriptionId = 'replace-me';