Using Debezium

Debezium works with Materialize in two capacities:

For the best experience using Debezium, we recommend following the guidelines outlined here.

PostgreSQL settings 

Materialize relies on Debezium’s CDC envelope (which expresses changes to data) to understand all CRUD-like operations happening in the upstream database.

For Debezium to emit the envelope Materialize expects when using PostgreSQL, the tables which you’re performing CDC on must have the parameter REPLICA IDENTITY FULL set.

For example:

ALTER TABLE foo
REPLICA IDENTITY FULL;