peerdb icon indicating copy to clipboard operation
peerdb copied to clipboard

Clickhouse: check if existing tables have compatible schema

Open Amogh-Bharadwaj opened this issue 7 months ago • 1 comments

During SetupFlow and ValidateMirror in PG to Clickhouse CDC, if a target table exists already, check if the columns have compatible data types. Essentially we should be able to insert rows into the table based on source schema target schema data type mapping. Deviations like Nullable(type) instead of type and uint64 instead of int64 should be tolerated

Amogh-Bharadwaj avatar Jul 18 '24 15:07 Amogh-Bharadwaj