You can use configurations to help customize your environment. With Amazon Redshift, you can customize and optimize your data warehousing environment by configuring various parameters and settings. The configuration reference outlines the available cluster properties, database parameters, and workload management (WLM) configuration options. You can consult this reference to fine-tune performance, security, and resource allocation based on their specific requirements. The following reference provides detailed guidance on modifying these configurations to achieve your desired data warehousing setup.
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.
