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.