Data Sources - Cube — ContextQMD

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

<CardGroup cols={3}> <Card title="Amazon Redshift" icon="brand-aws" href="/admin/connect-to-data/data-sources/aws-redshift"> Connect to Amazon Redshift. </Card> <Card title="Google BigQuery" icon="brand-google-big-query" href="/admin/connect-to-data/data-sources/google-bigquery"> Connect to Google BigQuery. </Card> <Card title="Snowflake" icon="brand-snowflake" href="/admin/connect-to-data/data-sources/snowflake"> Connect to Snowflake. </Card> <Card title="Databricks" icon="brand-databricks" href="/admin/connect-to-data/data-sources/databricks-jdbc"> Connect to Databricks. </Card> <Card title="Microsoft Fabric" icon="brand-windows" href="/admin/connect-to-data/data-sources/ms-fabric"> Connect to Microsoft Fabric. </Card> <Card title="ClickHouse" icon="database" href="/admin/connect-to-data/data-sources/clickhouse"> Connect to ClickHouse. </Card> <Card title="SingleStore" icon="database" href="/admin/connect-to-data/data-sources/singlestore"> Connect to SingleStore. </Card> <Card title="Apache Pinot" icon="database" href="/admin/connect-to-data/data-sources/pinot"> Connect to Apache Pinot. </Card> <Card title="Firebolt" icon="flame" href="/admin/connect-to-data/data-sources/firebolt"> Connect to Firebolt. </Card> <Card title="Vertica" icon="database" href="/admin/connect-to-data/data-sources/vertica"> Connect to Vertica. </Card> </CardGroup>

Query engines

<CardGroup cols={3}> <Card title="Amazon Athena" icon="brand-aws" href="/admin/connect-to-data/data-sources/aws-athena"> Connect to Amazon Athena. </Card> <Card title="DuckDB / MotherDuck" icon="database" href="/admin/connect-to-data/data-sources/duckdb"> Connect to DuckDB or MotherDuck. </Card> <Card title="Hive / SparkSQL" icon="database" href="/admin/connect-to-data/data-sources/hive"> Connect to Hive or SparkSQL. </Card> <Card title="Presto" icon="database" href="/admin/connect-to-data/data-sources/presto"> Connect to Presto. </Card> <Card title="Trino" icon="database" href="/admin/connect-to-data/data-sources/trino"> Connect to Trino. </Card> </CardGroup>

Transactional databases

<CardGroup cols={3}> <Card title="Postgres" icon="database" href="/admin/connect-to-data/data-sources/postgres"> Connect to Postgres. </Card> <Card title="Microsoft SQL Server" icon="brand-windows" href="/admin/connect-to-data/data-sources/ms-sql"> Connect to Microsoft SQL Server. </Card> <Card title="MySQL" icon="brand-mysql" href="/admin/connect-to-data/data-sources/mysql"> Connect to MySQL. </Card> <Card title="Oracle" icon="oval-vertical" href="/admin/connect-to-data/data-sources/oracle"> Connect to Oracle. </Card> <Card title="SQLite" icon="database" href="/admin/connect-to-data/data-sources/sqlite"> Connect to SQLite. </Card> </CardGroup>

Time series & streaming

<CardGroup cols={3}> <Card title="QuestDB" icon="clock-hour-4" href="/admin/connect-to-data/data-sources/questdb"> Connect to QuestDB. </Card> <Card title="ksqlDB" icon="ripple" href="/admin/connect-to-data/data-sources/ksqldb"> Connect to ksqlDB. </Card> <Card title="Materialize" icon="ripple" href="/admin/connect-to-data/data-sources/materialize"> Connect to Materialize. </Card> <Card title="RisingWave" icon="ripple" href="/admin/connect-to-data/data-sources/risingwave"> Connect to RisingWave. </Card> </CardGroup>

Other data sources

<CardGroup cols={3}> <Card title="Elasticsearch" icon="brand-elastic" href="/admin/connect-to-data/data-sources/elasticsearch"> Connect to Elasticsearch. </Card> <Card title="MongoDB" icon="leaf" href="/admin/connect-to-data/data-sources/mongodb"> Connect to MongoDB. </Card> <Card title="Druid" icon="database" href="/admin/connect-to-data/data-sources/druid"> Connect to Apache Druid. </Card> <Card title="Parquet" icon="file" href="/admin/connect-to-data/data-sources/duckdb"> Query Parquet files via DuckDB. </Card> <Card title="CSV" icon="file-type-csv" href="/admin/connect-to-data/data-sources/duckdb"> Query CSV files via DuckDB. </Card> <Card title="JSON" icon="braces" href="/admin/connect-to-data/data-sources/duckdb"> Query JSON files via DuckDB. </Card> </CardGroup>

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:

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.