Savant

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.

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

Select the cluster you want to connect to with Savant

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

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

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

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

In the Redshift console, click Clusters

Scroll down to the Network and security section

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

In the Security Groups window, click Inbound rules

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

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

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

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

Connect to Redshift using a SQL client tool

Create a user based on your authentication type

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

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:

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

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

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

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

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:

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:

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. CREATE allows the user to create new schemas in the database, and TEMPORARY allows the user to create temporary tables while using the database

Save the limited user’s credentials for later

1. Save the limited user’s credentials for later

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

Go to the <a href="https://app.savantlabs.io/en/app/connection" rel="nofollow noopener noreferrer" target="_blank">Systems page</a> and click Add System

Select the Redshift connector and click Next

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

Click Authenticate and then Confirm

1. Go to the <a href="https://app.savantlabs.io/en/app/connection" rel="nofollow noopener noreferrer" target="_blank">Systems page</a> 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

Connectivity

Redshift Setup

Get the Redshift properties

Allow Savant to Connect

Create Redshift User

Getting Started in Savant