Sync delta tables across workspaces

[Lizz]

What is the most cost-effective way to sync delta tables across workspaces? I'd like to sync a production table from the production workspace to a staging workspace for testing. It doesn't have to be in real-time, on a daily basis is acceptable. We are using AWS, and Unity Catalog if it matters.

I found Migrate from DatabricksLabs, but it seems that it will sync the entire metastore. I'd like only to sync one (giant) table from the metastore.

Some examples of the potential solution would be greatly appreciated!

[Chris_Shehu · Accepted solution]

At the moment my impression is that catalogs are shared across workspaces where the meta data catalog is assigned. As far as I can tell so far you can't separate out which tables are shown based on workspace just yet it's all or nothing.

[Anonymous]

Hi @Liz Zhang​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!