PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Learn more about PosgreSQL.
This sync can be used to request and retrieve data from a user specified datawarehouse to the PostgreSQL.
Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a Redshift Warehouse.
*To understand how to add a Redshift Data Warehouse check out this video.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
3. Configure your Data Destination - Navigate to Destinations tab and select PostgreSQL.
.png)
.svg)
