Microsoft Fabric

Configure dbt with MS Fabric in VS Code with the dbt Power User extension

Lately, I’ve been setting up dbt Cloud to work with Microsoft Fabric. We started out using dbt’s browser-based IDE, but as our number of models grew, I began to miss Visual Studio Code. First, a quick distinction: dbt Core is the open-source command-line tool for local development, while dbt Cloud is the managed …

Automating File Transfers to Microsoft Fabric with PowerShell and AzCopy

Last year, I shared my experience with managing files in OneLake using the Python SDK, where I explored how to programmatically interact with Microsoft Fabric’s data lake capabilities. Recently, I revisited a similar challenge — but this time, I approached it from a different angle. Instead of Python, I used PowerShell …

Fabric and dbt Cloud - First Impressions

I recently had the chance to work on a proof of concept combining dbt Cloud with Microsoft Fabric. It was a great opportunity to explore how well these two platforms work together. In this blog post, I'll share my first impressions. What I really liked Data Tests Unit Testing Integration Testing Data Health Tiles Two …

Managing files in a Fabric Lakehouse using the Python Azure SDK

In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding experience is required and yet you can create very interesting automations this way. I started testing this approach when I was creating a proof-of-concept. I was working on a virtual machine …