Can I Use a PostgreSQL-Compatible Extension or Alternative Backend as a Destination?
Question
Can I use a PostgreSQL-compatible extension or alternative backend, such as DuckLake, pg_duckdb, Citus, or CockroachDB, as a PostgreSQL destination?
Environment
Destination: PostgreSQL
Answer
No. Fivetran supports only the PostgreSQL implementations documented for the PostgreSQL destination.
We do not support extensions or alternative backends that use the PostgreSQL wire protocol but implement a different catalog, storage engine, or database behavior. These systems may not support the PostgreSQL DDL operations that Fivetran uses to create and manage destination schemas and tables, which can cause syncs to fail.
If Fivetran provides a dedicated destination for the system you want to use, configure that destination instead. For example: