Set tbl_backup= 'backup table '||towner||'.'||tname Where lower ( suser_name( creator ) ) = lower( schema_owner ) Select suser_name( creator) as towner, table_name tname , in cloud_credentials varchar(1000) default NULL , in encryption_key varchar(128) default NULL This procedure does not extract the table schema, that must be done via other toolsĭrop procedure if exists sp_iqschemabackup.It does not copy views, materialized views, or catalog tables. This procedure will only copy the IQ based tables.This procedure is just sample code showing what is possible.However, we can use this feature and use a wrapper procedure that calls it for each object we wish to backup to disk.Ĭonsider this stored procedure to use the BACKUP TABLE feature to implement a schema backup. Now, backup table won’t solve the problem on its own as it is designed to back up a single object, table, to disk. Now, for the good news… While there is no feature to backup or export a schema, we can use a feature that has been in SAP HANA Cloud, data lake since March 2021 and one that is part of SAP IQ 16.1 SP05 (2H 2021): BACKUP Table While SAP HANA and SAP HANA Cloud, HANA database support this feature via the EXPORT statement, SAP HANA Cloud, data lake and SAP IQ do not have similar syntax built in to it. More and more this year, I am fielding questions about whether or not SAP HANA Cloud, data lake or SAP IQ support schema level backups.

Amazon data lake personal backup