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 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 that was published on June 30, 2025.

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

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;