Forum Discussion

JosueMolina's avatar
JosueMolina
Helper III
2 years ago

Moving Lakehouse from Development to Test. SQL Endpoint points to the Dev version

As title says, I began experimenting with Deployment Pipelines and I was able to move some Lakehouses between Dev and Test. Data is not moved, but the SQL Endpoint for the newly deployed Lakehouse st...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, JosueMolina 

 

Based on your description, it seems that the SQL Endpoint for the newly deployed Lakehouse still points to the previous Lakehouse. This can happen when the SQL analytics endpoint is not reprovisioned after moving the Lakehouse from Development to Test.

 

To avoid this issue, you can try reprovisioning the SQL analytics endpoint for the Test Lakehouse. You can follow the instructions provided in the Data Warehouse documentation.

What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JosueMolina's avatar
JosueMolina
Helper III
2 years ago

Hey v-zhangti 

Seems like the created SQL endpoint is now correct inside of the Test workspace, though creating a Semantic Model from within the Lakehouse is still connecting to the previous stage SQl endpoint (Development), as well as using the button to switch between Lakehouse and SQL endpoint in the UI:

(using this button on the Test Lakehouse to switch to the SQL endpoint will send me to the Dev SQL endpoint and not the Test one.)

Using the SQL endpoint directly from the Workspace view and creating a Semantic model from there works fine.