vw_account_group_members

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

Overview

Name	vw_account_group_members
Type	View
Id	databricks_account.iam.vw_account_group_members

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.
member_id	string	Unique identifier of the group member (one row per member).
member_display	string	Display name of the group member.
member_ref	string	SCIM $ref URI for the group member resource.
member_type	string	Type of the member resource (e.g. User, Group, ServicePrincipal).

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,
  member_id,
  member_display,
  member_ref,
  member_type
FROM databricks_account.iam.vw_account_group_members
WHERE account_id = '{{ account_id }}';

SQL Definition

Sqlite3

SELECT
  g.account_id,
  g.id,
  g.displayName,
  JSON_EXTRACT(m.value, '$.value') AS member_id,
  JSON_EXTRACT(m.value, '$.display') AS member_display,
  JSON_EXTRACT(m.value, '$.$ref') AS member_ref,
  JSON_EXTRACT(m.value, '$.type') AS member_type
FROM databricks_account.iam.account_groups g,
     JSON_EACH(g.members) m
WHERE account_id = '{{ account_id }}'

Postgres

SELECT
  g.account_id,
  g.id,
  g.displayName,
  m.value->>'value' AS member_id,
  m.value->>'display' AS member_display,
  m.value->>'$ref' AS member_ref,
  m.value->>'type' AS member_type
FROM databricks_account.iam.account_groups g,
     jsonb_array_elements(g.members::jsonb) AS m
WHERE account_id = '{{ account_id }}'