22-25 April 2026

Terraforming Microsoft Fabric: Best Practices, Limitations, and Ways Forward

Proposed session for SQLBits 2026

TL; DR

This session explores Terraform-based automation for Microsoft Fabric, focusing on patterns, governance, and current provider limitations. Learn how to work around gaps using reusable modules, and community tooling, and how to reproduce or migrate environments in a maintainable way.

Session Details

When managing data platform architectures you want reliable automation and using Microsoft Fabric that is no exception. Often for different platforms you run into questions around patterns, possible tooling gaps, and governance. In this session, we’ll focus on Terraform-based automation for Fabric in a way that fits into practical platform operations and addresses common hurdles.
We’ll cover recommended approaches for organizing Terraform configurations, how to codify and validate standards and conventions, and where the current provider’s limitations require alternative strategies. Rather than avoiding those limitations, we’ll talk about how to work with them — by building re-usable custom Terraform modules when necessary, and by incorporating community tooling such as the PowerShell FabricTools module to handle operations that aren’t or might never be supported.
We’ll also discuss approaches for tasks like reproducing or migrating an existing environments in a way that aligns with automation goals. Attendees will gain a framework for thinking about Fabric automation in a way that scales, stays maintainable, and aligns with broader data platform practices, even where existing tooling doesn’t yet cover every need.

3 things you'll get out of this session

A clear understanding of recommended patterns for automating Microsoft Fabric with Terraform Insight into current provider limitations and practical ways to work around them A toolbox of techniques for governance, validation, and environment replication or migration