DuckLake

Before you start

• The Owner role in Depositori.
• From whoever runs the lake: the catalog (a .ducklake file, or a Postgres database as postgres:dbname=… host=…), the data path (for example az://container/folder) and, for data in Azure, the storage account name.
• A way to sign in. Either your Microsoft account, with access to the catalog database and read access to the storage; or a database login for the catalog, which you store in Depositori.

Add the connection

1. Open Connections and choose Add connection.
2. Set Type to DuckLake and give it a Name.
3. Fill in the catalog, the data path and the storage account. The other two fields are only needed when your lake differs from the default.
4. Under Sign in with, keep your own Microsoft account, or choose Add a login for a database login.
5. Choose Add connection.

Read its tables

On the connection’s card:

1. Test connection checks that the lake can be reached.
2. Import tables and views lists the schemas. Tick the ones you want and choose Import. The tables become a model.

Analyst may query is off. Read The analyst and AI before you turn it on.