I have a table which has a unique key, but no PK (...
# advice-data-ingestion
r
I have a table which has a unique key, but no PK (I realize it’s effectively the same since both columns are not null). It is difficult for us to add a PK to this table since it’s quite large. I tried to use replica identity on the unique index, but Airbyte doesn’t show an incremental option when I refresh source schema, only full refresh. Is there a way around this? Or do we NEED to add a PK to the table
Copy code
Table "public.test_20220823"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | integer |           | not null |
 b      | integer |           | not null |
Indexes:
    "test_20220823_a_b_key" UNIQUE CONSTRAINT, btree (a, b) REPLICA IDENTITY
Publications:
    "airbyte_publication_2"