Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
SHOW
Displays the current value of a server configuration parameter. This value may be specific to the current session if a SET command is in effect. For a list of configuration parameters, see Configuration reference.
Syntax
SHOW { parameter_name | ALL }
The following statement displays the current value of a session context variable. If the variable doesn't exist, Amazon Redshift throws an error.
SHOW variable_name
Parameters
- parameter_name
-
Displays the current value of the specified parameter.
- ALL
-
Displays the current values of all of the parameters.
- variable_name
-
Displays the current value of the specified variable.
Examples
The following example displays the value for the query_group parameter:
show query_group; query_group unset (1 row)
The following example displays a list of all parameters and their values:
show all; name | setting --------------------+-------------- datestyle | ISO, MDY extra_float_digits | 0 query_group | unset search_path | $user,public statement_timeout | 0
The following example displays the current value of the specified variable.
SHOW app_context.user_id;
