Skip to Content

Connect Your Space to an SAP HANA Cloud, Data Lake

Connect your SAP Data Warehouse Cloud 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 Data Warehouse Cloud Space to the SAP HANA Cloud, data lake
rashidabdulrahimanRashid Abdul RahimanSeptember 12, 2021
Created by
rashidabdulrahiman
September 1, 2021
Contributors
rashidabdulrahiman

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 Data Warehouse Cloud 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 Data Warehouse Cloud, 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 Data Warehouse Cloud, once the data lake is connected to your SAP Data Warehouse Cloud 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.

  • Step 2
    1. SAP Data Warehouse Cloud 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.

  • Step 3

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

    SQL
    Copy
    "DWC_GLOBAL"."DATA_LAKE_CREATE_VIRTUAL_TABLE"
    (IN VIRTUAL_TABLE_NAME NVARCHAR(256), IN DATA_LAKE_TABLE_NAME NVARCHAR(256), IN TARGET_SCHEMA_SYS BOOLEAN DEFAULT false).
    

    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 Data Warehouse Cloud Administration tutorial group. Now it’s time to continue learning. Please check out the other SAP Data Warehouse Cloud tutorials available here, and don’t forget to follow the SAP Data Warehouse Cloud tag in the SAP Community to hear about the most up to date product news.

  • Step 4

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

Back to top