Connect Your Space to an SAP HANA Cloud, Data Lake

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.

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.

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

"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 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.