SET_CONFIG - Amazon Redshift
SyntaxArgumentsReturn typeExamples
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

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