vw_storage_configurations

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

Overview

Name	vw_storage_configurations
Type	View
Id	databricks_account.provisioning.vw_storage_configurations

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
storage_configuration_id	string	Unique identifier for the storage configuration.
storage_configuration_name	string	Human-readable name of the storage configuration.
creation_time	integer	Unix timestamp (ms) when the storage configuration was created.
role_arn	string	ARN of the AWS IAM role used to access the root storage bucket (AWS only).
root_bucket_name	string	Name of the S3 bucket used as the workspace root storage (AWS only).

Required Parameters

The following parameters are required by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.

SELECT Examples

SELECT
  account_id,
  storage_configuration_id,
  storage_configuration_name,
  creation_time,
  role_arn,
  root_bucket_name
FROM databricks_account.provisioning.vw_storage_configurations
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  s.account_id,
  s.storage_configuration_id,
  s.storage_configuration_name,
  s.creation_time,
  s.role_arn,
  JSON_EXTRACT(s.root_bucket_info, '$.bucket_name') AS root_bucket_name
FROM databricks_account.provisioning.storage s
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  s.account_id,
  s.storage_configuration_id,
  s.storage_configuration_name,
  s.creation_time,
  s.role_arn,
  s.root_bucket_info->>'bucket_name' AS root_bucket_name
FROM databricks_account.provisioning.storage s
WHERE account_id = '{{ account_id }}'