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.
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