Configuration reference - Amazon Redshift
Modifying the server configuration
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).

Configuration reference

Topics

Modifying the server configuration

You can change the server configuration in the following ways:

  • By using a SET command to override a setting for the duration of the current session only.

    For example: 

    set extra_float_digits to 2;

  • By modifying the parameter group settings for the cluster. The parameter group settings include additional parameters that you can configure. For more information, see Amazon Redshift Parameter Groups in the Amazon Redshift Management Guide.

  • By using the ALTER USER command to set a configuration parameter to a new value for all sessions run by the specified user.

    ALTER USER username SET parameter { TO | = } { value | DEFAULT }

Use the SHOW command to view the current parameter settings. Use SHOW ALL to view all the settings that you can configure by using the SET command.

SHOW ALL;

name                      | setting      
--------------------------+--------------
analyze_threshold_percent | 10           
datestyle                 | ISO, MDY     
extra_float_digits        | 2            
query_group               | default      
search_path               | $user, public
statement_timeout         | 0            
timezone                  | UTC            
wlm_query_slot_count      | 1
Note

Note that configuration parameters are applied to the database you are connected to in your data warehouse.