Links

PostgreSQL

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

Steps

  1. 1.
    Enable CDC for your source PostgreSQL database.
  2. 2.
    Create a connection to your source PostgreSQL database.
  3. 3.
    Create a connection to your target (see the Supported Targets list below for links).
  4. 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
Replication Job
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
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.

Quickstarts

How To Guides

Reference

Articles

Last modified 27d ago