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?

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.