How to migrate fabric warehouse data between dev and test workspace in fabric

[DiKi-I]

How to migrate fabric warehouse data between dev and test workspace in fabric quickly without creating pipelines?

[v-achippa]

Hi @DiKi-I,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @NandanHegde and @BhaveshPatel for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @DiKi-I,

We wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @DiKi-I,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's resolved your issue? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[NandanHegde · Accepted solution]

unfortunately based on my understanding, there is no direct way to restore the data of fabric warehouse from 1 workspace to another.

You would have to use some data transformation or movement tool like either notebooks, datapipelines or dataflow Gen 2.

I am not sure whether the below method would work but you can access the underlying files and folders of fabric warehouse via Azure storage explorere, you can try copying that and pasting into destination warehouse folder >>> need to test this out

[BhaveshPatel]

For that you should use Apache Spark and Delta Lake together in the notebooks along with CI/CD approach. I have a solution that is handy and use CI/CD approach. Please reach out to me for further CI/CD. Cheers..