Using local duckdb

[mattiasthalen]

I'm trying to setup a source that's placed in a duckdb file.
My till project I located in./adventure-works. My duckdb is in ./lakehouse/lakehouse.duckdb.

I've added it as ../lakehouse/lakehouse.duckdb, but I'm getting the error that the catalog lakehouse doesn't exist. But it most definitely does.

[k-anshul]

Hey @mattiasthalen

The duckdb file that rill uses is located in tmp/default/duckdb/ directory so it is not able to find the file. Here are the options you can try.

1. Use absolute path to duckdb file.
2. Keep lakehouse in adventure-works and you can use the path lakehouse/lakehouse.duckdb. Since this path is relative to the adventure-works, rill will automatically identify the absolute path.