# Triagic + BigQuery: ticket investigations over your database, read-only

> BigQuery in Triagic: Query datasets and inspect table schemas. Read-only, with a credential you configure.

Source: https://triagic.com/integrations/bigquery

## What you can ask

- Look up account acme-labs in BigQuery and tell me why their last export failed
- In BigQuery, how many orders for org 8412 are stuck in a non-terminal state right now?
- Which rows in BigQuery changed for user 51930 in the last 24 hours?
- Compare the BigQuery record for invoice INV-2291 with what the customer says they see
- Does BigQuery show the same plan for this account as the billing system does?

## What the agent can do

- `list-tables`
- `describe-table`

## Connect in three steps

1. **Mint a read-only credential in BigQuery.** Create a dedicated user or token that can only read. Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary.
2. **Add it in the Triagic portal.** Integrations, then Add shared data source, then BigQuery. Fill in: Project ID (required); Location (required): Where the datasets live: a multi-region (US, EU) or a region like europe-west9.
3. **Let a desktop pick it up.** Saving validates the shape of what you typed. The first desktop app to sync starts BigQuery locally and reports running or degraded with the error text.

Setup reference: https://triagic.com/docs/integrations/databases#bigquery

## Read-only, by construction

Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary.

## FAQ

**Can Triagic change anything in BigQuery?**
No. Only list-tables and describe-table are exposed; the SQL tool is not, and the service account's Data Viewer and Job User roles are the boundary. Give it a read-only credential as well, so the guarantee does not rest on one layer.

**What do I need to connect BigQuery?**
Project ID, Location. The desktop app on a member's machine starts the connection; the portal never holds a live process.

**Does BigQuery cost extra?**
No. Every connector is included in the seat price. Start a 14-day trial without a card.

## Related integrations

- [MongoDB](https://triagic.com/integrations/mongodb)
- [PostgreSQL](https://triagic.com/integrations/postgres)
- [MySQL](https://triagic.com/integrations/mysql)
- [Redis](https://triagic.com/integrations/redis)