BigQuery

You can create your BigQuery connection from either your team's dashboard or directly inside a spreadsheet. From the Dashboard, navigate to the Connections menu item. Or from inside a spreadsheet, press / and then Manage connections.

Connection details

To connect to your BigQuery database, you'll need to enter the parameters in the Team connections modal:

Connection name

You can name this whatever you'd like. This is the name you'll see in Quadratic any time you use the connection.

Project ID

This can be found in the project selector at the top of our Google Cloud Console. Do not mistake the project name for the ID; they can be the same but are often different. Make sure you select the ID from the list.

Dataset

Datasets can be found inside your BigQuery instance in the sidebar.

Service account configuration

Acquire your service account JSON key from the keys section under service accounts in Google Cloud Console.

IP allow-list

If you need help setting up your data sources, contact us. Some extra resources and instructions vary depending on where your database lives.