Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hello everyone, I'm trying to launch a task through the prefect with a call to clickhouse, I did not find the library of the prefect's tasks. Can anyone who has done a similar task, please share the solution, thanks

clickhouse_driver.errors.SocketTimeoutError: Code: 209. (<http://xxx.xxx.xxx.xxx:xxxxx|xxx.xxx.xxx.xxx:xxxxx>)

```from clickhouse_driver import Client, dbapi
client = Client(Host_name,
                port=Host_port,
                user=User_db,
                password=Pass_db,
                secure=False,
                verify=False,
                database=DB_name,
                compression=True)
result = client.execute('SELECT now(), version()')```


We don't have a Clickhouse task integration yet, but if you want to contribute, check out <https://discourse.prefect.io/t/how-to-contribute-to-prefect/352/2|this guide> and we are happy to review your PR.

Also, for Clickhouse questions, they also have a Slack channel, maybe you can ask there <https://clickhousedb.slack.com/>

Regarding your error, you may wanna <https://github.com/mymarilyn/clickhouse-driver/issues/84|try using port 9000 instead>

also: <https://stackoverflow.com/questions/57778609/issue-connecting-to-dockerized-clickhouse-server-with-python-driver>