Communication between multiple region workspaces & metastore

[Dnirmania]

Hi Everyone

We currently have a workspace and metastore in the EastUS region, and we’re planning to set up another workspace and metastore in the Canada region. Additionally, we need to be able to access data from the Canada region within the US region workspace.

For testing, I started with Delta Sharing and also created a direct connection to the Canadian metastore from the US workspace. While I’m able to read data using both methods, I’m unsure which one is the best option.

Could you please help me determine the best approach and let me know if there are any other alternatives I should consider?

Thanks,

Dinesh

[Advika_]

Hello @Dnirmania!

Delta Sharing is ideal for read-only, cross-platform data access without duplication. Direct metastore connections offer low-latency access between Databricks workspaces under a unified governance model.
Additionally, you may explore Lakehouse Federation, which enables querying across regions and external systems. It is ideal for hybrid environments that prioritize consistency.
It depends on your specific scenario, you can choose the best approach based on your needs.

For more details, refer to the official documentation: https://docs.databricks.com/aws/en/query-federation/databricks