The Amazon Redshift integration lets you pull your Client's data warehouse directly into AgencyAnalytics reporting. You can query your data with SQL to retrieve specific dimensions, metrics, and date ranges, then customize how the data is displayed and updated to match your Client's exact reporting needs.

To connect Amazon Redshift, you'll need to know the following account details:

Step 1: Open the Client where you'd like to connect Amazon Redshift, then click the Data Sources tab at the top.

Step 2: Click the blue + Connect source button in the upper-right corner of the page.

Step 3: Search for Amazon Redshift in the upper-right search box, then click the Amazon Redshift card.

Step 4: Click the Connect New Account button.

Step 5: In the next window, enter the Amazon Redshift Host, Port, User, Password, and Database for the account you want to connect to, then click Save in the bottom-left corner to verify and finalize the connection.

Once saved, Amazon Redshift will be successfully connected! You can start adding Redshift widgets to dashboards and reports and querying data right away.

Add the following IP addresses to your Amazon Redshift allowlist:

Once those IP addresses are allowlisted, try connecting again.

If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄