topic Re: Sync delta tables across workspaces in Data Governance

Sync delta tables across workspaces

Lizzz — Sun, 26 Feb 2023 00:59:42 GMT

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!

Re: Sync delta tables across workspaces

Chris_Shehu — Sun, 26 Feb 2023 22:43:40 GMT

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.

Re: Sync delta tables across workspaces

Anonymous — Mon, 13 Mar 2023 04:50:06 GMT

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!