Connecting to data sources

Choose a data source to get started with below.

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

Data warehouses

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/aws-redshift" imageUrl="https://static.cube.dev/icons/redshift.svg" title="Amazon Redshift" /> <GridItem url="data-sources/google-bigquery" imageUrl="https://static.cube.dev/icons/bigquery.svg" title="Google BigQuery" /> <GridItem url="data-sources/snowflake" imageUrl="https://static.cube.dev/icons/snowflake.svg" title="Snowflake" /> <GridItem url="data-sources/databricks-jdbc" imageUrl="https://static.cube.dev/icons/databricks.svg" title="Databricks" /> <GridItem url="data-sources/ms-fabric" imageUrl="https://static.cube.dev/icons/ms-fabric-light.svg" title="Microsoft Fabric" /> <GridItem url="data-sources/clickhouse" imageUrl="https://static.cube.dev/icons/clickhouse.svg" title="ClickHouse" /> <GridItem url="data-sources/singlestore" imageUrl="https://static.cube.dev/icons/singlestore-light.svg" title="SingleStore" /> <GridItem url="data-sources/pinot" imageUrl="https://static.cube.dev/icons/pinot-light.svg" title="Apache Pinot" /> <GridItem url="data-sources/firebolt" imageUrl="https://static.cube.dev/icons/firebolt.svg" title="Firebolt" /> <GridItem url="data-sources/vertica" imageUrl="https://static.cube.dev/icons/vertica.svg" title="Vertica" /> </Grid>

Query engines

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/aws-athena" imageUrl="https://static.cube.dev/icons/athena.svg" title="Amazon Athena" /> <GridItem url="data-sources/duckdb" imageUrl="https://static.cube.dev/icons/duckdb-light.svg" title="DuckDB / MotherDuck" /> <GridItem url="data-sources/hive" imageUrl="https://static.cube.dev/icons/hive.svg" title="Hive / SparkSQL" /> <GridItem url="data-sources/presto" imageUrl="https://static.cube.dev/icons/presto.svg" title="Presto" /> <GridItem url="data-sources/trino" imageUrl="https://static.cube.dev/icons/trino.svg" title="Trino" /> </Grid>

Transactional databases

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/postgres" imageUrl="https://static.cube.dev/icons/postgres.svg" title="Postgres" /> <GridItem url="data-sources/ms-sql" imageUrl="https://static.cube.dev/icons/ms-sql.svg" title="Microsoft SQL Server" /> <GridItem url="data-sources/mysql" imageUrl="https://static.cube.dev/icons/mysql.svg" title="MySQL" /> <GridItem url="data-sources/oracle" imageUrl="https://static.cube.dev/icons/oracle.svg" title="Oracle" /> <GridItem url="data-sources/sqlite" imageUrl="https://static.cube.dev/icons/sqlite.svg" title="SQLite" /> </Grid>

Time series databases

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/questdb" imageUrl="https://static.cube.dev/icons/questdb.svg" title="QuestDB" /> </Grid>

Streaming

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/ksqldb" imageUrl="https://static.cube.dev/icons/ksql.svg" title="ksqlDB" /> <GridItem url="data-sources/materialize" imageUrl="https://static.cube.dev/icons/materialize.svg" title="Materialize" /> <GridItem url="data-sources/risingwave" imageUrl="https://static.cube.dev/icons/risingwave.svg" title="RisingWave" /> </Grid>

Other data sources

<Grid imageSize={[56, 56]}> <GridItem url="data-sources/elasticsearch" imageUrl="https://static.cube.dev/icons/elasticsearch.svg" title="Elasticsearch" /> <GridItem url="data-sources/mongodb" imageUrl="https://static.cube.dev/icons/mongo.svg" title="MongoDB" /> <GridItem url="data-sources/druid" imageUrl="https://static.cube.dev/icons/druid.svg" title="Druid" /> <GridItem url="data-sources/duckdb" imageUrl="https://static.cube.dev/icons/parquet.svg" title="Parquet" /> <GridItem url="data-sources/duckdb" imageUrl="https://static.cube.dev/icons/csv.svg" title="CSV" /> <GridItem url="data-sources/duckdb" imageUrl="https://static.cube.dev/icons/json.svg" title="JSON" /> </Grid>

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.

<InfoBox>

You can contact us to discuss an integration with a currently unsupported data source. We might be able to assist Cube Cloud users on the Enterprise Premier plan.

</InfoBox>