How to transfer the commit time of records to BigQuery
BigQuery color decorators refer to added time
records.
Link table data added between and
(from https://cloud.google.com/bigquery/table-decorators )
Or it looks like it's also called commit time
.
time stamps are compared to the fix time
(from https://code.google.com/p/google-bigquery/issues/detail?id=160#c12 )
Is there a way to find out added time
or commit time
records?
source to share
those. something like "SELECT ThisRowCommitTime (), * FROM table" or via a Tabledata: list that will display the timestamp for each row?
No, this is a smart thing to look for, but it is currently not available.
You can write down a feature request , and this can help us further motivate how the feature will be useful to you. Specifically: would it still be useful for you if it only renders for data up to 7 days corresponding to the range that you can travel in time with a decorator?
source to share