Amazon Redshift User Guide

By Rajeshwari Sajith
2 min

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 https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html and https://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html

 

Make Sure that redshift has the necessary access to s3 See https://docs.aws.amazon.com/redshift/latest/mgmt/authorizing-redshift-service.html

 

 

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

 

image-20240407-053433.png
image-20240407-053707.png

See : Whitelisting EazyDI for application access

Reading Objects

Format for objects are schema/table

 

image-20240407-053829.png

 

 

image-20240407-053921.png

 

 

Using Redshift as source or target

 

 

 

image-20240407-054429.png

 

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

 

 

image-20240407-054125.png

 

 

 

 

image-20240407-054231.png

 

image-20240407-054343.png

 

image-20240407-054529.png

 

Related content