Geoff Genz

I'd lean toward making this a driver/client setting but then the question becomes what's the default. Most languages have the concept of a "naive" timezone and I'm inclined to say...

We should get to this over the next week or two.

@jesperbagge Do you have an example of how table materializations fail when using dbt 1.2? The basic materializations are working for me and in our automated tests, so I'd like...

Closed with the latest 1.2.1 release

Optimize is by nature an expensive operation, since it most cases it rewrites all of the data in the table. (You can also OPTIMIZE a ReplacingMergeTree table, which is essentially...

I agree it's worth a try. The current approach is "okay" for smaller tables, but I'm not at all surprised that incremental materializations get unusably slow when you get to...

This seems to work just fine with ClickHouse Connect.

Some of this may be solved by using the Replicated database engine. See https://github.com/ClickHouse/ClickHouse/issues/31661. I'll be doing some testing with Replicated databases over the next couple of weeks.

Tests work with with Replicated database engine so explicit support for ReplicatedMergeTree engines will probably not be a priority.

Do you have a list of the affected macros? I've got no experience with `dbt-codegen` -- how hard would it be to validate against the ClickHouse adapter? Can we just...