Cloud Databases

Cloud Data Warehouse Comparison

Advance Analytical Functions	Snowflake	AWS Redshift	Google Bigquery	Databricks	Oracle	Exasol	Mysql Heatwave
MATCH_RECOGNIZE	✅	❌	❌	❌	✅	❌	❌
QUALIFY	✅	✅	✅	✅	✅	✅	❌
SKYLINE	❌	❌	❌	❌	❌	✅	❌
GRAPH_TABLE	❌	❌	❌	❌	✅	❌	❌
MIN_BY / MAX_BY	✅	❌	✅	✅	❌	❌	❌
GROUP BY CUBE	✅	❌	✅	✅	✅	✅	❌
GROUP BY ROLLUP	✅	❌	✅	✅	✅	✅	❌
GROUP BY GROUPING SETS	✅	❌	✅	✅	✅	✅	❌
CONDITIONAL_TRUE_EVENT	✅	❌	❌	❌	❌	❌	❌
CONDITIONAL_CHANGE_EVENT	✅	❌	❌	❌	❌	❌	❌
RATIO_TO_REPORT	✅	✅	❌	❌	✅	✅	❌
IS DISTINCT FROM	✅	❌	✅	✅	❌	❌	❌
IS NOT DISTINCT FROM	✅	❌	✅	✅	❌	❌	❌
ASOF join	✅	❌	✅	❌	❌	❌	❌
SQL ASOF join	✅	❌	✅	❌	❌	❌	❌
RANGE_SESSIONIZE	❌	❌	✅	❌	❌	❌	❌
User Defined Aggregate Functions (UDAF)	✅	❌	✅	❌	❌	❌	❌
Dynamic PIVOT	✅	❌	❌	❌	✅	❌	❌

This site is open source. Improve this page.