IS_CONFIGURATION_SET (SYS_CONTEXT function)¶

Syntax¶

SYS_CONTEXT(
  'SNOWFLAKE$APPLICATION' ,
  'IS_CONFIGURATION_SET' ,
  '<config_name>' ,
)

Arguments¶

'SNOWFLAKE$APPLICATION'

Specifies that you want to call a function to return context information about the app in which the function is called.

'IS_CONFIGURATION_SET'

Calls the IS_CONFIGURATION_SET function.

'config_name'

Specifies the name of the configuration to check.

Returns¶

The function returns one of the following VARCHAR values:

• 'TRUE' if the configuration has a value set.

• 'FALSE' if the configuration does not have a value set.

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

SELECT SYS_CONTEXT('SNOWFLAKE$APPLICATION', 'IS_CONFIGURATION_SET', 'my_config_name')::BOOLEAN = TRUE;

Usage notes¶

• This function can only be used by an app.