CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
Nehal Sateeshkumar
Nehal Sateeshkumar

Reputation: 33

Why are there random dates data on intraday tables in Bigquery?

I have set a Google Analytics to BigQuery daily export for one of our views. According to my knowledge the intraday tables which is populated thrice a day gets deleted once ga_sessions() populates. Recently I observed that there are random dates data on the intraday tables. Having a look at the logs on stack driver I don't observe any anomaly.

Please could some one explain this case. Refer this image!!

Upvotes: 1

Views: 169

Answers (1)

guillaume blaquiere
guillaume blaquiere

Reputation: 75735

BigQuery UI propose you to select only the existing partition. If you haven't data for a giving date, there is no partition, and thus, there is no proposal on the GUI.

Can seem strange, but it's useful!!

Upvotes: 1

Related Questions