Starting in v0.15.0 Metabase provides a driver for connecting to BigQuery directly and executing queries against any datasets you have. The below sections provide information on how to get connected and troubleshoot any issues that may come up.
Click here
link provided below the Client ID field which will open a new browser tab and guide you through the process of generating OAuth 2.0 credentials for Metabase. Make sure to choose Other
for your application type.
Click here to get an auth code
which will open a new browser window and authorize your credentials for a BigQuery access token to use the api. Simply click the Allow
button.
Save
button!Metabase will now begin inspecting your BigQuery Dataset and finding any tables and fields to build up a sense for the schema. Give it a little bit of time to do its work and then you're all set to start querying.
As of version 0.30.0, Metabase tells BigQuery to interpret SQL queries as Standard SQL. If you prefer using Legacy SQL instead, you can tell Metabase to do so by including a #legacySQL
directive at the beginning of your query, for example:
#legacySQL
SELECT *
FROM [my_dataset.my_table]
Can you improve this documentation? These fine people already did:
Cam Saul, Cam Saül & Allen GillilandEdit on GitHub
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close