Clickhouse Destination Sync Issue with NULL Values

Summary

User reports an issue with the Clickhouse destination where numerical values are appearing as NULL in the final table despite successful syncs. They are inquiring about potential lag in column-level updates.


Question

We’re using the Clickhouse destination, and things seem to be syncing just fine (running sync every 10min, completing in about 5-6min. incremental-append-deduped). one thing I’m noticing is that there are records in Clickhouse from last night (~12hrs ago) that do exist in the final table, along with most of the data. however it seems that numerical values in particular are all NULL . I assume this may be more of a normalization/clickhouse question but was wondering if anyone else has experienced this lag in column-level updates?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['clickhouse', 'destination', 'sync-issue', 'null-values', 'incremental-append-deduped']