is_member
function
Applies to: Databricks SQL 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
: ASTRING
expression specifying a group.
Returns
A BOOLEAN
.
Examples
> SELECT is_member('admins');
false
> SELECT is_member('dev');
true