Can I Sync Data to or from PostgreSQL with the Citus Extension Enabled?

Question

Does Fivetran support syncing data to or from a PostgreSQL database with the Citus extension enabled?

Environment

Connector or destination: PostgreSQL

Answer

No, we don't support syncing data to or from PostgreSQL databases with the Citus extension enabled.

For PostgreSQL connections, you can configure a Citus-enabled database without seeing an error. However, synced data may be incomplete and contain missing rows.

For PostgreSQL destinations, you can also configure a Citus-enabled database. However, Citus distributed tables must use the same keys for indexing that Fivetran designates as primary keys. If the keys don't match, syncs fail.