BigQuery Integration

Connect BigQuery to Retool.

Retool’s BigQuery integration lets query, join, and edit data in a BigQuery data warehouse. This page explains how to set up your BigQuery database as a Retool Resource and query your data.

1. Prerequisites

First, you need to get Google Cloud credentials for authentication. For Service Account authentication, follow Google's documentation to obtain your private key.

2. Add a BigQuery resource

Create a new resource in Retool and select BigQuery.

Add a name for your BigQuery integration and set up authentication. Retool supports connecting to BigQuery with Service Accounts and with OAuth. For Service Accounts, enter your Service Account key. For OAuth, enter your Project's ID and your Client ID and Secret pair.

3. Create queries

You can now select the BigQuery resource from the Select Resource dropdown when creating queries in your Retool apps. You can toggle between SQL mode for raw SQL statements and the GUI mode for structured writes.

After queries complete, you can display the results in Retool: