Skip to main content
All CollectionsSystem Setup Guides
AWS Redshift Connection Setup
AWS Redshift Connection Setup
Updated over a week ago


Savant accesses your Redshift from two IP addresses:



If your network is configured to only allow access from certain IPs, include these in your whitelist.

Redshift Setup

These steps take you through getting the necessarily Redshift information for your Savant connection, and setting up user permissions for Savant in Redshift.

Get the Redshift properties

  1. Open the Redshift console

  2. In the left menu, click Clusters

  3. Select the cluster you want to connect to with Savant

  4. Click Properties

  5. In the Connection details pane, click Copy to get the endpoint details

  6. Separate the port and remove the preceding colon (:) from the host string

  7. Save the endpoint details for later

Allow Savant to Connect

If you have security setup for Redshift to control the inbound traffic, complete the following steps:

  1. In the Redshift console, click Clusters

  2. Select the cluster you want to connect to with Savant

  3. Click Properties

  4. Scroll down to the Network and security section

  5. In the VPC security group field, click the security group to open it

  6. Save the security group ID

  7. In the Security Groups window, click Inbound rules

    1. The security group you clicked in the previous view should be pre-selected here

  8. Click Edit inbound rules

  9. In the Edit Inbound rules window, create custom TCP rules for each of Savant's IPs in your region:

    1. Select Redshift in the drop-down menu

    2. Enter your Redshift port number (from Redshift properties section above)

    3. Enter the Savant IP address (from Connectivity section above)

    4. Click Add rule

Create Redshift User

To connect as a limited user, create a Redshift user for Savant:

  1. Connect to Redshift using a SQL client tool

  2. Create a user based on your authentication type

    1. For password authentication, execute the following query to create a user:

CREATE USER savant PASSWORD <password>;

  1. For IAM authentication, we recommend that you create a user without any password and execute the following query:

CREATE USER savant PASSWORD disable;

  1. Grant the savant user privileges to access all tables in a particular schema by executing the following query:

GRANT USAGE ON SCHEMA schema_name TO savant;


  1. If you plan to use Savant as destination and to create output tables on your behalf, execute the following query to grant the savant user the needed privileges:


GRANT ALL ON SCHEMA schema_name to savant;


  1. CREATE allows the user to create new schemas in the database, and TEMPORARY allows the user to create temporary tables while using the database

  1. Save the limited user’s credentials for later

Getting Started in Savant

Once you’ve completed the steps above, follow these steps in Savant:

  1. Go to the Systems page and click Add System

  2. Select the Redshift connector and click Next

  3. Enter your system information and credentials

    1. Use the info from the Redshift properties section above for server and port

    2. Use the info from the Create Redshift User section above for database, username and password

  4. Click Use SSL

  5. Click Authenticate and then Confirm

You can now create Redshift datasets in Savant!

Did this answer your question?