users

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

Overview

Name	users
Type	Resource
Id	databricks_account.iamv2.users

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
account_id	string	The accountId parent of the user in Databricks.
external_id	string	ExternalId of the user in the customer's IdP.
internal_id	string	Internal userId of the user in Databricks.
▶full_name	object
account_user_status	string	The activity status of a user in a Databricks account. (ACTIVE, INACTIVE)
username	string	Username/email of the user.

list

Name	Datatype	Description
account_id	string	The accountId parent of the user in Databricks.
external_id	string	ExternalId of the user in the customer's IdP.
internal_id	string	Internal userId of the user in Databricks.
▶full_name	object
account_user_status	string	The activity status of a user in a Databricks account. (ACTIVE, INACTIVE)
username	string	Username/email of the user.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	account_id, internal_id		Fetches a user from the Databricks account by its internal ID.
list	select	account_id	filter, page_size, page_token	Lists the users in the Databricks account, returning one page per call. Supports filtering by username
create	insert	account_id, user		Creates a user in the Databricks account and returns the resulting User resource. Behavior depends on
update	update	account_id, internal_id, update_mask, user		Updates an existing user in the Databricks account, returning the updated User resource. The behavior
delete	delete	account_id, internal_id		Deletes a user from the Databricks account by its internal ID.
resolve	exec	account_id, external_id		Resolves a user with the given external ID from the customer's IdP. If the user does not exist, it

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
account_id	string
internal_id	string	Required. Internal ID of the user in Databricks.
update_mask	string	Optional. The list of fields to update.
filter	string	Optional. Allows filtering users by username or external id.
page_size	integer	The maximum number of users to return. The service may return fewer than this value.
page_token	string	A page token, received from a previous ListUsers call. Provide this to retrieve the subsequent page.

SELECT examples

get

Fetches a user from the Databricks account by its internal ID.

SELECT
account_id,
external_id,
internal_id,
full_name,
account_user_status,
username
FROM databricks_account.iamv2.users
WHERE account_id = '{{ account_id }}' -- required
AND internal_id = '{{ internal_id }}' -- required
;

list

Lists the users in the Databricks account, returning one page per call. Supports filtering by username

SELECT
account_id,
external_id,
internal_id,
full_name,
account_user_status,
username
FROM databricks_account.iamv2.users
WHERE account_id = '{{ account_id }}' -- required
AND filter = '{{ filter }}'
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

INSERT examples

create

Creates a user in the Databricks account and returns the resulting User resource. Behavior depends on

INSERT INTO databricks_account.iamv2.users (
user,
account_id
)
SELECT 
'{{ user }}' /* required */,
'{{ account_id }}'
RETURNING
account_id,
external_id,
internal_id,
full_name,
account_user_status,
username
;

Manifest

# Description fields are for documentation purposes
- name: users
props:
  - name: account_id
    value: "{{ account_id }}"
    description: Required parameter for the users resource.
  - name: user
    description: |
      Required. User to be created in <Databricks>
    value:
      account_id: "{{ account_id }}"
      account_user_status: "{{ account_user_status }}"
      external_id: "{{ external_id }}"
      full_name:
        family_name: "{{ family_name }}"
        given_name: "{{ given_name }}"
      internal_id: "{{ internal_id }}"
      username: "{{ username }}"

UPDATE examples

update

Updates an existing user in the Databricks account, returning the updated User resource. The behavior

UPDATE databricks_account.iamv2.users
SET 
user = '{{ user }}'
WHERE 
account_id = '{{ account_id }}' --required
AND internal_id = '{{ internal_id }}' --required
AND update_mask = '{{ update_mask }}' --required
AND user = '{{ user }}' --required
RETURNING
account_id,
external_id,
internal_id,
full_name,
account_user_status,
username;

DELETE examples

delete

Deletes a user from the Databricks account by its internal ID.

DELETE FROM databricks_account.iamv2.users
WHERE account_id = '{{ account_id }}' --required
AND internal_id = '{{ internal_id }}' --required
;

Lifecycle Methods

resolve

Resolves a user with the given external ID from the customer's IdP. If the user does not exist, it

EXEC databricks_account.iamv2.users.resolve 
@account_id='{{ account_id }}' --required 
@@json=
'{
"external_id": "{{ external_id }}"
}'
;