Python models support

[yoavo-datricks]

Hi, I was wondering if there is a plan to add python models support. We needed to create a model with a recursive CTE and were hoping we could use python since there is no native support for this in clickhouse. Thanks!

[genzgd]

That isn't on the short term roadmap, and I don't have any sense of how complex it will be (since apparently there isn't any high level documentation on Python models). As always pull requests are welcome, and priorities can change based on user interest.

[oleg-savko]

+1 for this functionality, it can bring alot of power for dbt with clickhouse

[genzgd]

From what I can see in the updated DBT documentation, Python models run on the "platform", which in this case would be ClickHouse. At the moment there is no way to hook into any Python like runtime that interacts directly with ClickHouse. (The supported platforms, SnowFlake, DataBricks, and BigQuery already have integrated Python support -- for Snowflake it's in a separate "Public Preview" offering, for DataBricks and BigQuery it's Spark/PySpark). I don't see Python functionality on the roadmap for core ClickHouse any time soon, so I'm closing this. If something like PySpark gets traction in ClickHouse we will revisit the issue.

[genzgd]

Reopening this so we don't get more duplicates.