Can DataIku connect to clickhouse ?

Solved!
Steph
Level 1
Can DataIku connect to clickhouse ?
Hi,

Can DataIku connect to Clickhouse database, if no is it in the roadmap ?

Best Regards,

Stephane.
0 Kudos
1 Solution
apichery
Dataiker

Hi Stephane,



Dataiku can connect to Clickhouse as a generic Database but does not support this Database as Clickhouse features a specific SQL language.



So while, you might be able to read/write data from this database, you will have to rely mainly on handwritten queries (SQL queries recipes) and accept some poor performance on large tables as DSS will connect to Clickhouse over an HTTP connection (unlike clickhouse-client).



Here is what I did to connect to Clickhouse:



- Download Clickhouse JDBC driver (https://github.com/yandex/clickhouse-jdbc) from maven:



http://central.maven.org/maven2/ru/yandex/clickhouse/clickhouse-jdbc/0.1.53/clickhouse-jdbc-0.1.53-s...



- Copy the file into <DSS HOME>/lib/jdbc



- Restart DSS



- Create a new connection of type "Other SQL Database" and fill Basic params section 



- JDBC driver class: ru.yandex.clickhouse.ClickHouseDriver



- JDBC URL: jdbc:clickhouse://<host>:<port>[/<database>] (in my case: jdbc:clickhouse://localhost:8123)



Hope this helps,

Arnaud - Dataiku



 



 

View solution in original post

2 Replies
apichery
Dataiker

Hi Stephane,



Dataiku can connect to Clickhouse as a generic Database but does not support this Database as Clickhouse features a specific SQL language.



So while, you might be able to read/write data from this database, you will have to rely mainly on handwritten queries (SQL queries recipes) and accept some poor performance on large tables as DSS will connect to Clickhouse over an HTTP connection (unlike clickhouse-client).



Here is what I did to connect to Clickhouse:



- Download Clickhouse JDBC driver (https://github.com/yandex/clickhouse-jdbc) from maven:



http://central.maven.org/maven2/ru/yandex/clickhouse/clickhouse-jdbc/0.1.53/clickhouse-jdbc-0.1.53-s...



- Copy the file into <DSS HOME>/lib/jdbc



- Restart DSS



- Create a new connection of type "Other SQL Database" and fill Basic params section 



- JDBC driver class: ru.yandex.clickhouse.ClickHouseDriver



- JDBC URL: jdbc:clickhouse://<host>:<port>[/<database>] (in my case: jdbc:clickhouse://localhost:8123)



Hope this helps,

Arnaud - Dataiku



 



 

Andrey_Lipsky
Level 1

I had same issue "how to connect to ClickHouse", thanks for manual how to do that, but.. 

Screen Shot 2020-05-14 at 1.12.59 PM.png

Is there any chance to try on community edition jdbc dataset? Thanks

0 Kudos

Labels

?
Labels (1)
A banner prompting to get Dataiku