● REDSHIFT

Managing your Connections is easy. Here are the steps:

1. To add a new connection, navigate to the File tab and click on Edit Connections, or press [⌘ + O] | [Ctrl + O].

2. In the dialog box, click the Add icon (➕) next to the Connections header and select Redshift.

3. To finish creating a connection, enter valid data in the fields of the New connection dialog.

• Connection name – Replace the default New Connection with a meaningful value.
• Database JDBC DRIVER – Specify user drivers for the data source, or click the 'download them' link below this field settings area. For detailed instructions on setting up drivers, see Add a user driver to an existing connection.
• Host – Enter the hostname from your Redshift cluster settings.
• Port – The default value is
• SSL Mode – You have several options to set up the SSL mode:

1. Disable – when SSL is disabled, the connection is not encrypted.
2. Prefer – SSL is going to be used if the server supports it.
3. Allow – SSL is going to be used if the server requires it.
4. Require – SSL is always required.

• Authentication – The default value is Standard. You can configure this option with advanced settings.
• User and Password – Enter your Redshift credentials.
• Database – Select the database to connect to in your Redshift cluster.
• Connection timeout (sec) – Specify the value to tell the session when to disconnect.
• Advanced Properties – Supply additional JDBC parameters if needed.

4. Click Test to ensure that the connection to the data source is successful.
5. Click Save. A newly created connection will be displayed in your Database Explore panel just right under the Connections header.

🔎 NOTE:  If you need more advanced information on how to set up a Redshift connection, please, contact us through support@aginity.com

🔎 TIP:  Here is also a link with recommendations from Amazon