Today, cloud data warehouse (CDW) solutions are changing the way we deliver modern analytics. They can provision any size data warehouse in minutes, auto-tune queries, scale resources such as compute and storage based on demand, and automatically upgrade to the latest version. To address the growing need for more integrated, real-time, and self-service analytics, CDW vendors continue to focus on native integration with data lakes and object stores; self-service to simplify access and administration for larger and more complex warehouses; and advanced capabilities on parallel processing, compression, partitioning, indexing, query optimization, and dynamic resource provisioning. The most common CDW use cases include customer analytics, AI/machine learning (ML)-based analytics, vertical-specific analytics, and real-time analytics.
Google (BigQuery), Microsoft (Azure Synapse Analytics ), Amazon Web Services (Redshift), Teradata (Teradata Vantage in the Cloud ), Oracle (Oracle Autonomous Data Warehouse) & Snowflake (Snowflake Data Cloud ) are the leaders in “The Forrester Wave™: Cloud Data Warehouse, Q1 2021”.