vw_group_members

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

Overview

Name	vw_group_members
Type	View
Id	databricks_workspace.iam.vw_group_members

Fields

The following fields are returned by this view:

Name	Datatype	Description
deployment_name	string	Workspace deployment name used to scope the query.
id	string	Unique identifier for the workspace group.
displayName	string	Human-readable display name of the workspace 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 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
deployment_name	string	Workspace deployment name used to scope the query.

SELECT Examples

SELECT
  deployment_name,
  id,
  displayName,
  member_id,
  member_display,
  member_ref,
  member_type
FROM databricks_workspace.iam.vw_group_members
WHERE deployment_name = '{{ deployment_name }}';

SQL Definition

Sqlite3

SELECT
  g.deployment_name,
  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_workspace.iam.groups_v2 g,
     JSON_EACH(g.members) m
WHERE g.deployment_name = '{{ deployment_name }}'

Postgres

SELECT
  g.deployment_name,
  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_workspace.iam.groups_v2 g,
     jsonb_array_elements(g.members::jsonb) AS m
WHERE g.deployment_name = '{{ deployment_name }}'