Skip to main content
Version: 1.0.0


Replicate your data in minutes, through our UI or programatically with our APIs.

Replicate your data to Postgres in minutes#

The Katonic Postgres destination connector allows you to sync data to Postgres, without the headache of writing and maintaining ETL scripts.

This Postgres destination is based on the Singer Postgres Target.

Check our detailed documentation on how to start syncing data to Postgres.

Features of the Connector#

Full Refresh SyncYes
Incremental - Append SyncYes

Output schema#

Each stream will be output into its own table in Postgres. Each table will contain 3 columns:

  • ab_id: a uuid assigned by Katonic to each event that is processed. The column type in Postgres is VARCHAR.
  • emitted_at: a timestamp representing when the event was pulled from the data source. The column type in Postgres is TIMESTAMP WITH TIME ZONE.
  • data: a json blob representing with the event data. The column type in BigQuery is JSONB.