The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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