Sync the production data in environment into test environment

[zyang]

Hello,

I have a database called sales which contain several delta tables and views in both production and test workspace. But the data is not synced because some people develop the code in test workspace. As time passed, both the data and the tables in test become different compared to the ones in the production database. May I ask the best practice to sync the data and the tables/view in the production into the test environment?  I am using Azure platform. Now I have a script to copy the production data in the production storage into the test storage and create the table from the test storage again. I think I can expand it into the whole database but the thing is I cannot get the full list of tables/views in production database by using "show tables in database" in test workspace. Would you mind giving some advice? Any advice regarding to getting the full production table list from the test workspace or the best practice to sync data between production and test.

Thanks.

Best regards

[Hemant]

HI@zyang  Unity Catalog Enabled workspace, you can access your databases in a cross environment.

[Chris_Shehu]

Not always the best if your trying to keep environments isolated between workspaces. 

[Anonymous]

Hi @zyang 

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!

[zyang]

No, I would like to wait for more advice