Hi, I seem to be stumbling upon an issue when trying to connect BigQuery to metabase. I have the correct project id and a working key token from my big query service account. I tried creating a new key token and it still doesn't work. I made sure that my service account has also the required permissions in the documentation but I am still getting an error when trying to connect.
The error usually comes up as HTML that says
"Oops, something has gone wrong here. I've notified the tech team and they will look into it."
"If you try again in a little while we'll be back"
What is going on here? I checked the other settings but not of them seem relevant to access levels. I've tried on different days too with the same error. I've created a new service account to no avail.
Running out of ideas at this point, so any help would be appreciated thanks.
Hi thanks for your response. Here is the diagnostic info. The service account works when trying to access Big Query from other sources such as databricks.