is_member function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns true if the session (connected) user is a direct or indirect member of the specified group if the specified group is a workspace local group or an account level group assigned to the workspace.

In most cases you should use is_account_group_member function to test group membership at the account level.

Syntax 

is_member(group)

Arguments

  • group: A STRING expression specifying a group.

Returns

A BOOLEAN.

Examples 

> SELECT is_member('admins');
 false

> SELECT is_member('dev');
 true