Earlier quoted context omitted.
Oh wow, I missed that. I guess I heard about the CTE somewhere and understood dbt-clickhouse not having ephemeral materialization as CH still not supporting it. I am still somewhat salty about not being able to do GROUP BY 1, 2, 3 :) > You are right that ClickHouse requires attention and skills to get the best performance. However, that includes fixed, low-latency use cases like real-time marketing that Snowflake sim…
> GROUP BY 1, 2, 3 It is not ANSI SQL. Nevertheless, it is already available in ClickHouse as well under `enable_positional_arguments` setting and we are considering making it enabled by default.
Is there a way to turn unquoted column and table names case insensitive too? Thats like the second biggest annoyance.