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: A STRING expression specifying a group.

Returns

A BOOLEAN.

Examples

SQL

> SELECT is_member('admins');
 false

> SELECT is_member('dev');
 true

Related functions

• current_user function
• is_account_group_member function
• session_user function