Forum Discussion
Lakehouse - sync issues to SQL en`dpoint
Hi joakimfenno ,
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
the sql endoint synced after two days, but I dont understand why/how
Hi joakimfenno ,
Sometimes, there is a delay in synchronization, albeit a long time.
If the issue has been resolved, can you please mark this post as "Answered"?
Best Regards,
Yang
Community Support Teamfor some cases its hard to tell is cases are resolved or not 🙂
in my case the sql endpoint were in sync two days later - is that expected or a bug?
You wrote that "Under normal conditions, the lag between updates in the Lakehouse and the SQL endpoint should be less than a minute. If there are many partitions in your Delta tables, the sync might take longer due to the service parsing a large Delta log."
in my case we did not have any partitions
joakimfenno I am in the same boat as you. Can you please confirm me 1 thing if possible, after you perform the delta table operations, if you manually refresh following this, does the sql endpoint sync immediately ? src - https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
Yes I tried that
I will try again next time this occurs and get back