is_account_group_member function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime check marked yes Unity Catalog only

Returns true if the session (connected) user is a direct or indirect member of the specified group at the account level.

Syntax 

is_account_group_member(group)

Arguments

  • group: A STRING expression specifying a group.

Returns

A BOOLEAN.

Examples 

> SELECT is_account_group_member('admins');
 false

> SELECT is_account_group_member('dev');
 true