Start building
BigQuery Google

Use BigQuery in your Crisp app.

Run SQL on datasets in BigQuery.

With a service account key your app can run SQL queries against your BigQuery datasets, show the results in tables and charts, and load new rows. Give the service account the BigQuery Job User and BigQuery Data Viewer roles, and Data Editor only when the app writes.

Start building How to connect

What you need.

Create the keys in your BigQuery account and paste them in. Each one is saved under the name shown, and your app reads it by that name.

Service account key
BIGQUERY_SERVICE_ACCOUNT_KEY
console.cloud.google.com, IAM, Service accounts, your account, Keys, Add key, JSON. Paste the whole downloaded file
Project id
BIGQUERY_PROJECT_ID
console.cloud.google.com, project picker, the ID column. The project the queries are billed to, like my-project-123456 Get it
Default dataset optional
BIGQUERY_DATASET
console.cloud.google.com, BigQuery, Explorer. The dataset name under the project Get it
Location optional
BIGQUERY_LOCATION
The dataset's location shown on its details page. US when empty, EU or a region like europe-west2

Get your keys BigQuery docs

How to connect.

  1. Open your project, or start a new one from the dashboard.

  2. Open the workspace menu and choose Connectors, then pick BigQuery.

  3. Paste the keys and save. Your preview restarts, and your app can use the service from then on.

Then ask for the feature

  • “Chart daily orders from the sales dataset”
  • “Let analysts run saved queries and export the result”

What happens to your keys.

  • Each key is saved as a private setting of your project, under the name shown above.
  • The AI that builds your app sees only the names. It writes code that reads each key by name, and never the value.
  • The values reach your preview and your published app, and never the chat, the code or the logs.
  • Open Connectors in your project to replace a key or disconnect the service. Publish again so your live app uses the change.

Service names and logos belong to their owners; Crisp is not affiliated with them. A service changes its keys and pages now and then. Found something out of date? Tell us and we will correct it.

Ask for the feature, and Crisp builds it with BigQuery.

Free plan with $3 of AI usage a month, no credit card. Pro is $20 a month. See pricing.

Start free See pricing

No credit card. Your code and data stay yours.