Hi Team Support, I have a source table in BigQuer...
# community-support
b
Hi Team Support, I have a source table in BigQuery with the timestamp columns are in UTC timezone (first image). I filter out the first row by using
DATE(updated_at) < CURREN_DATE()-1
and it gives the second image. Seems that all the timestamp is pretty much the same after the filtering. I implemented the filter and put in
where_expression
parameter in elementary test but I got the anomalous result again (which it shouldn’t). Why does it happen? Thank you