DWH View referencing Lakehouse object is not resolved while DWH deployment through DevOps pipeline
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
- SqlPackage or DacFx Version: SqlPackage version: 170.3.93.6
- .NET Framework (Windows-only) or .NET Core: 10.0.102
- Environment (local platform and source/target platforms):
**Steps to Reproduce:**
1. Extract SQL Project from Fabric DWH in VS code (synched to GIT repo)
2. Update the DWH SQL Project file to include Lakehouse SQL endpoint reference
3. Update Project file for Microsoft.Build.Sql to use version 2.0.0
4. Build the project in Azure devOps CI pipeline and generate Dacpac
5. Deploy the dacpac to higher env DWH using devOps release pipeline using Azure SQL Database deployment task
6. Release fails with error on the view containing lakehouse reference
But publish project from VSCode for this particular view works just fine.
**Did this occur in prior versions? If not - which version(s) did it work in?**
(DacFx/SqlPackage/SSMS/Azure Data Studio)
Contributor guide
Research direction
Start with the listed reproduction steps for the SQL Project, Microsoft.Build.Sql 2.0.0, and Azure DevOps build and release pipelines. Compare the failing pipeline deployment with the successful VS Code publish for the view referencing a Lakehouse SQL endpoint. Done means the generated dacpac deploys the lakehouse-referencing view successfully through the release pipeline.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- ci-cd, cloud, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100