is_member function (Databricks SQL)

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 spcifying a group.

Returns

A BOOLEAN.

Examples

> SELECT is_member('admins');
 false
> SELECT is_member('dev');
 true