dbt Cloud is now available for Microsoft Fabric

In a significant development for the data analytics community, dbt Labs has announced that dbt Cloud now extends its support to Microsoft’s latest data platforms – Microsoft Fabric and Azure Synapse Analytics. This expansion is a testament to the growing partnership between dbt Labs and Microsoft and is set to benefit a wide range of data professionals who rely on these platforms.

Enhanced Collaboration and Data Management

The new dbt Cloud adapters for Microsoft data platforms are co-developed by dbt Labs and Microsoft, reinforcing their technology relationship. Already a key player in the Azure ecosystem, dbt Cloud’s capabilities, including support for Snowflake and Databricks on Azure, Azure Active Directory authentication, and integration with Azure Data Factory and Azure DevOps, are now further amplified.

Addressing Data Complexity at Scale

Organizations grappling with growing data complexity will find dbt Cloud’s offerings particularly useful. It simplifies data transformation logic, enabling data teams to scale their operations in line with increasing data sources and demands for data insights. The platform facilitates agile and collaborative development and deployment of analytics code, adhering to the best practices in software development. Importantly, it ensures compatibility across various cloud data platforms, including Microsoft Fabric and other warehouses and lakehouses.

The Unifying Power of Microsoft Fabric

The launch of Microsoft Fabric has been met with enthusiasm from dbt Cloud’s customer base. The platform’s ability to consolidate data from diverse sources into a unified environment, combined with dbt Cloud’s SQL-based approach, promises enhanced data collaboration opportunities within the enterprise. This collaboration potential is crucial in breaking down data silos and accelerating business operations.

Transforming Data into Competitive Advantage

Dbt Cloud’s move towards supporting Microsoft Fabric and Azure Synapse is driven by the substantial demand within the Microsoft community. The integrated Fabric platform is expected to attract organizations using Azure, thanks to its comprehensive solutions for data engineering, data science, and analytics. The collaboration between dbt Labs and Microsoft has been focused on facilitating this integration, ensuring seamless functionality for dbt Cloud on Microsoft Fabric.

To learn more about the integrated adapters, please read the documentation.

Success Stories and Impact

The integration of dbt Cloud has led to significant improvements for various organizations:

  • A major quick-service restaurant franchise saw a 5x increase in delivery times for historical data.
  • A global mass media company saved 16 hours per data integration sprint project.
  • The leading U.S. home solar panel company experienced a 50% reduction in engineering tickets and a 75% acceleration in deployment time.

A Forrester Total Economic Impact report highlights a 194% return on investment over three years for organizations using dbt Cloud.

 

The support for Microsoft Fabric and Azure Synapse Analytics in dbt Cloud marks a significant stride in dbt Labs’ mission. This development not only reinforces the partnership with Microsoft but also provides data practitioners with advanced tools for development, testing, and deployment. With these enhancements, dbt Cloud continues to empower data teams to create and disseminate organizational knowledge more efficiently.

 

For more information on dbt Cloud’s integration with Microsoft Fabric and Azure Synapse Analytics, and to access these features, please visit dbt Cloud’s resources page or sign up for a live demo.

Last Modified on: Nov 16, 2023

Source: dbt

About Author: Florian Grell

 Managing Director