Analytics Workspace

The Analytics Workspace bridges the gap between all your data sources. You can attach databases, local files, S3 data & more - and then query all at once, as if everything was a single database.

For example, you can easily join data from a local CSV file with data from your PostgreSQL database:

Sources overview screenshot

The Analytics Workspace is powered by a ClickHouse database that is embedded into the DB Pilot app.

Noteworthy mention: Embedding ClickHouse into the DB Pilot app is made possible by chDB.