No results

    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.




    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.