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
- The user used to access the Redshift must have INSERT privilege for the Amazon Redshift table.
- 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.
- For access to Amazon S3 with the ability to use
COPY
andUNLOAD
, choose either theAmazonS3ReadOnlyAccess
role or theAmazonS3FullAccess
role.
Connecting to Redshift
In order to work with Redshift you will need to create a connection to Amazon Redshift.
Comments
0 comments
Please sign in to leave a comment.