vw_credentials

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

Overview

Name	vw_credentials
Type	View
Id	databricks_account.provisioning.vw_credentials

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
credentials_id	string	Unique identifier for the credential configuration.
credentials_name	string	Human-readable name of the credential configuration.
creation_time	integer	Unix timestamp (ms) when the credential configuration was created.
aws_role_arn	string	ARN of the AWS IAM role Databricks uses to manage resources in the customer account (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,
  credentials_id,
  credentials_name,
  creation_time,
  aws_role_arn
FROM databricks_account.provisioning.vw_credentials
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  c.account_id,
  c.credentials_id,
  c.credentials_name,
  c.creation_time,
  JSON_EXTRACT(c.aws_credentials, '$.sts_role.role_arn') AS aws_role_arn
FROM databricks_account.provisioning.credentials c
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  c.account_id,
  c.credentials_id,
  c.credentials_name,
  c.creation_time,
  c.aws_credentials->'sts_role'->>'role_arn' AS aws_role_arn
FROM databricks_account.provisioning.credentials c
WHERE account_id = '{{ account_id }}'