Data sources are connected in the “Data Sources” section of the web interface: creating, connection checks, source details. Three database engines are supported — SQLite, PostgreSQL and ClickHouse.
Source types
- SQLite — path to the database file, timeout (30 s by default), read-only mode;
- PostgreSQL — host, port (5432), database, login, password, SSL, timeout;
- ClickHouse — host, HTTP port (8123), database, login, password, SSL, timeout.
Schema and result caching
- schema auto-detection (
autoDetect) — tables and columns are picked up automatically; - periodic schema refresh — by default once every 3600 seconds;
- table caching (
cacheTables) — the schema is not requested anew for every report; - caching of query results with statistics and cleanup — details in the Queries section.
Validation
DataSourceValidationService checks source availability: connection errors are visible before reports are built, not on a broken dashboard. A non-existent source in a block query is caught by the validator (DATA_SOURCE_NOT_FOUND).
File data without setup
If your data lives in files — Parquet, SQLite, Markdown — you don’t need to configure a source: put the files into the Lakehouse folder and query them right from the file browser. Details in the Lakehouse section.
A SQLite file in the root of the Lakehouse folder is discovered automatically and shown as a ready source: it is marked with a “lakehouse” icon in the list, and the connection is read-only. You don’t need to configure anything; if you want your own variant, create a regular source with the same name — your setting takes priority over the discovered one.