Skip to Content

Connect Your Space to an SAP HANA Cloud, Data Lake

Connect your SAP Datasphere Space to the SAP HANA Cloud, data lake to gain more storage to handle petabytes of data.
You will learn
  • How to connect your SAP Datasphere Space to the SAP HANA Cloud, data lake
jmmargojmmargoMarch 13, 2023
Created by
January 6, 2023

To get familiar with the SAP HANA Cloud, data lake, please see the SAP HANA Cloud product page. You can also discover the data lake capabilities in detail with this SAP HANA Cloud, data lake mission.

To use a data lake associated with SAP Datasphere tenant, you need to open a support ticket. Please see more details here in the technical documentation.

If you are accessing the data lake via SAP Datasphere, you can only use a single user in the SAP HANA Cloud, data lake.

  • Step 1

    You can access tables in the data lake via virtual tables in the open SQL schema in SAP Datasphere, once the data lake is connected to your SAP Datasphere tenant. These tables can also be consumed in the Data Builder.

    DDL statements in your data lake are currently not audited.

    In order to connect your Space to the data lake, follow the steps below:

    1. Go to Space Management and select the Space that you want to give access to data lake. Alternatively, you could create a dedicated Space for the data lake.

    2. Under Storage Assignment, select the check box Use this Space to access the data lake. If another Space already has access to the data lake, you won’t be able to assign it to your Space.

    3. Click Save.

    You can now use your preferred SQL tool to create tables in data lake and access these tables as virtual tables in your open SQL schema.

    Log in to complete tutorial
  • Step 2
    1. SAP Datasphere offers two stored procedures that you can use to easily create and access the tables. For more information and examples on the stored procedures, see the technical documentation.

    2. In your SQL tool, use the "DWC_GLOBAL"."DATA_LAKE_EXECUTE" ( IN STMT NCLOB ) stored procedure in the schema DWC_GLOBAL to create tables in data lake. Please note, that the statements issued via this procedure are not audited.

    3. Then create virtual tables in your open SQL schema that refer to the tables in data lake. The virtual tables are used to query data stored in data lake.

    Log in to complete tutorial
  • Step 3

    Use the following procedure to create a virtual table in your open SQL schema:


    You can then work with your virtual tables in the Data Builder by selecting the open SQL schema used for the data lake.

    Well done!

    You have completed the Introduction to SAP Datasphere Administration tutorial group. Now it’s time to continue learning. Please check out the other SAP Datasphere tutorials available here, and don’t forget to follow the SAP Datasphere tag in the SAP Community to hear about the most up to date product news.

    Log in to complete tutorial
  • Step 4

    How many spaces can be assigned to use and access the data lake?

    Log in to complete tutorial
Back to top