Amazon Redshift User Manual

Amazon Redshift Parameter
Groups
Topics
• Overview (p. 41)
• Managing Parameter Groups Using the Console (p. 43)
• Managing Parameter Groups Using AWS SDK for Java (p. 47)
• Manage Parameter Groups Using Amazon Redshift CLI and API (p. 51)
Overview
When you provision an Amazon Redshift cluster, you associate a parameter group with it.The parameters
in the group apply to all the databases you create on the cluster.The Amazon Redshift engine provides
a default parameter group, which has preset values for the parameters.You cannot change the values
in the default parameter group.The default parameter group is named default.redshift-version.
For example, default.redshift-1.0.
The list of parameters available in a parameter group depends on the parameter group family to which
it belongs. A parameter group family refers to the Amazon Redshift engine version. For example, parameter
group family "redshift-1.0" identifies Amazon Redshift engine version 1.0. Parameter groups in this family
have a specific set of parameters for a specific Amazon Redshift version.The following table lists the
parameters and their values in the default parameter group in the redshift-1.0 parameter group family.
ValueParameter Name
ISO, MDYdatestyle
0extra_float_digits
defaultquery_group
falserequire_ssl
$user, publicsearch_path
API Version 2012-12-01
41
Amazon Redshift Management Guide
Overview

Amazon Redshift Specifications

General

Provider	Amazon Web Services (AWS)
Query Language	SQL
Data Storage	Columnar storage
Security	Encryption at rest and in transit, VPC, IAM
Backup	Automated and manual snapshots
Deployment	Cloud-based
Type	Cloud-based data warehouse service
Primary Use	Data warehousing, analytics
Integration	Integrates with AWS services, BI tools, and ETL tools
Pricing Model	On-demand and reserved instance pricing
Data Compression	Columnar storage with data compression
Performance Optimization	Query optimization