Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.
NOTE: You need to allowlist Savant’s IP addresses to let our systems contact your warehouse.
Connecting Savant to Snowflake requires some setup in both platforms. Most of the setup occurs in Savant, but you need access to Redshift for information like your host, port, database name, and credentials.
Requirements
To connect Redshift to Fivetran, you need the following:
Access to the AWS console
A Redshift cluster
Whitelist Savant IPs
Set Up Amazon Redshift in Savant
In Redshift
Collect Amazon Redshift Cluster Properties
Open the Redshift Web Console
In the left menu, click Clusters
Select the cluster you want to connect to with Savant
Click Properties
In the Connection details pane, click Copy to get the endpoint details
Separate the port and remove the preceding colon (:) from the host string
Save the endpoint details for later
Allow Savant to Connect via Security Groups
Allow Savant to Connect via Security Groups
If you have Security setup for Redshift to control the inbound traffic, complete the following steps:
In the Redshift console, click Clusters
Select the cluster you want to connect to with Savant
Click Properties
Scroll down to the Network and security section
In the VPC security group field, click the security group to open it
Save the security group ID
In the Security Groups window, click Inbound rules
The security group you clicked in the previous view should be pre-selected here
Click Edit inbound rules
In the Edit Inbound rules window, create custom TCP rules for each of Savant's IPs in your region:
Select Redshift in the drop-down menu
Enter your Redshift port number (from Redshift properties section above)
Enter the Savant IP address (from Connectivity section above)
Click Add rule
Create a Savant User in Redshift
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
For password authentication, execute the following query to create a user:
CREATE USER savant PASSWORD <password>;
For IAM authentication, we recommend that you create a user without any password and execute the following query:
CREATE USER savant PASSWORD disable;
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; GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO savant;
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 CREATE, TEMPORARY ON DATABASE <database> TO savant;GRANT ALL ON SCHEMA schema_name to savant; GRANT ALL ON ALL TABLES IN SCHEMA schema_name TO savant;
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
In Savant
Enter the Redshift Server name
In the Port field, enter the port number for the corresponding host name
Enter the corresponding Database name
Enter the User name for the Redshift cluster
Enter the Password for the Redshift cluster
Click Authenticate
Read Data from Amazon Redshift
Learn how to create datasets from Savant’s Amazon Redshift connector here.
Write Data to Amazon Redshift
Learn how to write data out to Amazon Redshift using Savant’s Redshift connector here.
Understanding Amazon Redshift’s Limitations
There are no known limitations to Savant’s Amazon Redshift connector.