I am frequently facing synchronization issues with the SQL Endpoint in the Lakehouse. After loading data into the Lakehouse, I typically run a query to get the maximum date and record count from the pipeline. However, I often notice that immediately after the load, no records are returned. To work around this, I’ve had to introduce a 2-minute wait activity before querying the metrics. Has anyone else experienced similar issues? Is there a more efficient way to resolve this synchronization delay, or a setting that can ensure immediate data availability? Any advice or suggestions would be greatly appreciated. Thanks!

We plan to maintain the bronze and silver layers in one workspace and the gold layer in a separate workspace for reasons related to maintenance, security, and capacity. However, this setup presents a challenge: implementing a master orchestration that includes pipelines from both workspaces. Currently, I'm unable to directly invoke a pipeline from another workspace. Is there any workaround available to address this issue?

Is there a way to consume tables from a different lakehouse within our existing lakehouse without using ADFS paths or creating shortcuts?