In the update latest version of SAP Data Warehouse Cloud, a new feature has been added: Sharing Objects across Spaces, which allows users to share objects across SAP Data Warehouse Cloud Spaces.
This allows us to use data from another spaces without replicating the data physically in both spaces. To show this functionality is working we are going to use an example of sales data.
This system is composed of three elements
- Two spaces:
- one space with our main data
- a second space to combine the shared data with our data from the second space
- A shared object (view / table)
- A view to use the shared object
Share an Object from a Space
You need an Object (Table or View) with the data you want to use in another space. With the Buttons in the menu of the Object you can share the object with another space.
Select the space, in which you want to use the data, for sharing the object.
Build a view in the second Space
Switch to the second space and create a new SQL View. Now you can see the shared object in the Repository in the Category “Shared Objects”. You can use the shared object and combine it in a view, like in the code example)
This post is based on tests on the latest beta version of SAP Data Warehouse Cloud. This functionality may or may not be included in the final version of the product.