Different use cases and different business strategies require tailored business needs. In SAP Data Warehouse Cloud “Spaces” allows you to create an environment that meets your particular requirements. You can assign users and connections to a specific space and adjust the storage capacity.
Spaces are virtual work environments with their own databases. Spaces are decoupled, but are open for flexible access, thus allowing your users to collaborate without having to worry about sharing their data. To model your data and create stories, you need to start off by creating a space in your data Warehouse Cloud Tenant. You can decide how much and what kind of storage you need, as well as how important your space is compared to other spaces. You also add the users and set up the connections here.
Space Management – Datawarehouse Cloud
Understanding the Menu – Space management
Within the space management you can do the following:
- Create spaces
- Get an overview of all spaces
- Get an overview of the storage usage of spaces
- Add or remove users
- Add or remove connections
- Increase or decrease storage capacity
- Within overview sections, you see your space ID and the Space name which was created by you and the status of the Space indicates whether the space is active or inactive. Space ID cannot be changed once the space is created however you can change the space name if needed.
- You also see the overall memory assigned and distributed to your space. Disk size in GB and in memory in GB. At this level, you also have the ability to increment or decrement the size.
- Space priority indicates that how important your space is comparing to other spaces that you might have created. The highest priority is 5 and the lowest priority you can set is 1. The concept of prioritization is that spaces send queries or jobs to the database and It is then up to the database to determine which job or application to deal with first. To solve this problem, queries from certain spaces can be favored, meaning they will be processed faster than queries from other spaces. Spaces with a priority of 5 have the most highest accessible need and queries from these spaces are processed quicker.
This section allows you to decide and add which users are to be part of this space. For example suppose you have multiple spaces for various different departments like HR, Marketing, Sales, etc and you want to only have sales department employees/users to be in the Sales Space and no other department user should exist. which basically means that you are adding members of the sales department who are allowed to work in this particular space.
- You can see a list of already added users to this particular space.
- You are able to add any new users/members to this space as per need by clicking on the (+) icon.
- You are able to remove any user/member by simply selecting the user and press the delete icon.
- Finally, if you have a huge list of users/members then utilize the search bar to make your life easy by quickly searching and navigating to that user.
This is where you will able to leverage the SDI capabilities in order to create and establish a remote connection to any other SAP or third party systems. You do not need to perform any long tasks to create connections in DWC it is pretty simple and straight forward to create remote connections by few clicks. To see an example on how to create a remote connection in SAP data warehouse cloud you can visit my other blog here.
- You can view all existing connections that are set up in this space.
- You can add or delete any connection.
- Once the connection is added you can validate to ensure there are no connectivity issues.
- Utilize the search bar to look for any connections if the list is too big.
An open SQL schema contains the space-specific database objects of that space. With this functionality, you would be able to expose data and metadata from 3rd-party tools to SAP Data Warehouse Cloud, for example, via JDBC by creating an open SQL schema. There is no set limit to the number of open SQL schemas you can have, you can create multiple open SQL schemas for one space. Also, you can edit and create new open SQL schemas in Space Management.
For example, you would need an open SQL schema if you have existing data models or flows somewhere which you would like to use these in SAP Data Warehouse Cloud and maybe further use these data models to create any stories at a later stage.
You can use the provided information to connect your ETL tools with SAP Data Warehouse Cloud. You can create multiple open SQL schemas for all kinds of use-cases. Once you’ve set up your schema and you’ve connected your tool or system, your existing models are extracted and stored in SAP Data Warehouse Cloud. In the Data Builder.
With this option, you can expose data and metadata from your space in SAP Data Warehouse Cloud to 3rd-party tools. Let’s say you created some models and now you want to use these models in another app or tool. You can allow this data to be consumable by 3rd-party tools. To do that, create a space schema user. With this user, you can connect via SQL to access your data and you can create multiple users that can access the data.
You can choose whether you want a read log or a change log to be created for this space. You’ll be able to see who made changes to your data or who read the data. This is for the data created within your space.
Below you will see a screenshot of how the space management (administrative) window looks like. Here you will be able to see all the spaces that are created in your tenant. Within the spaces, only authorized members are able to change or add content. Only the Space Owner is allowed to add members to the specific space.
Inside the spaces, just approved individuals can change or add content, and to add any new users to a space only the Space owner is permitted to add or remove any new individuals to the particular space.
Each project or team can have their own individual space. For example, the HR team can have their own designated space and build models or stories specific to their KPI’s and likewise for any other team as well, (i.e. Sales Team, Marketing Team, etc)
Now you might also be wondering what those colors and icons at the top of the screen mean?. They basically are indicating the heath of the SPACE.
The first thing we see is how many spaces are there in total. Each colorful symbol means something and if you bring your mouse over the icons you will get a tooltip indicating what they mean.
For each space you create in your tenant a separate TILE is created which looks like this:
There are a few things the TILE tell us:
- The blue sidebar means that this space is COLD and is in hibernation mode which basically means that this space is not being used too often or not at all which puts the space into hibernation mode in order to save the company computer power.
- The Green sidebar on the other hand means the opposite which indicates that this space is actively used.
- You also see an overview of the memory usage and assigned capacity. This also makes it easy for the ADMINISTRATORS to see which team/space is using most of the resources, which gives better flexibility to manage resources between other teams within your organization.
- You also see the number of members in that particular space.
- You also see the number of connections established within that space.
- Finally, you also get a little hint as to how many data models are created in that particular space
Now that you might have a better understanding of what is a SPACE?, lets now also look at how you can monitor your SPACES?.
This option is more for administrators to monitor the SPACES in terms of resource usage.
Clicking on the monitor option on your SPACE will navigate you to the space management page.
The first thing you will see on the monitoring page is an overview of the Disk and In-memory Usage. You also have the option here to filter the usage overview by (Schema or Storage Type).
The statistics are displayed in nice visuals using bar charts and doughnut charts like what you can see in the below image, which indicates the size of tables that are in-memory or on disk.
You also will be able to see an overview of the Table storage consumptions which highlight all the relevant tables according to the filter you have chosen for the storage type (i.e. In-memory or Disk). In my case, I have selected In-memory therefore I will only get an overview of tables that are stored In-memory.
Furthermore, below the bar chart, you also have another section called (Table Details). This is where you will see details about the tables highlighted in the bar chart. Details such as:
- Table Name
- Storage Type
- Number of records
- Used storage of each table
- Sort the tables by ascending or descending order
That’s it for now. I hope this information is valuable.
If you have any questions about the information provided in this blog post please feel free to ask them below in the comment section. If you have any questions regarding SAP Data Warehouse Cloud in general, Please post them into our Q&A section in the link below: