EasyManua.ls Logo

Amazon Redshift User Manual

Amazon Redshift
131 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
Page #1 background imageLoading...
Page #1 background image
Amazon Redshift
Management Guide
API Version 2012-12-01

Table of Contents

Question and Answer IconNeed help?

Do you have a question about the Amazon Redshift and is the answer not in the manual?

Amazon Redshift Specifications

General IconGeneral
ProviderAmazon Web Services (AWS)
Query LanguageSQL
Data StorageColumnar storage
SecurityEncryption at rest and in transit, VPC, IAM
BackupAutomated and manual snapshots
DeploymentCloud-based
TypeCloud-based data warehouse service
Primary UseData warehousing, analytics
IntegrationIntegrates with AWS services, BI tools, and ETL tools
Pricing ModelOn-demand and reserved instance pricing
Data CompressionColumnar storage with data compression
Performance OptimizationQuery optimization

Summary

Amazon Redshift Clusters

Managing Clusters Using the Console

Details how to create, modify, delete, reboot, and resize clusters using the AWS Management Console.

Manage Clusters Using Amazon Redshift CLI and API

Managing Clusters in Virtual Private Cloud (VPC)

Creating a Cluster in a VPC

Outlines the general steps to deploy an Amazon Redshift cluster within a VPC, including VPC setup and subnet groups.

Amazon Redshift Cluster Subnet Groups

Managing Cluster Subnet Groups Using the Console

Provides instructions for creating, modifying, and deleting cluster subnet groups via the Amazon Redshift console.

Amazon Redshift Cluster Security Groups

Managing Security Groups Using the Console

Details how to create, modify, delete, and associate security groups with clusters using the console.

Amazon Redshift Parameter Groups

Amazon Redshift Snapshots

Monitoring Amazon Redshift Cluster Performance

Viewing Cluster Performance Data

Guides on how to view cluster metrics, identify performance issues, and analyze query impact.

Viewing Cluster Metrics During Query Execution

Shows how to view cluster metrics during query execution to identify performance bottlenecks.

Viewing Cluster Metrics During Load Operations

Explains how to view cluster metrics during load operations to identify resource-consuming queries.

Purchasing Amazon Redshift Reserved Nodes

Purchasing Reserved Node Offerings

Step-by-step guide to purchasing reserved node offerings through the Amazon Redshift console.

Controlling Access to Amazon Redshift Resources

Connecting to a Cluster

Setting Up the SQL Workbench Client

Provides detailed steps to set up SQL Workbench/J, a query tool, for connecting to Amazon Redshift clusters.

Connect to Your Cluster Programmatically

Connect from Outside of Amazon EC2 - Firewall Timeout Issue

Using the AWS SDKs with Amazon Redshift

Using the AWS SDK for Java with Amazon Redshift

Focuses on using the AWS SDK for Java to interact with Amazon Redshift, including client setup and examples.

Uploading Client-Side Encrypted Data for Use in Amazon Redshift

Signing an HTTP Request

Related product manuals