Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Querying from a snapshot
Hi, I am trying to create a snapshot and query only on that snapshot. Even if there are further reloads of a table, truncates, updates or deletes to the table, I should get the same results as it was when I created the snapshot. I am not convinced that the below approach is what I should be taking as I was getting confusing results when I do operations between a) and b). a) SELECT DATABASE_SNAPSHOT('mysnapshot',true); b) at time 'timestamp1' select count(*) from schema.table1; Questions 1) Is there a better option than b) to query from 'mysnapshot'. 2) If b) is the right approach to take how will I find timestamp1 which is the timestamp at which the snapshot was created ? Thanks Zac
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.