Only an admin can set up the Redshift integration.
Connecting Soal to your Redshift instance allows users to run sql queries in notebooks and allows Soal to suggest queries using AI.

​
Step 1. Create the warehouse connection

  • Log in to your Redshift data warehouse at http://console.aws.amazon.com/redshiftv2/home
  • Create a user with read permissions to the schema and tables that you want to connect from.
  • If data will be written back to the warehouse from Soal, add a schema and permissions to allow the Push.ai user to write to a specific schema.

​
Step 2. Whitelist Soal’s IP Addresses

Soal will connect to your database from the following IP addresses. Please make sure to allow traffic from these IPs:
  • 00.000.000.000

​
Step 3. Configure the connection in Soal

  • Add the Host, Port, Database, Username, Password
  • Click Test Redshift to confirm the connection settings.
  • Click Connect Redshift to complete the connection.