Configuration reference
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
- analyze_threshold_percent
- cast_super_null_on_error
- datashare_break_glass_session_var
- datestyle
- default_geometry_encoding
- describe_field_name_in_uppercase
- downcase_delimited_identifier
- enable_case_sensitive_identifier
- enable_case_sensitive_super_attribute
- enable_numeric_rounding
- enable_result_cache_for_session
- enable_vacuum_boost
- error_on_nondeterministic_update
- extra_float_digits
- interval_forbid_composite_literals
- json_serialization_enable
- json_serialization_parse_nested_strings
- max_concurrency_scaling_clusters
- max_cursor_result_set_size
- mv_enable_aqmv_for_session
- navigate_super_null_on_error
- parse_super_null_on_error
- pg_federation_repeatable_read
- query_group
- search_path
- spectrum_enable_pseudo_columns
- enable_spectrum_oid
- spectrum_query_maxerror
- statement_timeout
- stored_proc_log_min_messages
- timezone
- use_fips_ssl
- wlm_query_slot_count
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.
