Is there a way to copy a warehouse?

[MylenePBI]

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?

[Anonymous]

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.

[MylenePBI]

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?

[Anonymous · Accepted solution]

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.

[MylenePBI]

Yes it helps, thanks a lot!

[AndyDDC]

@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 

[MylenePBI]

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

[AndyDDC]

Here are some screenshots to help:

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