PostgreSQL

Learn the steps for ingesting your PostgreSQL data into your target.

Steps

1. Enable CDC for your source PostgreSQL database.
2. Create a connection to your source PostgreSQL database.

3. Create a connection to your target (see the Supported Targets list below for links).

4. Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift Amazon S3 AWS Glue Data Catalog ClickHouse Elasticsearch Polaris Catalog Snowflake
Replication Job Create a replication job to ingest into multiple target schemas	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake
Single Entity Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a single entity job that auto-creates a sub-job for each source table to copy data to the target table	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake

No-code Wizard

Alternatively, you can use the Upsolver no-code Wizard to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.

---

Related Content

Quickstarts

• Create a PostgreSQL Connection
• Ingest CDC Data from Your PostgreSQL Database

How To Guides

• Create and Maintain Connections to Your PostgreSQL Database
• Enable CDC on Your PostgreSQL Database
• Replicate CDC Data to Multiple Schema Targets in Snowflake
• Replicate CDC Data into Snowflake

Reference

• Connection Options for PostgreSQL

• Ingestion Job Options for PostgreSQL

• Replication Job Options for PostgreSQL

Articles

• Ingest Data Using CDC
• Performing Snapshots
• PostgreSQL Partitioned Tables