Forum Discussion

Anne-MarijnV's avatar
Anne-MarijnV
Frequent Visitor
1 year ago
Solved

Alter view on lakehouse SQL endpoint not working

At my company old sales orders are deleted from the source system after 2 years because they are no longer needed there. To keep the data available for reporting, I've created a pipeline that will a...
admin
  • Anne-MarijnV's avatar
    Anne-MarijnV
    1 year ago

    deleting the lakehouse and recreating it did the trick. must've been some kind of bug

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
1 year ago

Hello Anne-MarijnV 

 

I'm not sure why its working. SQL Server saves information about views for quick access. However, if the tables used by the view are changed, the view's information might not update automatically. To fix this, you can try the sp_refreshview command to update the view's information so it matches the updated tables. At some cases, dynamic SQL might not execute as expected. 

 

If you need more info please visit below urls. It might helps you

Solved: Re: SQL Query / View not loading - Microsoft Fabric Community

Fix SQL Analytics Endpoint Sync Issues in Microsoft Fabric – Data Not Showing? Here's the Solution! — obvience

Lakehouse T-SQL Endpoint syncing issues (force update fix) · Learn Microsoft Fabric

 

Thank you!