Forum Discussion
Microsoft fabric WareHouse migration issue via deployment Pipeline
Does this warehouse reference a lakehouse? If so, this might be a cause of the error. As the Lakehouses are not supported enough be deployment pipelines. To resolve this, you may try two options:
- Manually create the lakehouse in the destination workspace WITH all the tables and views that exist in the source workspace.
- Remove any reference to the lakehouse in the warehouse. (Note: Second option is only needed if for some reason first option is not viable.)
If above options don't work, and the warehouse doesn't reference a lakehouse, please do following steps to try to find more detailed error messages:
1) Export source datawarehouse - click the "Download SQL database project" from within the warehouse editor:
2) Create a new warehouse
3) Import the zip file exported in step 1 INTO DESTINATION FOLDER (this is because the warehouse may be referencing a table in a different artifact that does exist in the source but not the destination):
4) If import fails, it should show the details of the failure. Based on this, you can determine what needs to be fixed for the pipeline to succeed.
If the import is successful, but the deployment pipeline isn't, please open a support ticket to Microsoft to investigate this issue further.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Very good discussion. My question is, when I publish it with "SQL Database Project" in the construction and publishing of schemas, it validates building objects, publishing schemas, importing user queries, and wrapping things up.
Does this show errors of invalid references?
- Broken foreign keys (Foreign Key Violations)
- Orphan records
- Broken data dependencies
- Missing or inconsistent data
I ask this because there is a question related to this discussion.
You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.
You plan to deploy Warehouse1 to a new workspace named Workspace2.
As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.
What should you use?
- A. a database project
- B. a deployment pipeline
- C. a Python script
- D. a T-SQL script