Can I connect Databricks to iDBQuery?
Yes — iDBQuery connects to a Databricks SQL warehouse as a standard SQL data warehouse via its warehouse/database connector. You supply the workspace host, SQL warehouse/HTTP path and an access token, iDBQuery introspects the schema, and Databricks joins one live queryable model you ask in plain language.
Databricks connects to iDBQuery as a standard SQL warehouse — through the warehouse/database connector against a Databricks SQL warehouse endpoint, not a proprietary integration.
- You'd connect Databricks by entering the workspace hostname, the SQL warehouse HTTP path and a personal access token (or service principal) with read access to the catalogs you need.
- iDBQuery introspects the Unity Catalog schemas, tables and columns, applies its semantic layer to interpret naming, and adds Databricks to your one live queryable model.
- Ask something like *"What's our 30-day retention by cohort?"* and iDBQuery generates the SQL, runs it on the SQL warehouse, and returns a cited number, chart or live dashboard.
What's different from building yet another notebook or dashboard on top of Databricks: iDBQuery lets any stakeholder ask in plain language, queries the lakehouse in place, and cites every figure back to its exact source rows so answers are auditable rather than opaque. Databricks can be combined in a single question with an operational Postgres database, a spreadsheet or a SaaS source over the REST API connector — one model, no extra pipeline. Deploy iDBQuery in your cloud, your own VPC, or air-gapped, using the same connection details.
Updated 2026-06-22