Amazon Redshift announces general availability of ROLLUP, CUBE, and GROUPING SETS in GROUP BY clause
Amazon Redshift now supports new SQL functionalities including ROLLUP, CUBE, and GROUPING SETS, to simplify building multi-dimensional analytics applications. ROLLUP, CUBE, and GROUPING SETS simplifies data warehouse migrations by offering the commonly used syntax across databases.
Amazon Redshift now supports new SQL functionalities including ROLLUP, CUBE, and GROUPING SETS, to simplify building multi-dimensional analytics applications. ROLLUP, CUBE, and GROUPING SETS simplifies data warehouse migrations by offering the commonly used syntax across databases.
Multi-dimensional analysis requires you to build complex processes and queries to aggregate and analyze core business facts such as revenue, and expense against multiple dimensions of your business metrics such as product category, geography, and time. Now, with a single SQL statement leveraging the ROLLUP, CUBE, and GROUPING SETS in the GROUP BY clause, you can get the same functionality, simplifying your ability to perform analytics with Amazon Redshift.
Support for ROLLUP, CUBE, and GROUPING SETS in the GROUP BY clause in all commercial and AWS GovCloud (US) regions where Amazon Redshift is available. You can find more information about ROLLUP/CUBE/GROUPING SETS from the Amazon Redshift database developers guide and blog.