Data Sources

Choose and configure a data warehouse, query engine, or other data source to connect to Cube.

Cube connects directly to your data warehouse or database. Select your data source below to get started with the setup process.

You can also connect multiple data sources at the same time and adjust the concurrency settings for data sources.

Data warehouses

Amazon Redshift

Connect to Amazon Redshift.

Google BigQuery

Connect to Google BigQuery.

Snowflake

Connect to Snowflake.

Databricks

Connect to Databricks.

Microsoft Fabric

Connect to Microsoft Fabric.

ClickHouse

Connect to ClickHouse.

SingleStore

Connect to SingleStore.

Apache Pinot

Connect to Apache Pinot.

Firebolt

Connect to Firebolt.

Vertica

Connect to Vertica.

Query engines

Amazon Athena

Connect to Amazon Athena.

DuckDB / MotherDuck

Connect to DuckDB or MotherDuck.

Hive / SparkSQL

Connect to Hive or SparkSQL.

Presto

Connect to Presto.

Trino

Connect to Trino.

Transactional databases

Postgres

Connect to Postgres.

Microsoft SQL Server

Connect to Microsoft SQL Server.

MySQL

Connect to MySQL.

Oracle

Connect to Oracle.

SQLite

Connect to SQLite.

Time series & streaming

QuestDB

Connect to QuestDB.

ksqlDB

Connect to ksqlDB.

Materialize

Connect to Materialize.

RisingWave

Connect to RisingWave.

Other data sources

Elasticsearch

Connect to Elasticsearch.

MongoDB

Connect to MongoDB.

Druid

Connect to Apache Druid.

Parquet

Query Parquet files via DuckDB.

CSV

Query CSV files via DuckDB.

JSON

Query JSON files via DuckDB.

API endpoints

Cube is designed to work with data sources that allow querying them with SQL.

Cube is not designed to access data files directly or fetch data from REST, or GraphQL, or any other API. To use Cube in that way, you either need to use a supported data source (e.g., use DuckDB to query Parquet files on Amazon S3) or create a custom data source driver.

Data source drivers

Driver support

Most of the drivers for data sources are supported either directly by the Cube team or by their vendors. The rest are community-supported and will be highlighted as such in their respective pages.

You can find the source code of the drivers that are part of the Cube distribution in cubejs-*-driver folders on GitHub.

Third-party drivers

The following drivers were contributed by the Cube community. They are not part of the Cube distribution, however, they can still be used with Cube:

• ArangoDB
• CosmosDB
• CrateDB
• Dremio
• Dremio ODBC
• OpenDistro Elastic
• SAP Hana
• Trino
• Vertica

You need to configure driver_factory to use a third-party driver.

Currently unsupported data sources

If you’d like to connect to a data source which is not yet listed on this page, please see the list of requested drivers and file an issue on GitHub.

You’re more than welcome to contribute new drivers as well as new features and patches to existing drivers. Please check the contribution guidelines and join the #contributing-to-cube channel in our Slack community.