Once you've granted access to your Redshift, you'll need to indicate the cluster information for Alooma to connect to.
- Click on the Output node of the Plumbing page
- If not selected, choose the Settings tab
- Fill out the connection information
- The host (endpoint)
- Default schema name (alooma if you followed the optional step during granting access, though you'll be able to choose to map to any other schema we have access to)
- Database name
- Username (alooma if you followed the optional step during granting access)
- Port (the same one you used when creating the cluster, the default is 5439)
You'll find all the needed information (except, of course, the password) in the Cluster Details page in Redshift.
- If your Redshift cluster is behind an SSH server you can connect to Redshift via SSH.
- You can choose not to validate the Redshift settings and save them regardless of their validity by checking the "do not validate" option (not recommended).
- Save the changes.
If your Redshift connection is unsuccessful you will be notified in the notification pane of the Dashboard screen.
That's it! Alooma can now connect to your target Redshift cluster.