Connect to your Data
Connection Strategies
Rill offers flexible connection strategies to fit different data architectures and requirements.
-
Rill Managed OLAP + Data Ingestion (Default):
Use Rill's embedded ClickHouse / DuckDB (depending on size of data) as the OLAP engine and ingest data from external sources. Full Rill functionality is available with some caveats depending on which embedded engine you select.
Rill Defaults with DuckDBWhen starting Rill for the first time, Rill will auto-populate the connector with a
duckdb.yaml. To use ClickHouse, create a managed ClickHouse connector by selecting "Add Data", then ClickHouse, and finally "Rill-managed ClickHouse" in the UI. For more information, see Rill Managed ClickHouse. -
Bring Your Own OLAP (BYO OLAP):
For large-scale datasets (100GB+) or existing OLAP infrastructure, connect to existing ClickHouse, Druid, Pinot, or MotherDuck instances. Use Rill's "live connectors" to ingest data directly into your OLAP engines.
OLAP Engines
DuckDB
ClickHouse
MotherDuck
Druid
Pinot
Rill is continually evaluating additional OLAP engines that can be added. For a full list of OLAP engines that we support, refer to our OLAP Engines page. If you don't see an OLAP engine that you'd like to use, please don't hesitate to reach out!
Data Warehouses
Athena
BigQuery
Redshift
Snowflake
Databases
MySQL
PostgreSQL
SQLite
Object Storage
Amazon S3
Google Cloud Storage
Microsoft Azure Blob Storage
Other Data Connectors
Google Sheets
HTTPS
Local File
Salesforce
We're constantly adding new data connectors. If you don't see what you need, let us know and we'll help you get connected.
