Category Archives: Fabric

Microsoft Fabric is an advanced data platform designed for efficient management, integration, and analysis of enterprise data. It enables the centralization of data from various sources, ensures data quality, and makes it accessible for both analytical and operational purposes.

Fabric provides multiple data components within a single solution – including a data lakehouse, data warehouse, ETL/ELT processing tools, metadata management, data cataloging, access control, and support for building data models and analytical workspace environments. Functions included:

  • Data pipelines and dataflows for ELT orchestrations
  • Notebooks (PySpark, SparkR, SparkSQL, Python)
  • Data lakehouses
  • Dara warehouses
  • SQL Databases – something like Azure SQL
  • Native support for all Azure resources within the same tenant using managed identity (Storage, ADF, Container apps,..)
  • and more

Latest posts from the category:

Fabric – Azure Service Principal (SPN) and RBAC for dbt in Entra ID

To utilize Azure Service Principal authentication, it is necessary to first create an application and its credentials Entra ID (formerly Azure Active Directory). This authentication method will subsequently be required for us to correctly configure the profiles.yml file for connecting to Fabric, which is covered in the article – Fabric | dbt – Configuration profiles.yml for… Read More »

Fabric | Fabric Pricing – Models, Tiers, Recommendations

Microsoft Fabric is a robust cloud data platform that combines tools for data storage, management, analytics, and machine learning in a unified environment. The Fabric platform and pricing are designed to meet a wide range of organizational needs – from small teams to large enterprise solutions. This article provides an overview of pricing models, a… Read More »

Fabric | dbt – Configuration profiles.yml for SPN Authentization to SQL Endpoint

This article describes the process for configuring the profiles.yml file within the dbt tool to be able to properly connect to the Microsoft Fabric SQL Endpoint using Service Principal (SPN) authentication (we covered SPN in article Fabric | dbt – Azure Service Principal (SPN) and RBAC for dbt in Entra ID). The goal is to… Read More »

Fabric | dbt – Docker dbt and Azure Container Apps (CI/CD)

For the cloud-based Warehouse built on top of MS Fabric, we already have a prepared Lakehouse and DWH environment and, among other things, a configured dbt project. Now comes an important DataOps phase: we need to think about From which environment (ideally serverless) we will batch-run the dbt project in the future. How to implement… Read More »

Fabric | dbt – Creating a Fabric Lakehouse/Data Warehouse and Configuration

Microsoft Fabric is a unified data platform that connects various artifacts for developing data solutions, analytics, and BI in a single integrated environment. One of its key components is the Fabric Lakehouse, which combines the advantages of: Data Lake – scalability, low storage cost Data Warehouse – structured approach, SQL queries support This article describes… Read More »

Fabric | dbt – Architecture and the Role of dbt in the Medallion Architecture

Microsoft Fabric represents a unified SaaS platform that integrates components of the so-called modern data warehouse. Within a single platform, it is possible to handle storage through artifacts (Lakehouse/DWH), computing resources (Spark/Polaris), and tools for data flow orchestration. The Fabric architecture also provides tools for the transformation layer (e.g., Spark), which can be written and… Read More »