Bigquery LegacySQL invalid snapshot in time using special decorator @0

0
votes

I'm running bigquery legacy sql and using the special decorator @0 it gives an error on any table:

Invalid snapshot time 1570001838355 for table upbeat-stratum-242175:my_dataset.my_data. Cannot read before 1570001838359

Running this again will only change with current timestamp but always shows a difference in the timestamps from the error of ~4 seconds.

Also this is happening regardless the table I run it against.

https://cloud.google.com/bigquery/table-decorators

1
google-bigquerydecoratorlegacy-sql
It would be easier to get help if you create an issue tracker issuetracker.google.com/issues/… – Pentium10
I did that. Thanks. – Alexandru R
Here's the issue, for anyone having the same issue. issuetracker.google.com/issues/142342267 – Alexandru R

1 Answers

1
votes

@0 seems broken right now. Could you use @-604700000 instead?

The calculation is 3600000 * 24 * 7 = 604800000 and cut a little from the end.

It allows you to time travel back to 7 days ago, which is practically the same as @0 (when it works).