HANA Cloud Data Lake (Cold Storage)

Data Lake Options:

SAP HANA Cloud, data lake can be provisioned and used in two different ways:

  • Managed data lake: The data lake is provisioned as part of the SAP HANA Cloud, SAP HANA database provisioning. A remote connection between the SAP HANA database and the data lake Relational Engine is then automatically created. The easiest way to access the data in a managed data lake is to use SAP HANA virtual tables using the SAP HANA database explorer. You can, however, also access the data lake independently.

  • Standalone data lake: The data lake is provisioned independently of any other SAP HANA Cloud services, and therefore it is not automatically connected to any other SAP HANA Cloud instances you might have. You can access your data within the data lake with SAP HANA database explorer, dbisql, isql, or any of the supported data lake client interfaces.

The two main components of SAP HANA Cloud, data lake are:

  1. data lake Relational Engine: data lake Relational Engine enables efficient storage of structured data and high-performance analytics of relational data at petabyte scale. It’s enabled by default when you provision a data lake instance, whether it’s standalone or managed by an SAP HANA database instance within SAP HANA Cloud.

  2. Data Lake Files: Data Lake Files service provides a secure, managed object storage to host structured, semi-structured and unstructured data files. You can query files in a relational format stored in data lake files by using the data lake’s SQL on Files feature. This allows you to analyze the data with a low-cost strategy, given that this data has an unknown value. It is also easy to share this data with other processing tools. It’s enabled by default when you provision a data lake instance, whether it’s a standalone or managed by an SAP HANA database instance.

The Data Lake Files component is currently not available in free tier or trial versions of SAP HANA Cloud.

Last updated