Question

Connector running on Postgres RDS Warehouse failing with error :

ERROR: update or delete on table "x" violates foreign key constraint "y" on table "x"

Environment

Destination: PostgreSQL RDS

Answer

Drop the foreign key constraint on the table in the PostgreSQL warehouse. 

Cause

Fivetran doesn't create a Foreign key constraint on the table for Postgres warehouse as it blocks from deleting a record from that table.