You add rules to the security group to grant explicit inbound access to a specific range of CIDR/IP
addresses or to an Amazon Elastic compute Cloud (EC2) security group if your SQL client is running on
an EC2 instance. For more information, see Amazon Redshift Cluster Security Groups (p. 32).
Create and manage parameter groups – When you create an Amazon Redshift cluster, you associate
a parameter group with it.The parameters in this group, such as the date presentation style and floating
point precision, apply to all the databases that you create on the cluster. There is a default parameter
group for the Amazon Redshift engine that defines preset values for the parameters. If your application
requires different settings, you can create your own parameter group. For more information, see Amazon
Redshift Parameter Groups (p. 41).
Manage snapshots – Amazon Redshift continuously backs up your data to an Amazon Simple Storage
Service (S3) bucket to help protect against data loss.You also have the option to create your own
point-in-time backups of your cluster.These automated and manual backups are called snapshots.You
can restore a cluster to its state when you took the snapshot. Amazon Redshift supports both automated
and manual snapshots. For more information, see Amazon Redshift Snapshots (p. 52)
Monitor cluster performance – Amazon Redshift collects metrics that you can use to track the health
and performance of your clusters and queries.You can set up alarms that notify you when one or more
metrics are outside an acceptable range.You can use the Amazon Redshift console to directly access
the most common cluster performance metrics and to look at the resource utilization of individual queries.
You can also view cluster performance metrics by using Amazon CloudWatch. For more information, see
Monitoring Amazon Redshift Cluster Performance (p. 67).
Control access to your Amazon Redshift resources – The AWS account that creates the cluster has
full access to the cluster.Within your AWS account, you can use the AWS Identity and Access Management
(IAM) service to create user accounts and manage permissions for those accounts. By using IAM, you
can grant different users permission to perform only the cluster operations that are necessary for their
work. IAM controls only access to the Amazon Redshift API; it does not control access to the cluster via
JDBC and ODBC. For more information, see Controlling Access to Amazon Redshift Resources (p. 90).
Are You a First-Time Amazon Redshift User?
If you are a first-time user of Amazon Redshift, we recommend that you begin by reading the following
sections:
• Service Highlights and Pricing – The product detail page provides the Amazon Redshift value
proposition, service highlights, and pricing.
• Getting Started – The Getting Started Guide includes an example that walks you through the process
of creating a cluster, creating database tables, uploading data, and testing queries.
After you complete the Getting Started guide, we recommend that you explore one of the following guides:
• Amazon Redshift Cluster Management Guide (this document) – This guide shows you how to
create and manage Amazon Redshift clusters. For more information, see the following Cluster
Management Overview (p. 1) section.
If you are an application developer, you can use the Amazon Redshift Query API to manage clusters
programmatically. Additionally, the AWS SDK libraries that wrap the underlying Amazon Redshift API
simplify your programming tasks. If you prefer a more interactive way of managing clusters, you can
use the Amazon Redshift console and the AWS command line interface (AWS CLI). For information
about the API and CLI, go to the following manuals :
• API Reference
• CLI Reference
API Version 2012-12-01
2
Amazon Redshift Management Guide
Are You a First-Time Amazon Redshift User?
To Next Page
Loading...
Need help?
General
