It would be nice to be able to copy data between DWH instances. Currently it is not possible to copy tables from DWH instance A to DWH instance B. You can load instance A as a source into ODX/Ingest and then load it to instance B, but for large tables it consumes a lot of time and resources (compressing and decompressing parquet etc).
We have two scenarios where this feature would be very useful:
- Make corporately cleansed data (partially) available into smaller division data warehouses
Our customer wants to process and cleanse all data from their main systems in one central place. The result is stored in the corporate DWH. But also divisions have their own, smaller DWH. We would like to push data from the corporate DWH to division DWHs in the same way you can copy data between data areas.
- Make big data sets available for customers and auditors
While we can use semantic models, csv export and REST API to make data available to third parties, it sometimes is just too much data for these methods to transfer it efficiently.
