--- title: How to Configure Redshift description: Read the article and follow the step-by-step instructions for configuring Redshift with Intentwise Analytics Cloud --- [Skip to content](https://help.intentwise.com/configure-redshift#main-content) ![footer-logo.png\]](https://help.intentwise.com/hs-fs/hubfs/footer-logo.png?width=210&height=40&name=footer-logo.png) Open main navigation Close main navigation Advice and answers from Intentwise - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.intentwise.com/?hsLang=en) 2. [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en) 3. [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline) # How to Configure Redshift ## Learn how to configure Redshift with Intentwise Analytics Cloud by following this step-by-step guide. ### Steps for configuring Redshift with Intentwise Analytics Cloud 1. Create a new database in Redshift. You can pick any name for the database. 2. If your database is behind a firewall, please whitelist the following IP addresses. This is necessary for the Intentwise data pipeline to access your database. - 52.25.90.16 - 34.216.244.114/32 - 52.68.49.96/32 - 52.26.72.39/32 - 52.48.81.207/32 - 54.86.110.101/32 - 52.64.101.124/32 - 52.74.180.132/32 - 18.196.243.206/32 - 35.160.115.182/32 - 35.162.125.75/32 3. Create any new user with the \ in your Redshift database. 4. Create the following new schemas within the database: - amazon\_source\_data - intentwise\_ecommerce\_graph - amazon\_marketing\_cloud (*recommended if you are currently using or intend to use Amazon Marketing Cloud*) - criteo\_source\_data (*recommended if you are currently using or intend to use Criteo*) - instacart\_source\_data (*recommended if you are currently using or intend to use Instacart*) - walmart\_source\_data (*recommended if you are currently using or intend to use Walmart*) 5. Grant read/write permissions for the user created in step #3 by using these queries: - GRANT ALL ON schema amazon\_source\_data TO intentwise\_user; - GRANT ALL ON schema intentwise\_ecommerce\_graph TO intentwise\_user 6. Now, go to the Intentwise platform and navigate to **My Connections** under **Intentwise Analytics Cloud.** Clickon **"+ Add Destination",** choose **Redshift** as the destinationand **click Next.** ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Mar-13-2026-09-02-51-7505-AM.png?width=2856&height=1344&name=image-png-Mar-13-2026-09-02-51-7505-AM.png) 7. And enter the **Host**, **Port**, **Database**, **User**, and **Password** details and **Save.** ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Mar-13-2026-09-03-26-4073-AM.png?width=2856&height=1344&name=image-png-Mar-13-2026-09-03-26-4073-AM.png) 8. On completion, you will see a success message. 9. For any further questions on the pipeline setup, please contact us on *chat* or at help@intentwise.com. - [Getting started](https://help.intentwise.com/getting-started?hsLang=en) - [Intentwise AI Gateway](https://help.intentwise.com/intentwise-ai-gateway?hsLang=en) - [Intentwise Ad Optimizer](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#main-content) - [Account and Campaign Setup](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#account-and-campaign-setup) - [Optimization](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#optimization) - [Reporting](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#reporting) - [Dashboard Overview](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#dashboard-overview) - [Resources](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#resources) - [Amazon DSP](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#amazon-dsp) - [Additional Features](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#additional-features) - [Walmart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#walmart) - [Criteo](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#criteo) - [Instacart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#instacart) - [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#main-content) - [AMC](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#amc) - [Instructional Queries](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries) - [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#main-content) - [Kickstart Guide](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#kickstart-guide) - [Configuring Reporting Tools](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-reporting-tools) - [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline) - [Data Sources](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#data-sources) - [Looker (Google Data) Studio Tutorials](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#looker-google-data-studio-tutorials) - [Intentwise Templates](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-templates) - [Intentwise Analytics Cloud features](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-analytics-cloud-features) - [White Label](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#white-label) - [Intentwise Marketplace Intelligence](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#main-content) - [Content Analytics (CA)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#content-analytics-ca) - [Share Of Voice (SOV)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#share-of-voice-sov) - [Frequently Asked Questions (FAQs)](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#main-content) - [Access and Setup](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#access-and-setup) - [Billing](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#billing) - [Platform](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#platform) - [Reporting](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#reporting) intentwise.com Help Center Copyright © 2026, Intentwise Inc.