Can I connect Google BigQuery to iDBQuery?

Yes — iDBQuery connects to Google BigQuery as a standard SQL data warehouse using its warehouse/database connector. You supply your project, dataset and a service-account credential, iDBQuery reads the schema, and BigQuery joins one live queryable model you can ask in plain English. No copy or pipeline required.

BigQuery connects through iDBQuery's standard warehouse/database connector — the same path used for any SQL warehouse — so there's no special build or ETL step.

  • You'd connect BigQuery by pointing iDBQuery at your project and dataset and authenticating with a service-account key that has read access.
  • iDBQuery introspects the datasets and tables, uses its semantic layer to interpret column names, and adds BigQuery to your one live queryable model.
  • Ask something like *"How many active users did we have by plan tier this month?"* and iDBQuery generates the SQL, runs it in BigQuery, and hands back a cited number, chart or dashboard.

What sets it apart from exporting BigQuery into yet another BI tool: iDBQuery queries in place and cites every figure back to its source rows, so you can trace an answer straight back to the underlying data. Because BigQuery becomes part of one model, you can ask a single question that spans BigQuery plus a Postgres database, an Excel file or a CRM pulled over the REST API connector — iDBQuery joins them for you with no staging tables. Deploy in the cloud, your own VPC, or air-gapped, and the same connection details apply.

Updated 2026-06-22