Loading…
Chat with BigQuery in plain English — serverless, petabyte-scale.
iDBQuery's BigQuery connector turns Google's serverless data warehouse into a conversational analytics surface. Provide your Google Cloud project ID and upload a service-account JSON key with at least `roles/bigquery.dataViewer` on the datasets you want exposed and `roles/bigquery.jobUser` on the project. Schema introspection runs immediately across every dataset the service account can see — tables, views, materialized views, partitioned tables, clustered tables, columns, data types, and the partition/cluster keys themselves. The AI uses that map to write standard SQL that respects partitions and clustering, which keeps scan bytes (and your bill) low. Every chat question becomes a safe parametrized SELECT, executed against BigQuery on demand, and returned as a chart, table, stat card, or dashboard. BigQuery-specific features — `STRUCT` and `ARRAY` flattening with `UNNEST`, `QUALIFY`, window functions, `_PARTITIONTIME` and `_PARTITIONDATE` filters, geography functions, ML.PREDICT against existing models — are all in the model's vocabulary. The service-account JSON is encrypted at rest with strong symmetric encryption, used only at query time, and never returned by any API. The free tier — 1M tokens per month, three sources, five reports, no credit card — lets you wire BigQuery up and validate the workflow before committing. iDBQuery makes petabyte-scale BigQuery data accessible to your whole team.
Everything iDBQuery's Google BigQuery connector supports out of the box.
Project → Add source → BigQuery.
Enter the Google Cloud project ID where your datasets live (and where query jobs will be billed).
In the GCP console, create a service account with `roles/bigquery.dataViewer` on the datasets you want exposed and `roles/bigquery.jobUser` on the project. Download a JSON key.
Upload the service-account JSON file in iDBQuery. The key bytes are encrypted at rest.
Ask 'Show daily ad spend by channel for the past 90 days' — the AI writes the SQL and renders the chart.
Free tier covers most teams. No credit card.
No credit card required · 1M tokens / month free