This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Duplicate History ID

Posted on 04-22-2021 07:18 AM
eRKo
New Member
Reply posted on --/--/---- --:-- AM

We are using Big Query (Standard) as the backend for our Looker. When I check the INFORMATION_SCHEMA.JOBS_BY_PROJECT table in BQ, I can see multiple jobs with the same history_id from Looker. Can someone please explain what is happening here?

Thanks!

0 2 130
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
IanT
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

Am curious about this one, have you looked at the queries? Is it by any chance the row total query which ignores dimensions when grouping, looker may treat that as one but fires off 2 queries to bq?

0 Likes

Posted on --/--/---- --:-- AM
eRKo
New Member
Reply posted on --/--/---- --:-- AM

I’ve checked one duplicate history_id and you are right: one of the queries is a “standard query”, other three are COUNTs. Is there any documentation explaining why does Looker treat it as one but fires off 2 queries to bq? Thanks a lot! 

0 Likes
Top Labels in this Space