Support Duckdb database (read and write)

[simon_aubert]

Hello all,

Hello all,

DuckDB is a new project of embeddable database. From what I understand, it's like a SQLite database but for analytics (columnar-vectorized query execution engine on a single file). And of course it's open-source and free.

More info on their website : https://duckdb.org/

Best regards,

Simon

[Turribeach]

Well there is no DuckDB JDBC driver but it has a nice Python API:

https://duckdb.org/docs/api/python/overview

Without a JDBC driver Dataiku couldn't natively support it. The only other option tends to be a plugin but why would you want a plugin since you can use the Python API directly? 

[Turribeach]

Well there is no DuckDB JDBC driver but it has a nice Python API:

https://duckdb.org/docs/api/python/overview

Without a JDBC driver Dataiku couldn't natively support it. The only other option tends to be a plugin but why would you want a plugin since you can use the Python API directly? 

[simon_aubert]

Hello @Turribeach 

The JDBC is documented here : https://duckdb.org/docs/api/java.html

Best regards,

Simon

[simon_aubert]

Hello @Turribeach 

The JDBC is documented here : https://duckdb.org/docs/api/java.html

Best regards,

Simon

[Turribeach]

My bad, didn't see it as they call it "Java" not "JDBC" in the menu yet they use ODBC not .Net. Did you try to create a connection using the JDBC driver? Personally I think using Python will be a much better outcome since this is not a traditional database. 

[Turribeach]

My bad, didn't see it as they call it "Java" not "JDBC" in the menu yet they use ODBC not .Net. Did you try to create a connection using the JDBC driver? Personally I think using Python will be a much better outcome since this is not a traditional database.