Can I connect a data warehouse to iDBQuery?
Yes. If your warehouse speaks a standard SQL connection, iDBQuery connects read-only, introspects its schema, and lets you ask questions in plain language with cited answers. But many teams find they don't need a warehouse at all — iDBQuery queries source databases and files directly in one model.
iDBQuery can connect to a SQL-accessible data warehouse the same way it connects to any relational database: a read-only connection, automatic schema introspection, and plain-language querying with cited answers.
- Read-only and automatic — your warehouse schema is introspected on connect, so you can question it immediately.
- Cited results — every figure traces back to the underlying rows, even across large warehouse tables.
- Semantic layer — wide, cryptic warehouse schemas are made approachable with plain-language meaning on top of table and column names.
That said, a big reason teams choose iDBQuery is to avoid the cost and delay of a warehouse in the first place. iDBQuery builds one live queryable model directly from your operational databases, spreadsheets, PDFs and APIs — no central warehouse, no ETL pipelines, no nightly loads. You query the sources in place and get current answers.
So you have two paths: connect an existing warehouse if you already have one, or skip it entirely and let iDBQuery federate your sources directly. Both give you the same conversational, cited experience.
Updated 2026-06-22