Cloud data warehouses
Snowflake
Enterprise data warehouse with automatic scaling
BigQuery
Google’s serverless data warehouse
Databricks
Unified analytics platform on the lakehouse
AWS Redshift
Amazon’s cloud data warehouse
Relational databases
PostgreSQL
Popular open-source relational database
MySQL
World’s most popular open-source database
MS SQL
Microsoft SQL Server
Oracle
Enterprise relational database
OLAP & analytics
ClickHouse
Column-oriented OLAP database
DuckDB
In-process analytical database
Apache Druid
Real-time analytics database
Connecting a data source
To connect a data source, set theCUBEJS_DB_TYPE environment variable: