Can i add new label called looker-context-look_id in BigQuery connection(Looker)

[hasangzc]

I wanna see my look id in corresponding bigquey job labels. My objective is to efficiently track Looker queries within BigQuery. Could you please provide guidance on achieving this integration?  Thanks 🙏

[sam8 · Accepted solution]

Hi there!

The only BigQuery job labels you can send are the user ID, history slug, and the instance slug.

You could cross reference the history slug in the System Activity History explore to get the Look ID!

[sam8 · Accepted solution]

Hi there!

The only BigQuery job labels you can send are the user ID, history slug, and the instance slug.

You could cross reference the history slug in the System Activity History explore to get the Look ID!

[hasangzc]

Hello thanks for your reply!. I need look_id and corresponding bigquery job id s actually for running queries. How can i do that? do you have an idea 🙏

[sam8 · Accepted solution]

Hm, I don't think this will be possible to get with running queries. The History explore will only include queries that have completed or otherwise stopped.