vw_account_group_roles

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

Overview

Name	vw_account_group_roles
Type	View
Id	databricks_account.iam.vw_account_group_roles

Fields

The following fields are returned by this view:

Name	Datatype	Description
account_id	string	Databricks account ID used to scope the query.
id	string	Unique identifier for the account group.
displayName	string	Human-readable display name of the account group.
role	string	Role assigned to the group (one row per role assignment).

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,
  id,
  displayName,
  role
FROM databricks_account.iam.vw_account_group_roles
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  g.account_id,
  g.id,
  g.displayName,
  JSON_EXTRACT(r.value, '$.value') AS role
FROM databricks_account.iam.account_groups g,
     JSON_EACH(g.roles) r
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  g.account_id,
  g.id,
  g.displayName,
  r.value->>'value' AS role
FROM databricks_account.iam.account_groups g,
     jsonb_array_elements(g.roles::jsonb) AS r
WHERE account_id = '{{ account_id }}'