Amazon Redshift User Guide

Owned by Rajeshwari Sajith
May 05, 2024
2 min read

Test Connection

image-20240407-053453.png

 

Note: Test Connection only tests for the database connection and does not verify if s3 bucket is properly configured. To configure please see UNLOAD - Amazon Redshift and COPY - Amazon Redshift

 

Make Sure that redshift has the necessary access to s3 See Authorizing Amazon Redshift to access AWS services on your behalf - Amazon Redshift

 

 

image-20240407-053113.png

 

Make Sure EazyDI is allowed to access redshift by adding EazyDI IP to security group inbound rules and setting publicly accessible to Yes in redshift

 

See : Whitelisting EazyDI for application access

Reading Objects

Format for objects are schema/table

 

 

 

 

 

Using Redshift as source or target

 

 

 

 

When Reading or Saving using S3 for staging, you will notice the assigned s3 bucket with the generated temp directories for COPY or UNLOAD

 

 

 

 

 

 

 

 

Â