vw_users

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

Overview

Name	vw_users
Type	View
Id	databricks_workspace.iam.vw_users

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 user.
userName	string	Username (typically email address) of the workspace user.
displayName	string	Human-readable display name of the workspace user.
active	boolean	Whether the user account is active.
externalId	string	External identity provider ID for the user (SCIM provisioned users only).
givenName	string	First (given) name of the user.
familyName	string	Last (family) name of the user.
email	string	Email address for this entry (one row per email address).
email_type	string	Type classification of the email address (e.g. work).
is_primary	boolean	Whether this email address is the user's primary email.

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,
  userName,
  displayName,
  active,
  externalId,
  givenName,
  familyName,
  email,
  email_type,
  is_primary
FROM databricks_workspace.iam.vw_users
WHERE deployment_name = '{{ deployment_name }}';

SQL Definition

Sqlite3

SELECT
  u.deployment_name,
  u.id,
  u.userName,
  u.displayName,
  u.active,
  u.externalId,
  JSON_EXTRACT(u.name, '$.givenName') AS givenName,
  JSON_EXTRACT(u.name, '$.familyName') AS familyName,
  JSON_EXTRACT(e.value, '$.value') AS email,
  JSON_EXTRACT(e.value, '$.type') AS email_type,
  JSON_EXTRACT(e.value, '$.primary') AS is_primary
FROM databricks_workspace.iam.users_v2 u,
     JSON_EACH(u.emails) e
WHERE u.deployment_name = '{{ deployment_name }}'

Postgres

SELECT
  u.deployment_name,
  u.id,
  u.userName,
  u.displayName,
  u.active,
  u.externalId,
  u.name->>'givenName' AS givenName,
  u.name->>'familyName' AS familyName,
  e.value->>'value' AS email,
  e.value->>'type' AS email_type,
  (e.value->>'primary')::boolean AS is_primary
FROM databricks_workspace.iam.users_v2 u,
     jsonb_array_elements(u.emails::jsonb) AS e
WHERE u.deployment_name = '{{ deployment_name }}'