Fabric Warehouse component Deployment using Azure Repo(DevOps)

Hi marvelbites06, attaching same thread posted earlier for visibility here.

Solved: Fabric Warehouse component Deployment using Azure ... - Microsoft Fabric Community

use download sql project option to download whole project. then checkin this to devops branch, then deploy it to the destination worspace.

Store each table as a separate .sql file in your Azure Repo (e.g., tables/dimCustomer.sql).

Create a YAML pipeline/powershell script to pick the required folders

Run the CI CD pipeline manually for deployment

Please refer to below documentation related to deployments:

Automate deployment pipeline by using Fabric APIs - Microsoft Fabric | Microsoft Learn

Deployment Pipelines - Create Deployment Pipeline - REST API (Core) | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support