I have a connection set up between 2 postgres data...
# ask-ai
j
I have a connection set up between 2 postgres databases. The source is configured to use CDC replication. The tables in the stream are configured to use
incremental_deduped_history
. When the sync runs, it does a full refresh every time instead of processing the incremental changes. Airbyte version: 1.1.0 Postgres Source Version: 3.6.22 Postgres Destination Version: 2.4.0 Poatgres config:
Copy code
CREATE ROLE source_1_airbyte_role;
ALTER ROLE source_1_airbyte_role REPLICATION LOGIN;
GRANT SELECT ON TABLE public.table_1 TO source_1_airbyte_role;
ALTER TABLE public.table_1 REPLICA IDENTITY DEFAULT;