Managing database code for a Fabric data warehouse

Putting items in a Fabric workspace in source control is important for being able to deploy changes between workspaces, but what about code within your data warehouse? A warehouse itself is of no use if changes to the table definitions, stored procedures, and views don’t move as well. A Fabric data warehouse is integrated with several industry-standard tools and will be adding more native support for database objects in the future.

Among the ways to interact with and manage database code are the following:

• Data built tool (dbt): This is an open source framework that creates dbt projects that can then be deployed to different Fabric data warehouses
• SqlPackage: This is a command-line utility for automating database deployment tasks, including extraction of schema, scripting schema updates, and publishing project updates to databases
• SQL Database Projects: This extension gives a project-based approach to development...