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 herelink 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
Otherfor your application type.
Click here to get an auth codewhich will open a new browser window and authorize your credentials for a BigQuery access token to use the api. Simply click the
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]