IS_GROUP_IMPORTED (SYS_CONTEXT function)¶

Returns the VARCHAR value 'TRUE' if the specified group is an organization user group that was imported into the current account.

See also:: SYS_CONTEXT (SNOWFLAKE$ORGANIZATION namespace) , IS_GROUP_ACTIVATED (SYS_CONTEXT function) , IS_USER_IMPORTED (SYS_CONTEXT function)

Syntax¶

SYS_CONTEXT(
  'SNOWFLAKE$ORGANIZATION' ,
  'IS_GROUP_IMPORTED' ,
  '<group_name>'
)

'SNOWFLAKE$ORGANIZATION': Specifies that you want to call a function to return context information about the current organization.
'IS_GROUP_IMPORTED': Calls the IS_GROUP_IMPORTED function.
'group_name': Specifies the name of the organization user group to check.

The function returns one of the following VARCHAR values:

'TRUE' if the organization user group was imported into the current account.
'FALSE' if the organization user group was not imported into the current account or is not a valid organization user group.

To compare this return value against the BOOLEAN value TRUE or FALSE, cast the return value to BOOLEAN. For example:

SELECT SYS_CONTEXT('SNOWFLAKE$ORGANIZATION', 'IS_GROUP_IMPORTED', 'my_group_name')::BOOLEAN = TRUE;

The following example returns 'TRUE' if the group my_group_name is an organization user group that was imported into the current account:

SELECT SYS_CONTEXT('SNOWFLAKE$ORGANIZATION', 'IS_GROUP_IMPORTED', 'my_group_name');