When we start implementing a data lake using Microsoft Fabric, we might be tempted to start creating pipelines and notebooks right away, without thinking about design principles. However, there’s one design principle I’d like you to consider from the beginning: DRY. DRY is an acronym that stands for Don’t Repeat Yourself. In this blog post, …
I had the pleasure of speaking at Data Saturday in Parma, Italy, a very nice event that brought together lots of enthusiastic, mostly Italian, data professionals. My session, titled ‘Don’t Repeat Yourself – how custom Python modules give back hours of your time’, focused on the software engineering principle of DRY, that can be brought …
Yesterday, I had the pleasure of speaking at Cloud Data Driven, a free data and analytics user group with weekly online meetings. It brought together interested data professionals from all over the world. My session, titled ‘Don’t Repeat Yourself – how custom Python modules give back hours of your time’, focused on the software engineering …
Coming from the ‘old school’ world of SSIS and SQL Server, and later Azure Data Factory and Azure SQL Database, I have always built my ETL orchestration processes using some kind of pipelines. In Fabric, we also have pipelines (the successor of ADF), but, we can now also create notebook orchestration using NotebookUtils and runMultiple(). …
In Microsoft Fabric data engineering, we use Spark to apply transformations to our data. Just like you would write T-SQL to transform data in SQL Server, you would write PySpark or SparkSQL to transform data in a Fabric lakehouse. There are a lot of parallels between Spark en SQL in the way you can process …
Introduction In this guide, we’ll dive straight into the practical steps of how to implement Medallion Lakehouses using Microsoft Fabric. If you’re unfamiliar with the Medallion Architecture, or need a refresher, check out our previous post on the theory behind the Medallion Architecture. This post focuses on hands-on implementation, guiding you through each step of …
The medallion architecture is maybe the most important concept to grasp when you start building lakehouse solutions on Microsoft Fabric. Data products should never be built ‘right away’ or on their own. There’s a structure and process to follow. Luckily, we don’t have to figure out that structure by ourselves. Rather, I’d suggest using what …
Last week, I had the pleasure of speaking at DATA:SCOTLAND, a free data and analytics conference in Glasgow that brought together nearly a thousand data enthusiasts. My session, titled ‘Your first Microsoft Fabric Lakehouse implementation’, focused on practical tips for setting up lakehouses using Microsoft Fabric. Despite being relatively new to public speaking, I enjoyed …
Yesterday, I was thrilled to deliver my first public speaking session in years! I was invited by the friendly people of the Dutch Fabric User Group to present my story to a group of about 35 people interested in Microsoft Fabric.. My session, titled ‘Fabric Lakehouses for SQL Data Engineers’, was focused on helping data …