Unable to access GUI mode in BigQuery

Hi team,

I am unable to access the GUI mode in BigQuery. After reading the docs, I came across this:

If GUI mode is disabled in the selector, it's probably because your database user does not have write permissions.

However, I have tried two different authentication types (service account and OAuth) and both authentication methods have full BigQuery Admin access.

Am I missing a specific permission that is needed to unlock the GUI mode?

image

@johnatcombine

Hey there :wave: Thanks for reaching out! This should be available if the user has the appropriate permissions :thinking: Can I ask how you have your permissions set?

I am running into the same issue... What are the necessary authorizations required, so that I can guide our BQ admin?

Hi @Fredator Thanks for reaching out! I looked into this & it looks like you should be able to access GUI mode if the service account has read & write permission. Unfortunately, it looks like we don't support GUI mode when using the OAuth authentication type.