on 06-23-2022 3:22 AM
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,
Mio
Hello,
you may embed the ALTER statement into a procedure and then schedule the procedure using CREATE SCHEDULER JOB Statement
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.