Skip to main content

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 DuckDB
When 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

ClickHouse

Databricks

Druid

DuckDB

DuckLake

Google BigQuery

MotherDuck

Pinot

Snowflake

StarRocks

High-performance columnar database for real-time analytics and data warehousing.

Lakehouse platform with native support for metrics views as a live connector.

Real-time analytics database designed for high-performance OLAP queries.

DuckDB is the default engine for Rill Developer.

Open lakehouse format built on DuckDB — catalog in SQL, data in Parquet.

Connect to Google BigQuery for analytics and data warehousing with service account authentication.

Cloud-native DuckDB service for scalable analytics and data processing.

Distributed OLAP datastore for real-time analytics and business intelligence.

Cloud data warehouse with native support for metrics views as a live connector.

Distributed OLAP datastore for real-time analytics and business intelligence.

Missing an OLAP Engine?

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

Databricks

Redshift

Snowflake

Databases

MySQL

PostgreSQL

SQLite

Supabase

Connect to MySQL databases with support for various authentication methods and SSL connections.

Connect to PostgreSQL databases with support for SSL connections and various authentication methods.

Connect to SQLite databases for lightweight, file-based data storage and querying.

Connect to Supabase's managed PostgreSQL databases with SSL support and standard connection methods.

Object Storage

Amazon S3

Google Cloud Storage

Microsoft Azure Blob Storage

Connect to Amazon S3 buckets to read data files including CSV, JSON, Parquet, and compressed formats.

Google Cloud Storage provides scalable object storage and data lakes.

Connect to Microsoft Azure Blob Storage to read data files with support for various formats.

Table Formats

Delta Lake

Apache Iceberg

Read Delta tables directly from object storage through compatible query engines.

Read Iceberg tables directly from object storage through compatible query engines.

Other Data Connectors

External DuckDB

Google Sheets

HTTPS

Local File

Salesforce

Attach your local DuckDB database to Rill's embedded database.

Connect to public Google Sheets to read data from spreadsheets with support for multiple sheets.

https://

Download data from HTTP/HTTPS URLs with support for various authentication methods.

Read data from local files including CSV, JSON, Parquet, and compressed formats.

Connect to Salesforce to extract data from objects and queries using the Salesforce API.

Missing a connector?

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.

Service Integrations

Claude

Gemini

OpenAI

Slack

Create and define a Claude Connector with your own API key.

Create and define a Gemini Connector with your own API key.

Create and define an OpenAI Connector with your own API key.

Connect to Slack to send alerts and messages from Rill.