vw_group_entitlements

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

Overview

Name	vw_group_entitlements
Type	View
Id	databricks_workspace.iam.vw_group_entitlements

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.
entitlement	string	Entitlement granted to the group (one row per entitlement, e.g. workspace-access, databricks-sql-access, allow-cluster-create).

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,
  entitlement
FROM databricks_workspace.iam.vw_group_entitlements
WHERE deployment_name = '{{ deployment_name }}';

SQL Definition

Sqlite3

SELECT
  g.deployment_name,
  g.id,
  g.displayName,
  JSON_EXTRACT(e.value, '$.value') AS entitlement
FROM databricks_workspace.iam.groups_v2 g,
     JSON_EACH(g.entitlements) e
WHERE g.deployment_name = '{{ deployment_name }}'

Postgres

SELECT
  g.deployment_name,
  g.id,
  g.displayName,
  e.value->>'value' AS entitlement
FROM databricks_workspace.iam.groups_v2 g,
     jsonb_array_elements(g.entitlements::jsonb) AS e
WHERE g.deployment_name = '{{ deployment_name }}'