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 …

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 …

This blog post shares my first experience working with Unity Catalog on Azure Databricks. Although it’s been over six months since I completed this proof-of-concept, I wanted to document it before the details faded entirely. While not everything is still fresh in my mind, revisiting the process turned out to be a …

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 …

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 …

Azure Data Factory (ADF) is a cloud-based Extract-Transform-Load (ETL) and data integration service. It allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Through a simple drag-and-drop interface the tool ensures that processes are easy to maintain. In most cases …

APIs are one of the things we often come across when working with data. In this blogpost we’ll have a look at some ways of extracting data out of them with Python in an efficient way. For small amounts of data we could write a simple script that sends one request at a time. For large amounts of data this is no longer a …

Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. This approach keeps data and calculations in a more central repository which acts as a “Single Source of Truth”. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI …

In this post, I’ll walk through how to set up a container that reads a file from an Azure file share and writes the content to a blob container. It’s a relatively simple task, but it’s a great way to highlight the core features of ACI. We’ll use a managed identity to securely access an Azure Key Vault, mount an Azure …

Excel files are used in nearly every workplace and are frequently shared between people. It's not uncommon for passwords to get lost, leaving you locked out of your own files. In this blog post, I'll walk you through the process of regaining access to Excel files protected at the sheet, workbook, or VBA-project level. …