The ducklake_catalog database must exist in PostgreSQL. DuckLake requires PostgreSQL 12 or newer.
-- Server: open the catalog database file-- (e.g., duckdb metadata.ducklake) and run:INSTALLquack;CALLquack_serve('quack:localhost');-- Client: use the token returned by quack_serveINSTALLducklake;INSTALLquack;CREATESECRET(TYPEquack,TOKEN'your_token',SCOPE'quack:localhost');ATTACH'ducklake:quack:localhost'ASmy_ducklake(DATA_PATH'/path/to/shared/data/');USEmy_ducklake;
Both the catalog database and the clients are DuckDB instances: a DuckDB server process hosts the catalog database and DuckDB clients connect to it over the network using the Quack protocol. The default port is 9494. All clients need access to the data files, so use an absolute path or an object storage URL as the DATA_PATH.