Access a Standalone Data Lake in SAP HANA Cloud
- The different ways to access your standalone data lake instance
- How to connect your standalone data lake using SAP HANA Database Explorer
- How to connect your standalone data lake using SAP Interactive SQL ( dbisql )
- How to connect your standalone data lake using isql
- You have completed the tutorial provisioning of a standalone data lake in SAP HANA Cloud using a free tier model, trial, or production account.
After completing the provisioning of your standalone data lake in SAP HANA Cloud, you can access the data lake and start storing, querying and manipulating your data. In this tutorial, you will learn some of the ways you can do that, focusing mostly on how to access and interact with your standalone data lake using the SAP HANA Database Explorer.
You can also learn how to access the same instance using SAP Interactive SQL (dbisql) and isql, in case you are familiar with those tools. Before you access the data lake instance, it is important to understand the function of users, roles and privileges while interacting with your instance.
- Step 1
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.
- Step 2
Ensure that your standalone data lake instance is currently running before trying to connect to it using SAP HANA Database Explorer.
To do this, navigate to the SAP HANA Cloud Central wizard from your data lake instance in the SAP BTP cockpit.
Locate your standalone data lake instance details by selecting to view all instances.
If your instance is showing any status other than running, click on the three dots button assigned to the instance for more options.
Now, select the option to Start the instance and wait until it has the status
- Step 3
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.
- Step 4
For this step, select your preferred connection method by clicking on the options under the step title.
After confirming the status, click on the three dots again and select the option to Open SQL Console in the SAP HANA Database Explorer.
You can also navigate to the same destination by selecting the option to open SAP HANA Database Explorer.
Look for the name of your standalone data lake from the database menu located on the left side in the database explorer.
Click on theicon in the top-left corner to open a new SQL Console.
You can confirm the connection to your standalone data lake from the connection status provided on the menu in the SQL Console.
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.
- Step 5
The SQL Endpoint information of your standalone data lake consists of information on:
(Multiple answers may be correct.)