Connecting to BigQuery

You can connect your BigQuery project to Livedocs directly from the Data tab in your workspace.

How to Connect

1. Go to the Data tab in your workspace.
2. Click Connect a Database.
3. In the Database Type dropdown, select BigQuery.
4. Fill in the fields as shown below.
5. Click Connect to Database.

Connection Fields Explained

• Name – A friendly name for this connection (e.g., Marketing BQ).
• Project ID – Your Google Cloud Project ID.
• Service Account Key (JSON) – Paste the full contents of your BigQuery service account key here. It should include fields like project_id, client_email, and private_key.

Make sure the service account has permission to run queries (BigQuery Data Viewer) and access datasets.

Additional Options

• Allow Inserts and Updates – Enable this if you want Livedocs to write data to BigQuery tables.
• Don’t Have Credentials? – You can invite a teammate who has access to the BigQuery credentials to connect it for you.

Next Steps:

• Querying BigQuery in SQL Cells
• Managing Data Connections