Can HANA cloud COLD storage be used as permanent storage ?

[Mujeeb]

We are building an application for one of our customer and they have requirement to store the data in HANA cloud database.

We know that COLD storage can be used for backup but we want to know can it be used permanent storage and how to retrieve it later.

The business is expecting the table entries to be retained for approx 23 years. Means the transaction FIORI app should be able to retrieve and show 23 years old data as well on the UI. Is this requirement feasible using the Data tiering options of SAP HANA Cloud service (Hot, Cold, Warm)? Is it possible to retrieve cold storage table entries using the normal CQL queries ? Would the same queries which are applicable for HOT and WARM storage are applicable for COLD as well ? OR any adjustments required in the select queries based on the year of the data which is expected to retrieve ?

RegardsMujeeb

[JasonHinsperger]

You can use the HANA Cloud, data lake to store data in files or in the relational engine for as long as you would like.

You can use virtual tables in the HANA Cloud, HANA database to query data in the HANA Cloud, data lake using standard SQL

If you want to query the HANA db and data lake data in the same query, you would need to create a view or use a union.

regards,

--Jason