There are 2 ways to authenticate to Google Cloud with Retool
- Service account
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.
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
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: