Load Data into Standalone Data Lake in SAP HANA Cloud

Before you create tables, it is recommended that you also create a new user, so that your new tables are not owned by HDLADMIN. With a new user, your new tables will be created under a particular schema.

This helps you keep your data organized in the simplest level and keeps the tables separate from other tables that might already exist under the HDLADMIN user. Creating a new user also allows you to control the permissions as a group and assign whatever roles you require.

To add a new user, follow these steps:

1. Log in to SAP HANA Cloud Central. In the Actions column of your standalone data lake, click on the three dots and select Open SQL Console. This will open a SQL console connected to your data lake.

2. Enter your data lake credentials if prompted. Then create a new user with the statement given below. Provide your new username and password in the appropriate fields.

   SQL

   Copy

   CREATE USER <username> IDENTIFIED BY <password>
   

For more in-depth information about creating users in SAP HANA Cloud, data lake, please see our technical documentation.

For this step, select your preferred method by clicking on the options under the step title.

Now it’s time to create tables. In this example, you will create the following tables:

• customer
• nation
• region
• supplier

For this step, select your preferred method by clicking on the options under the step title.

For this step, select your preferred method by clicking on the options under the step title.

In this tutorial, you have learned how to load data into the tables in the SAP HANA Cloud, data lake. In the next tutorial, you will see how to monitor your standalone data lake.