New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[UI] Allow selecting PG tables without primary keys in CDC mirrors when initial_copy_only = True #1628

Open

fh-dtatarkin opened this issue Apr 18, 2024 · 1 comment

fh-dtatarkin commented Apr 18, 2024 •

edited

PeerDB UI currently doesn't allow creating CDC mirrors on tables without primary keys.
Today it's possible to setup such mirrors via SQL only (see SQL example below)

SQL CDC Mirror example that works:

CREATE MIRROR my_cdc_mirror
FROM ldc_dev TO snowflake-dev
WITH TABLE MAPPING
(
  my_schema.my_table:my_schema.my_table
)
WITH (
  do_initial_copy = true,
  initial_copy_only = true,
  snapshot_sync_mode='avro',
  snapshot_num_rows_per_partition = 50000,
  snapshot_max_parallel_workers = 5,
  snapshot_num_tables_in_parallel = 1
);

Screenshot (see the error underlined in red):

Collaborator

saisrirampur commented Apr 18, 2024

cc @Amogh-Bharadwaj

Amogh-Bharadwaj mentioned this issue

UI: do not disable tables if initial copy only #1629

Closed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment