As of QRC01/2021, SAP HANA Cloud, Data Lake allows you to perform backup and restore operations on individual tables in your data lake.
What is this feature, and why do I need it?
The table-level backup feature allows you to back up individual tables in a database. In SAP HANA Cloud, Data Lake, this means you create an AES256-encrypted binary file of the data that is in the table you specify. You can specify to compress the backup if you need to save space in the object store of the corresponding infrastructure-as-a-service (IaaS) provider (e.g., Amazon AWS).
Choose to implement table-level backups when your database is very large and backing it up takes a long time or when you just want more frequent backups of critical data.
You might also integrate table-level backups into your disaster recovery plan.
Finally, you might also use table-level backup as a clever way to make your data exports more efficient by moving data into the table(s) you are backing up.
How do I access this feature?
You need to be running QRC 01/2021 or later SAP HANA Cloud, Data Lake to enjoy this capability. Of course, you’ll also need the required privileges to perform the backup or restore operation for the desired tables.
While there *is* an enableBackups parameter that enables the normal database backup capability in SAP HANA Cloud, Data Lake, you won’t need it for this feature. Table-level backup works regardless of the setting for this parameter.
The syntax to backup and restore a table is fairly straightforward, although you’ll need to know the relevant connection string information for your IaaS provider:
Where do I find more information?
- Documentation: SAP HANA Cloud, Data Lake Backup, Restore, and Data Recovery
- Documentation: Table-Level Backup and Restore of Data Lake IQ Data
- Documentation: SAP HANA Cloud, Data Lake
- OpenSAP: Tools to Access and Use the Data Lake in SAP HANA Cloud
- Tutorial: Get Started with a Standalone SAP HANA Cloud, Data Lake
- YouTube: How to provision an SAP HANA Cloud, Data Lake