I'm developing an addon of Google Workspace (Google Slides) and having an issue of BigQuery API calling by any of addon user.
An addon will be published to public not for domain only and everyone across the globe may use.
On addon, I'd like to call BigQuery job to run a query and insert a row to record a usage.
However I'm faced an issue of "Access Denied: Project XXX: User does not have bigquery.jobs.create permission in project XXX." even I can run this for developer user.
I assume that this is because lacking an access permission to BigQuery API by OAuth.
Should I grant an access to every addon user for BigQuery? Or any standard way to implement this , such as calling BigQuery API by API_KEY, service account etc?
Thank you for your help in advance!
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
