Connecting to DuckDB

Prerequisites

• PuppyGraph can connect to a persistent DuckDB database file. In memory database is not supported.

• Note that DuckDB does not support reading from and writing to by different processes. Therefore, no change can be made to the DuckDB database by another process when PuppyGraph connects to it. See this page to learn more about DuckDB's concurrency handling.

Configuration

Configuration	Explanation
JDBC URI	A JDBC compatible connection URI of the data source. Read this page for more details on how to construct the URI.
JDBC Driver Class	The class name of the JDBC Driver. The default value is org.duckdb.DuckDBDriver
JDBC Driver URL	The URL of the DuckDB JDBC Driver. Please choose the version of the driver that is compatible with your DuckDB database. By default, PuppyGraph uses DuckDB 1.0.0

Demo

See Querying DuckDB Data as a Graph for a complete demo for DuckDB. The demo includes setting up the connection to a DuckDB database file.