Bigquery end to end connection

Hi Everyone

I want to use Bigquery as a data source for Metabase.

The reason I want to use it because it will be able to blend my databases that are currently separated and I will be able to join them (correct me if I am wrong) on a per-query basis.

I have two blockers here:

  1. I want to understand how should I feed data from Metabase to bigquery
  2. How do I add Bigquery as a data source on metabase (Currently stuck on this error Not found: Dataset bigquery-cloud:BigQuery_Cloud_1)

Hi @ishan

Metabase supports BigQuery as data source. You might want to have a look at the documentation:
https://www.metabase.com/docs/latest/administration-guide/databases/bigquery.html

If you’re still having problems, then please post the “Diagnostic Info” from Admin > Troubleshooting, and any errors with details from Admin > Troubleshooting > Logs.

As for how to “feed data from Metabase to BigQuery” - that’s not possible. Metabase can read data from BigQuery, if you want to add/edit data on BigQuery, then you need to use other tools.

1 Like