SET_CONFIG - Amazon Redshift

SET_CONFIG

Sets a configuration parameter to a new setting.

This function is equivalent to the SET command in SQL.

Syntax

SET_CONFIG('parameter', 'new_value' , is_local)

The following statement sets a session context variable to a new setting.

set_config('variable_name', 'new_value' , is_local)

Arguments

parameter

Parameter to set.

variable_name

The name of the variable to set.

new_value

New value of the parameter.

is_local

If true, parameter value applies only to the current transaction. Valid values are true or 1 and false or 0.

Return type

Returns a CHAR or VARCHAR string.

Examples

To set the value of the query_group parameter to test for the current transaction only, use the following example.

SELECT SET_CONFIG('query_group', 'test', true); +------------+ | set_config | +------------+ | test | +------------+

To set session context variables, use the following example.

SELECT SET_CONFIG(‘app.username’, ‘cuddy’, FALSE);