Hi,
We are using free version of Metabase [v-0.40.1]. We are running Metabase Docker container on a GCP VM with default database[H2].
In our GCP Organization we have two projects - network-project & data-project. We have all network related activities defined in network-project [No internet access, Only internal IPs enabled, no external IPs etc.]
We have a jump box [VM within data-project] through which we are accessing Metabase UI. When we go for configuring Metabase to access Bigquery within the same project. It gives us time-out error and doesnt return any result.
On the same VM - we are able to access Bigquery using "bq command" line tool but yes "REST API" based call is throwing error [Access Denied].
When we looked into the Metabase code [src], we are not able to figure out how actually Metabase is trying to access bigquery - does it also use REST API for this purpose? If yes can you please provide us the final URL which it creates ? is it similar to http://www.googleapis.com/bigquery/v2/projects/$PROJECT/queries
If yes then how does it authorize this interaction? is it using oAuth2? [like - https://www.googleapis.com/oauth2/v2/tokeninfo].
Just to mention here the service account which we are using is having all required permissions which are needed for accessing bigquery from Metabase UI. [as suggested by metabase documentation]