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