Geoff Genz

This appears to be fixed by #230 without the need to drop and recreate the distributed tables, but I could see it being reopened. Unfortunately we don't currently have the...

That is standard behavior for dbt parameters. You could call additional macros to initialize your parameter following the workaround described here, https://stackoverflow.com/questions/73363627/pass-a-macro-as-a-parameter-jinja-dbt, but that's a pretty ugly solution. For your...

Okay, I understand -- can you use a CTE in the query and have the predicate reference the CTE alias?

No, that probably won't work either because the DELETE does have any access to the CTE. This could probably be implemented in the macro to evaluate the incremental_predicate expression before...

There have been some important updates to lightweight deletes since that issue was filed (although they are still experimental). Performance *should* be better, but any feedback we get from dbt...

I had no idea this was possible (since it's not mentioned in the ClickHouse docs.). I think it's probably reasonable, but there are some tradeoffs -- sending everything as a...

I agree with you philosophically about bloating the URL -- some time back we moved the query itself into the POST body for exactly that reason. I'm just not thrilled...

Polars is not currently on the roadmap, but we do look at the community interest in new features on a regular basis and adjust our priorities accordingly. Of course we'd...

Feedback based on @NotSimone's comment would be appreciated -- is using PyArrow enough of a solution or does Polars use some other internal data format?

Agreed that PyArrow DataFrames would be useful - https://github.com/ClickHouse/clickhouse-connect/issues/326. However I'm not sure when it will it will be prioritized.