Documentation

Welcome to Retool! We're a fast way to build custom internal software.

You'll find the 5 minute demo, quickstart guide, and documentation for each of our connectors and components here. If you've got any questions -- chat with us on the bottom right!

Get Started    Guides

BigQuery Integration

Connecting BigQuery to Retool

1. Get Google Cloud Credentials

There are 2 ways to authenticate to Google Cloud with Retool

  • Service account
  • OAuth

For Service Account authentication, follow Google's documentation here to obtain your private key: https://cloud.google.com/docs/authentication/getting-started.

For OAuth authentication, follow Google's documentation here to obtain your project ID: https://cloud.google.com/resource-manager/docs/creating-managing-projects.

2. Add to Retool

Create a new resource in Retool, and select "BigQuery" as the type. Enter a label by which you want to refer to this BigQuery integration. If you're using Service Account authentication, enter your service account private key in the box provided, and if you're using OAuth then enter your project ID. Press "Save" when you're done.
Resources > Add > BigQuery

3. Create Queries

You can now select your newly-created BigQuery resource from the Resource dropdown when creating queries in your Retool apps.

You can display the results of BigQuery queries as with any other query in Retool:

BigQuery Integration


Connecting BigQuery to Retool

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.