Skip to main content
Version: current [26.x]

Categories: Boolean

IS_MEMBER

Returns whether the current user is a member of the specified role. When this function is used in a reflection, it can be pulled out at the time of materialization and re-applied at query time.

Syntax​

IS_MEMBER(expression varchar) → boolean​

  • expression: String expression identfying a role in Dremio.

Examples

IS_MEMBER example 
SELECT IS_MEMBER ('public')
-- True
IS_MEMBER example 
SELECT IS_MEMBER ('non-role')
-- False