PostgreSQL

Supported Ingestion Methods
Full
Incremental
It is highly recommended that a non-clustered, non-unique index on the column used for incremental queries
Change Data Capture (CDC)
For more information on ingestion methods, click here.
Enable Change Data Capture (CDC)
Configure server-level settings
1.Set wal_level = logical
2.Set max_replication_slots = # (any number greater than 1, usually at least 10).
Create a dedicated replication slot
SELECT pg_create_logical_replication_slot('verb_replication_slot', 'test_decoding');
Grant permissions to user
ALTER USER <user> WITH REPLICATION;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <user>;

Microsoft SQL Server

MongoDB

Last modified 2yr ago