Can I connect ClickHouse to iDBQuery?

ClickHouse is a fast columnar database built for analytical queries over huge event and log datasets, and iDBQuery connects to it as a standard SQL source through its database connector. You supply the connection details, iDBQuery introspects the tables, and the semantic layer helps map raw event schemas to business language.

What that gives you:

• Plain-language analytics — 'daily active users by country over the last 30 days' — with iDBQuery writing and running the ClickHouse SQL for you.
• Cited answers — every number is traceable to the underlying ClickHouse rows.
• No pipeline — you don't need to move ClickHouse data into a separate BI warehouse; iDBQuery queries it live.

Because ClickHouse often holds billions of rows, iDBQuery pushes the aggregation down to ClickHouse (which is exactly what it's optimised for) and returns just the result — a number, chart, or live dashboard — so answers stay fast.

Example: a product team stores clickstream events in ClickHouse. Instead of asking an analyst to write another query, the PM asks 'which onboarding step has the biggest drop-off this month?' and gets an instant funnel chart, each figure cited.

You can also blend ClickHouse with your application database or a spreadsheet in one answer — one live model across sources, no ETL required.