is_member function

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

Returns true if the current user is a direct or indirect member of the specified group.

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