Querying Fabric delta tables with Python notebooks and DuckDB

In this video I will dive into Python notebooks and DuckDB. Python notebooks are lightweight code solutions for Microsoft Fabric, they are more efficient than Spark notebooks and therefore they can be cheaper in certain scenarios. However, Spark is very capable of working with Delta tables. Regular Python is not. Enter DuckDB. With this Python package you can interact with Delta tables using a SQL syntax, and it works really well for smaller datasets. This video walks you through that scenario, and shows how to setup DuckDB in Microsoft Fabric.