Azure Data Studio Database Project: Reference to Lakehouse

[cw88]

Hi all, 

i try to create a database project in azure data studio. The import of all objects works fine, but when i try to build the project i get errors with the message "... [Object] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: ..." .

This objects (views) get data via cross database query from a lakehouse in the same workspace. 

Does anyone know whether it is possible to store the reference to the lakehouse in the project?

Thanks!

[AndyDDC · Accepted solution]

Hi @cw88 only Fabric Warehouses are officially supported in Azure Data Studio.

However, I have been able to also import a Lakehouse schema into an Azure Data Studio project where the target platform is set to Fabric Warehouse.  Then the only way I could get the cross-database dependency to build from the Warehouse to the Lakehouse was to successfully build the Lakehouse, then in the Warehouse create a Database Reference to the Lakehouse dacpac.

In the image below I have a Warehouse and a Lakehouse project.  The Warehouse has a Database Reference to the Lakehouse dacpac.

I did use the Azure Data Studio Insiders build for this.

https://github.com/microsoft/azuredatastudio#try-out-the-latest-insiders-build-from-main-branch

[vitaly]

Hi @AndyDDC ,

We are using a similar solution.

The challenge is that while SQLCMD variables work, the literal strings do not work during the build. This means we have to manually update all the references to Lakehouse objects to use variables. This presents two challenges:

1) It's a manual step and adds effort to each new object

2) The variable references come up as a "change" during each database => database project schema comparison

Have you been able to make references to work using the standard 3-part name, without involving code changes and variables?

[v-nikhilan-msft]

Hi @cw88 ,
Thanks for using Fabric Community.
Apologies for the issue you have been facing. At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Can you please confirm if you are using the latest version of Azure Data Studio? If yes you can connect to SQL endpoint using Azure Data Studio and can successfully query the tables. 

[cw88]

Hi, i use the latest version of Azure Data Studio, connect to SQL endpoint is possible.