DWH View referencing Lakehouse object is not resolved while DWH deployment through DevOps pipeline

[amit147]

• 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)

[prdpsvs]

@dzsquared , could you help triage this issue, looks like the publish is going through just fine from VS Code database projects but not from Azure SQL Database deployment task - version 1

[dzsquared]

Quick response before I've had a chance to dig into this much - but it's possible that you need /p:IncludeCompositeObjects=True added to that ADO pipeline.

[dzsquared]

Also noting that while publishing from VS Code succeeds, its to a different environment that ADO publishing fails. Any chance we can get the actual error message?

[amit147]

@dzsquared I included the property /p:IncludeCompositeObjects=True in the release pipeline but that does not help. Below is the error am getting:

Error SQL72014: Framework Microsoft SqlClient Data Provider: Msg 1038, Level 15, State 4, Procedure Entity, Line 10 An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

And it is a view referencing to lakehouse object, am not sure if the error is exactly describing the correct issue.

@prdpsvs

[cfk237]

Hi @amit147,
I think you need to manually reference the lakehouse objects (throught a generated dacpac) to build successfully.
You can have a look on this sample from fabric-toolbox repo. https://github.com/microsoft/fabric-toolbox/blob/7c4600cd8838f27e97958634ab31a98f36b73b16/accelerators/CICD/Branch-out-with-sqlproj-schemas/AzDO/Deploy-To-Fabric.yml.
I put a link to a previous commit as the latest version in main branch seems harder to understand from my point view.