Using DuckDB with Fabric

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.

Two Modes

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

Local: Prerequisites

DuckDB installed (brew install duckdb on macOS)
Azure CLI authenticated (az login)
Extensions installed: INSTALL delta; INSTALL azure; (one-time)

Local: Querying Delta Tables

Installs

Repository

data-goblin/pow…elopment

GitHub Stars

811

First Seen

Jun 19, 2026

Security Audits

Gen Agent Trust HubPass

SocketPass

SnykFail