Skip to Content
0
Jun 23, 2022 at 02:22 AM

Can we schedule refresh of snapshots?

178 Views

In HANA Cloud, we can create a snapshot for a virtual table and refresh the snapshot using the following SQL.

alter virtual table "FVT_LINEITEM" refresh snapshot replica;

In a real-life scenario, we would schedule the refresh so as snapshots are refreshed at a regular interval.

What would be the recommended approach for achieving this? Is there standard tools or functions available?

I have referred to the following blog post for creating snapshots.

https://blogs.sap.com/2020/05/18/checking-the-behavior-of-sap-hana-cloud-virtual-table-replica-feature/

Best regards,

Mio