Getting started with Amazon Redshift

Redshift Overview

Amazon Redshift is a fast, fully-managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

Read more about Amazon Redshift.

Etlworks Integrator fully supports Amazon Redshift.

Configuring Redshift

Configuring the Firewall

Typically, the TCP port 5439 is used to access Amazon Redshift. If Amazon Redshift and Eltworks Integrator are running on different networks, it is important to enable inbound traffic on port 5439.

Learn how to open an Amazon Redshift port for inbound traffic.

Configuring permissions for Redshift

1. The user used to access the Redshift must have INSERT privilege for the Amazon Redshift table.
2. If you are going to be loading data into Redshift from an Amazon S3 bucket, you will need to grant access to S3 for the Redshift user.
3. For access to Amazon S3 with the ability to use COPY and UNLOAD, choose either the AmazonS3ReadOnlyAccess role or the AmazonS3FullAccess role.

Connecting to Redshift

In order to work with Redshift you will need to create a connection to Amazon Redshift.

Working with Redshift

• Extract, transform and load data in Redshift
• Directly load files in Redshift (no transformation)
• ELT with Redshift