Support Duckdb database (read and write)
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
Comments
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,113 NeuronWell 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?
-
Hello @Turribeach
The JDBC is documented here : https://duckdb.org/docs/api/java.html
Best regards,
Simon -
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,113 Neuron
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.