DuckDB Connection Help
RazorSQL provides a "Auto Install" button on the DuckDB Add Connection Profile screen that will download the DuckDB JDBC driver to the user's machine. If using RazorSQL for Mac, this driver is required as the driver Jar file contains code-signed binary files signed specifically for RazorSQL. Drivers downloaded directly from DuckDB will not work in RazorSQL as the binaries are not signed for RazorSQL. If using Windows or Linux, users can manually set up and configure a JDBC connection without using the RazorSQL auto installed driver.
Connecting to DuckDB via JDBC
To connect to DuckDB using the DuckDB JDBC driver, the following information
is required:
Connection Profile Name: This is the name of the connection
and will be displayed in the connection wizard screen.
Driver Location: This is the location of the DuckDB JDBC driver
jar file. If you clicked the Auto Install button, this location will be pre-populated.
Note: Auto Install is required for Mac connections. If using Windows or Linux,
you can browse to the DuckDB JDBC jar file if not using the auto install option.
Driver Class: org.duckdb.DuckDBDriver
Database File: Browse to the a database file. If the file does not yet
exist, a new, empty DuckDB database will be created. If the file does exist, a connection attempt will be made
to the file.
