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

Can we schedule refresh of snapshots?


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.

Best regards,