Categories:

Context functions (General)

GET_CONFIGURATION_VALUE (SYS_CONTEXT function)

Returns the current value for the specified configuration.

See also:

SYS_CONTEXT (SNOWFLAKE$APPLICATION namespace)

Syntax

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

Arguments

'SNOWFLAKE$APPLICATION'

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

'GET_CONFIGURATION_VALUE'

Calls the GET_CONFIGURATION_VALUE function.

'config_name'

Specifies the name of the configuration to get the value for.

Returns

The function returns the current value of the configuration.

2026_06 behavior change bundle

When the 2026_06 behavior change bundle is enabled in your account, this function continues to return VARCHAR.

Existing casts, such as ::BOOLEAN or ::NUMBER, continue to work unchanged.

For the return type of every property and function by namespace, see SYS_CONTEXT return types.

Usage notes

  • This function can only be used by an app.
  • For a configuration definition of type APPLICATION_NAME, the value returned is the current name of the application stored in the specified configuration.