vw_workspaces

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

Overview

Name	vw_workspaces
Type	View
Id	databricks_account.provisioning.vw_workspaces

Fields

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

SQL Definition

Sqlite3

select
workspace_id,
workspace_name,
deployment_name,
account_id,
aws_region,
workspace_status,
workspace_status_message,
pricing_tier,
is_no_public_ip_enabled,
credentials_id,
JSON_EXTRACT(identity_federation_info, '$.enable_identity_federation') as identity_federation_enabled,
storage_configuration_id,
JSON_EXTRACT(workspace_info, '$.compliance_security_profile.is_enabled') as compliance_security_profile_enabled,
JSON_EXTRACT(workspace_info, '$.enhanced_security_monitoring.is_enabled') as enhanced_security_monitoring_enabled,
creation_time
from databricks_account.provisioning.workspaces 
where account_id = 'ebfcc5a9-9d49-4c93-b651-b3ee6cf1c9ce' 

Postgres

select 
workspace_id,
workspace_name,
deployment_name,
account_id,
aws_region,
workspace_status,
workspace_status_message,
pricing_tier,
is_no_public_ip_enabled,
credentials_id,
json_extract_path_text(identity_federation_info, 'enable_identity_federation') as identity_federation_enabled,
storage_configuration_id,
json_extract_path_text(workspace_info, 'compliance_security_profile', 'is_enabled') as compliance_security_profile_enabled,
json_extract_path_text(workspace_info, 'enhanced_security_monitoring', 'is_enabled') as enhanced_security_monitoring_enabled,
creation_time
from databricks_account.provisioning.workspaces
where account_id = 'ebfcc5a9-9d49-4c93-b651-b3ee6cf1c9ce'