Database Credentials > Google BigQuery

Draxlr connects to Google BigQuery using a service account key (a JSON file) and your project ID.

---

Create a Service Account Key

1: Open Service Accounts

In the Google Cloud Console, select your project and go to IAM & Admin → Service Accounts.

---

2: Create a Service Account

Click Create service account, give it a name (e.g., draxlr), and click Create and continue.

---

3: Grant BigQuery Roles

Grant the service account these roles:

• BigQuery Data Viewer — read access to your datasets
• BigQuery Job User — permission to run queries

Click Done.

---

4: Download the JSON Key

1. Open the service account you just created.
2. Go to the Keys tab.
3. Click Add key → Create new key, choose JSON, and click Create.

The key file downloads to your computer—this is what you provide to Draxlr.

---

5: Note Your Project ID

Your Project ID is shown in the console's project picker, and also inside the downloaded JSON file (the project_id field).

---

IP Allowlisting

Not required—BigQuery is accessed through Google's public APIs over TLS.

---

Connect in Draxlr

Go to Add Database, select BigQuery, and provide the service account key and project ID. See the Setup guide for the full connection flow.