Add Query ID in BigQuery queries

Feedback and Requests
1

Hi,
There is a parameter on the metabase bigquery connector that allows to include UserID and queryHash in queries sent to bigquery.
Effectively, it will add a comment at the top of queries sent to BigQuery of this form:

-- Metabase:: userID: 73 queryType: native queryHash: c21cbb35367f5676d7832f7565296b9e91e2dbe0bf16e9bbde7893843d66f383

It allows to debug, audit and make stats per users. I would like to know if it would be possible to add queryID as well so that we can monitor which Query uses a lot of data. I guess it must already be possible to do this with queryHash but I don't see anyway to search a Metabase question with the queryHash (so I am not sure why it was included in the first place).

Please let me know if that makes sense to you and I will open an issue.
Thanks !

PS : it would be nice if this setting could be separated from the existing 'add user ID' parameter, because it would be useful to deactivate the userID parameter to let BigQuery cache results and still be able to make stats per queryID

2

Hi @AnatoleC
There's a request for that:
https://github.com/metabase/metabase/issues/9514 - upvote by clicking :+1: on the first post

3

Thanks @flamber
Though I am not sure it's a good thing that there already is an issue as it was opened 3 years ago and nobody worked on it.
Is there a way to see which issues have the most upvotes on GitHub so that we can see the ranking ?

4

@AnatoleC Upvotes is not everything, when it comes to prioritization. Customers (Pro/Enterprise) also escalates prioritization. And a few more parameters.

List of issues by upvotes:
https://github.com/metabase/metabase/issues?q=is%3Aissue+is%3Aopen+sort%3Areactions-%2B1-desc

Metabase is an open source project, so you're welcome to submit a tested PR with tests.