Reference

Authentication In-Memory Connection

Description

No description available

Instructions

Query Parquet with DuckDB JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. The wizard downloads DuckDB JDBC 1.4.5.0 (LTS) and the Titanic sample Parquet into C:\ZappySys\Jdbc\DuckDB (Parquet).
  2. This Auth is in-memory (jdbc:duckdb:memory:). After Finish, query the sample with SELECT * FROM "C:\ZappySys\Jdbc\DuckDB (Parquet)\titanic.parquet".
  3. Use the File Auth if you want a persistent .duckdb database instead of memory.
  4. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  5. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Path to the DuckDB JDBC JAR on disk. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\DuckDB (Parquet)\duckdb_jdbc-1.4.5.0.jar
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR (e.g. org.duckdb.DuckDBDriver). 		org.duckdb.DuckDBDriver