Can I connect Firebase Firestore to iDBQuery?
Not as a native connection — Firestore is a NoSQL document database, not a SQL store. To analyse Firestore data with iDBQuery, export it to CSV or BigQuery, or read it through an API, and iDBQuery will query that in plain language with cited answers.
iDBQuery natively connects to SQL databases, spreadsheets, files, documents, REST APIs, and SQL data warehouses. Firebase Firestore is a NoSQL document database built for app back-ends, so it isn't a native SQL connection — but its data is straightforward to analyse with iDBQuery.
Good paths:
- Firestore-to-BigQuery — Firebase's built-in extension streams Firestore collections into BigQuery. iDBQuery connects to BigQuery as a SQL warehouse, giving you live, cited analytics with no custom pipeline.
- Export to CSV/JSON — export the collections you care about and point iDBQuery at those files.
- Read through an API — if your app exposes Firestore data as JSON over REST, connect iDBQuery to that API.
Once the data is in iDBQuery's model you get plain-language questions, generated SQL, charts, dashboards, and cited answers tracing every figure to its source.
The real value is unifying app data with business data: blend Firestore-derived tables with a Postgres database or a spreadsheet in one live model, so you can answer questions across your product and your operations at once.
Example: a mobile app stores usage in Firestore and exports it to BigQuery via the Firebase extension. The team connects iDBQuery to BigQuery and asks 'which features do paying users open most in their first week?' — a cited chart in seconds, no analyst required.
Updated 2026-06-22