--- title: How to Configure PostgreSQL description: Read the article and follow the step-by-step instructions for configuring PostgreSQL with Intentwise Analytics Cloud --- [Skip to content](https://help.intentwise.com/steps-for-configuring-postgresql#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 PostgreSQL ## Learn how to configure PostgresSQL with Intentwise Analytics Cloud by following this step-by-step guide. ### Steps for configuring PostgreSQL To configure PostgreSQL with Intentwise Analytics Cloud, follow these steps:   1. Create a new database in the Postgres cluster. You can pick any name for the database. 2. If your database is behind the firewall, whitelist the following IP addresses. This is required 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 Postgres 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 amazon\_source\_data TO intentwise\_user; - GRANT ALL ON 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 **PostgreSQL** as the destinationand **click Next.** ![](https://help.intentwise.com/hs-fs/hubfs/image-png-Mar-13-2026-09-20-22-0445-AM.png?width=2858&height=1346&name=image-png-Mar-13-2026-09-20-22-0445-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-20-59-8481-AM.png?width=2862&height=1348&name=image-png-Mar-13-2026-09-20-59-8481-AM.png)** 8. On completion, you will see a success message. 9. For any further questions on the pipeline setup, please reach out to us on *chat* or at [help@intentwise.com](mailto: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.