Thanks Luiggi, I'll reach out to the clickhouse driver devs. I did find a similar question which contained a similar join/conversion but they aren't using clickhouse. https://discourse.metabase.com/t/why-is-floor-and-generated-math-used-as-part-of-a-join/17325/2
The referenced issue doesn't appear related to the issue I'm seeing though (unless I'm misunderstanding it).
Do you mean in metabase Admin or the original clickhouse table? I did try setting it to "Entity Key" type in metabase but that didn't change anything. I haven't tried "Foreign Key" but will try that. In the clickhouse DB, the field being joined is a primary key. I've tried using a different field (not primary key) and seen the same issue so I don't feel like it's specific to this field.