Microsoft Fabric Updates Blog

Introducing the dbt adapter for Synapse Data Warehouse in Microsoft Fabric

We are excited to announce the preview of dbt plugin adapter for Synapse Data Warehouse in Microsoft Fabric (preview). This data platform-specific adapter plugin allows you to connect and transform data into Synapse Data Warehouse in Microsoft Fabric.  This is continuing Microsoft’s focus on integration and partnership with dbt Labs. 

We would also like to thank the amazing members of the dbt community who helped build and test the Fabric warehouse and Synapse dedicated SQL pool adapters.

Microsoft Fabric and dbt

This integration allows dbt users to start working with Microsoft Fabric today, complimenting dbt’s existing supported data platforms including Azure Synapse dedicated SQL pools , empowering users to create their own paths to Microsoft Fabric by simply switching target platform.

Microsoft Fabric is a unified analytics platform that brings together all the data and analytics tools that organizations need. Fabric combines the experiences such as Data Engineering, Data Factory, Data Science, Data Warehouse, Real-Time Analytics and Power BI onto a shared SaaS foundation, all seamlessly integrated into a single service. 

dbt (Data Build Tool) is an open-source framework that simplifies data transformation and analytics engineering for your data warehouse.   Over 20k companies are already using dbt today to automate their development practices from; version control, CI/CD, testing, document and transformations.  dbt is database vendor independent allowing a single tool for Data Warehouse development that is able to deploy to many different Data Warehouse platforms by just updating the adapter.

dbt and Fabric together make an amazing partnership, bring all the fundamentals of dbt, developing faster, building reusable blocks, dependency graphs, data dictionaries together with the easy to use SaaS experience and amazing performance of Fabric Warehouse. 

Together the combination of tools creates:

  • An amazing one stop development tool and platform combination
  • Full CI/CD / DevOps integration
  • Full semantic modelling
  • End to End Analytics
  • Open table format using Delta. 

Get Started with dbt and Fabric

To get started with dbt and Microsoft Fabric today,  follow the simple guide on setting up Synapse Data Warehouse in Microsoft Fabric.

To learn how to setup dbt on Azure Synapse dedicated SQL pool, follow this guide Microsoft Azure Synapse dedicated SQL pool setup.

Coming soon

More exciting Fabric developer experiences are coming soon, including: REST APIs,  SQL Project support, git integration and deployment pipelines complementing the existing service principal support.

Visit the fabric community site if you want to submit your own ideas for Microsoft Fabric.

Additional Resources

Fabric dbt Adapter

Fabric Community site

Fabric Blog (RSS Feed)

Fabric YouTube channel

Sign up for the free trial

Fabric trial documentation

Related blog posts

Introducing the dbt adapter for Synapse Data Warehouse in Microsoft Fabric

February 9, 2024 by Ruixin Xu

During January 2024, we announced the worldwide availability for public preview of Copilot in Microsoft Fabric. This preview includes Copilot for Power BI, Data Factory and Data Science & Data Engineering. With the Copilot in preview, Microsoft Fabric brings an improved way to transform, enrich and analyze data, and shortens the time to insights.  Today, we announce that Copilot … Continue reading “Announcing Fabric Copilot pricing “

February 1, 2024 by Kimberly Williams

We are excited to announce that Microsoft Fabric, our all-in-one analytics solution for enterprises, has achieved new certifications for HIPAA and ISO 27017, ISO 27018, ISO 27001, ISO 27701. These certifications demonstrate our commitment to providing the highest level of security and privacy for our customers’ data. What are these certifications and why do they matter? HIPAA (Health Insurance Portability … Continue reading “Microsoft Fabric is now HIPAA compliant”