IS_GROUP_IMPORTED (SYS_CONTEXT function)¶

Syntax¶

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

Arguments¶

'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.

Returns¶

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;

Usage notes¶

Examples¶

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');