I'd like to share with you this annoying issue with the Fabric Lakehouse SQL endpoint. I tested it multiple times, and I still see discrepancy: you update, insert, or delete rows in Lakehouse tables, it succeeds, but when you query the table, the changes are not reflected, so if you have a process that table, it will read the old version! https://www.reddit.com/r/MicrosoftFabric/comments/1fput1m/to_microsoft_with_love/
The workaround I tested:
To set a wait activity if you are using a pipeline