From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Utilizing database projects for warehouse

Utilizing database projects for warehouse - Microsoft Fabric Tutorial

From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Utilizing database projects for warehouse

“

utilizing database projects for the warehouse. Now, database projects allow us to use a familiar database projects structure to manage objects such as the tables, the views, the store procedures in a project that we can version control. But more importantly, we can build that project and it'll produce a DACPAC file. Now this DACPAC file contains the schema information for our tables, our views, but also the definitions for our stored procedures, all in that single deployable file. We can start a database project in a number of ways. We can actually download from Fabric Warehouse into an empty project, but we can also start it from Azure Data Studio, although Azure Data Studio is soon to be retired, or Visual Studio Code. We can start a project and then deploy that to the Fabric Warehouse. Now, within our project, yes, we can have tables and views and stored procedures. We can structure that in our folders. We can also use custom scripts, pre-deploy scripts, for example. And we can use…

Contents