Ingesting data from Postgres source to Postgres destination with specific requirements


In this message, the user is asking if it is possible to create a destination table with range partition and use double precision data type instead of numeric to avoid an error while syncing data from a Postgres source to a Postgres destination.


Hi airbyte community, I am new to airbyte OSS, I have a use case to ingest data from postgres source to another postgres destination.
Is it possible to:

  1. Create destination table with range partition.
  2. For newly create pipeline I have to use double precision data type instead of numeric. Because I faced this error from syncing
    ERROR: numeric field overflow Detail: A field with precision 38, scale 9 must round to an absolute value less than 10^29.

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["ingest-data", "postgres-source", "postgres-destination", "range-partition", "double-precision", "numeric-data-type", "sync-error"]