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
You may need to whitelist both Quadratic IP addresses to make connections, which are:
44.240.255.40
54.68.134.35
* These IP addresses do not apply to self-hosted instances
If you need help setting up your data sources, contact us. Some extra resources and instructions vary depending on where your database lives.
