Access a Standalone Data Lake in SAP HANA Cloud

SAP HANA Cloud, data lake defines user permissions and privileges using a role-based security model. A role is a set of privileges that can be assigned to a user. As a user, you can grant or revoke these roles or privileges. This means that your privileges as a user change depending on the change in the privileges assigned to your role.

When you create a new data lake instance using the default user HDLADMIN, you are automatically granted all system and object-level privileges in the data lake. You can also create a new user, thereby granting the user with the public system role automatically. This role provides access to view data, execute system stored procedures, and grant roles and privileges to the user.

When you create a new object, you become the default owner of the object unless you define otherwise. This gives you privileges to modify the structure of the table and grant further privileges to other data lake users. Although, you cannot load data into a table based on being the owner, unless you assign INSERT privileges to the role.

To learn more about users, roles and privileges in SAP HANA Cloud, data lake, please see our technical documentation.

Ensure that your standalone data lake instance is currently running before trying to connect to it using SAP HANA Database Explorer.

1. To do this, navigate to the SAP HANA Cloud Central wizard from your data lake instance in the SAP BTP cockpit.

2. Locate your standalone data lake instance details by selecting to view all instances.

3. If your instance is showing any status other than running, click on the three dots button assigned to the instance for more options.

4. Now, select the option to Start the instance and wait until it has the status RUNNING.

You can use different tools to connect to a standalone data lake in SAP HANA Cloud. In this tutorial, we will show you four different options you can choose from:

• Option A: SAP HANA Database explorer
• Option B: Interactive SQL (dbisql) - graphical interface
• Option C: Interactive SQL command line interface (CLI)
• Option D: isql

In the next steps, you can learn how to use each of these connection methods. Once you have decided which option you would like to use to connect, following the other steps is not mandatory.

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

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