Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, see the
blog post
RESET
Restores the value of a configuration parameter to its default value.
You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the SET command. To display the current value of a parameter, use the SHOW command.
Syntax
RESET { parameter_name | ALL }
The following statement sets the value of a session context variable to NULL.
RESET { variable_name | ALL }
Parameters
- parameter_name
-
Name of the parameter to reset. See Modifying the server configuration for more documentation about parameters.
- ALL
-
Resets all runtime parameters, including all the session context variables.
- variable
-
The name of the variable to reset. If the value to RESET is a session context variable, Amazon Redshift sets it to NULL.
Examples
The following example resets the query_group parameter to its default
value:
reset query_group;
The following example resets all runtime parameters to their default values.
reset all;
The following example resets the context variable.
RESET app_context.user_id;