Fix the SQL Analytics Endpoint sync delays

[fbcideas_migusr]

Please fix the SQL Analytics Endpoint sync delays.

Many users have been surprised and are receiving old data because of the Lakehouse SQL Analytics Endpoint sync delays.

We want Fabric to handle this automatically, so we don't need to think about it.

[SWestbrook]

Would it be possible to delay committing data to the lakehouse until the SQL endpoint sync is complete? Or introduce a new transaction isolation level where the user can choose to wait for the endpoint to be sync'd.

[KevinFeit]

If the sync delay can't be eliminated, then I suggest adding a Data Factory task that can wait on sync completion. Otherwise if you try to implement a pattern of loading to a lakehouse and then bringing data to a warehouse using the SQL endpoint, you risk failure or incorrect results due to the sync not being completed.