Documentation

gitHub

Connect to Amazon Redshift

To access an Amazon Redshift database, you should obtain the proper credentials from your administrator.  In particular you'll need to know your Access Key, Secret Access Key, and the Region for the instance.

 

Cluster instance

Give a meaningful name to the connection:

Redshift connection settings

You also must specify the cluster identifier and database name.

 

 

Then go to the Authentication tab, and paste the Access Key ID received from your administrator, and Secret Access Key for your IAM.  Finally, select the appropriate region where your Redshift cluster is located.

 

Redshift authentication

 

If you wish to handle AWS authentication through the credentials file, you may leave blank the Access Key ID and Secret Access Key fields, knowing that Hackolade supplies credentials following the recommendations described here. or use a temporary session token.

 

 

Serverless

With serverless Redshift; you must specify the workgroup as well as the database name:

Redshift - serverless connection settings

 

Authentication is similar to the cluster instance above.