Clickhouse destination sync issue with NULL numerical values

Summary

Records in Clickhouse from last night exist in the final table, but numerical values are NULL. Questioning if others have experienced 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-numerical-values", "lag-column-level-updates"]