Forum Discussion

cw88's avatar
cw88
Helper IV
2 years ago
Solved

Azure Data Studio Database Project: Reference to Lakehouse

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 un...
data warehouse
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
cw88
Helper IV
2 years ago

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