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


  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.


How To Guides



Last modified 27d ago