Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →data-goblin/using-duckdb
Query Fabric lakehouse and warehouse data using DuckDB, either locally or inside a Fabric notebook. Automatically invoke when the user mentions "DuckDB", "query Delta tables locally", or asks to "attach DuckDB to a lakehouse", "query OneLake data", "explore lakehouse data", "data freshness check", "validate data quality", "use DuckDB in Fabric".
Passed 21 of 22 test cases with the skill, and 13 of 22 without it.
and 6 more in the full report
8 fixed13 passed either way1 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 8 test cases the skill fixed. Same model, same prompt, with and without the skill.
What specific log directory path suffix is targeted when scanning OneLake directories to identify Delta table locations?
| Checked | Without skill | With skill |
|---|---|---|
| The response searches for _delta_log/*.json | Missed | Passed |
The instructions your model reads when the skill loads.
Query Delta Lake tables and raw files in OneLake using DuckDB. Works both locally (CLI/Python) and inside Fabric notebooks. Read-only; for writes, use the executing-spark skill.
| Mode | Where it runs | Auth | Best for |
|---|---|---|---|
| Local | Developer machine | Azure CLI (az login) | Exploration, validation, ad-hoc analysis |
| In-notebook | Fabric Spark container | notebookutils.credentials.getToken('storage') | Combining DuckDB speed with Spark write-back |
brew install duckdb on macOS)az login)INSTALL delta; INSTALL azure; (one-time)WS_ID=$(fab get "Workspace.Workspace" -q "id" | tr -d '"')
LH_ID=$(fab get "Workspace.Workspace/LH.Lakehouse" -q "id" | tr -d '"')
duckdb -c "
LOAD delta; LOAD azure;
CREATE SECRET (TYPE azure, PROVIDER credential_chain, CHAIN 'cli');
SELECT * FROM delta_scan(
'abfss://${WS_ID}@onelake.dfs.fabric.microsoft.com/${LH_ID}/Tables/schema/table'
) LIMIT 10;
"
The CHAIN 'cli' parameter uses Azure CLI credentials. Without it, DuckDB tries managed identity first (fails on local machines).
BASE="abfss://${WS_ID}@onelake.dfs.fabric.microsoft.com/${LH_ID}/Files"
test cases passed, vs 13 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.