topic Is there a way to copy a warehouse? in Data Warehouse

Is there a way to copy a warehouse?

MylenePBI — Wed, 15 Nov 2023 16:48:01 GMT

Hello,

I have to create differents warehouses, all with the same tables, relationships, measures, only the data in the table change. For some internal policies reasons, they have to be separated. I would like to keep the whole structure (tables, relationships, measures). Is there a way to do this?

Re: Is there a way to copy a warehouse?

Anonymous — Thu, 16 Nov 2023 07:10:48 GMT

Hi MylenePBI
Thanks for using Fabric Community.
To copy a warehouse you would need to script out each object and run it on each copy of the warehouse. You can also look into devops/deployment pipelines to keep each warehouse's objects in-sync.
Instead I would suggest that you can try row and column level security to see if that will solve your security needs. You can use row level and column level security to ensure people can only see the data that they should have access to.

You can refer to this link : Link1
Hope this helps. Please let me know if you have any further questions. Glad to help.

Re: Is there a way to copy a warehouse?

MylenePBI — Thu, 16 Nov 2023 08:16:15 GMT

Many thanks! In my case, I need to apply several layers of security due to business requirements. Do you have a link to documentation in order to help me to write the script? For deployment pipeline, currently pipelines and warehouse are not supported, maybe it will change soon?

Re: Is there a way to copy a warehouse?

Anonymous — Thu, 16 Nov 2023 09:09:12 GMT

Hi MylenePBI ,
You are right. Currently Deployment pipelines for Data Engineering items is not supported. But this is on roadmap.

You can refer to these links :
Security for warehouse
Implement Row Level Security
Implement Column Level Security
Dynamic Data Masking

Hope this helps. Please let us know if you have any further questions.

Re: Is there a way to copy a warehouse?

MylenePBI — Thu, 16 Nov 2023 09:22:27 GMT

Yes it helps, thanks a lot!

Re: Is there a way to copy a warehouse?

AndyDDC — Thu, 16 Nov 2023 10:29:26 GMT

MylenePBI are you familiar with Azure Data Studio? It has support for Fabric Warehouses so you can connect to a warehouse and download the schema into an offline database project. You can then deploy that database project to another warehouse

Re: Is there a way to copy a warehouse?

MylenePBI — Mon, 20 Nov 2023 09:31:05 GMT

Hello, I've tried Azure Data Studio, bu can't find the way to download the schema. Do you have more information about the way to achieve it?

Many thanks!

Regards,

Mylene

Re: Is there a way to copy a warehouse?

AndyDDC — Mon, 20 Nov 2023 10:28:02 GMT

Here are some screenshots to help:

https://www.serverlesssql.com/fabric-warehouse-source-control-in-azure-data-studio/