Cloud Data Warehouse: Which solution is best?

Data warehouse platforms are an established part of the enterprise technology stable and a go-to solution for managing data at scale within an organisation. But recently, features have emerged that transform data warehouses from serving their more traditional technology role of the past into the modern, flexible, cloud-based big data platforms they are today.

Over 540,000 professionals have used Peerspot research to inform their purchasing decisions. Its latest paper looks at the highest rated cloud data warehouse vendors, profiling each and examining what they can offer enterprise.

Here’s a breakdown of the key players currently active in the market:

Amazon EMR

Average Rating: 7.0

Top Comparison: Cloudera Distribution for Hadoop

Overview: Simplifies big data processing, providing a managed Hadoop framework that makes it easy, fast, and cost-effective for businesses to distribute and process vast amounts of data across dynamically scalable Amazon EC2 instances.

Amazon Redshift

Average Rating: 7.6

Top Comparison: Snowflake

Overview: A fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud.

Azure Data Factory

Average Rating: 7.8

Top Comparison: Informatica PowerCenter

Overview: A hybrid data integration (ETL) service that lets businesses work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

BigQuery

Average Rating: 7.6

Top Comparison: Oracle Autonomous Data Warehouse

Overview: An enterprise data warehouse that solves data problems by enabling super-fast SQL queries using the processing power of Google's infrastructure.

Microsoft Azure Synapse Analytics

Average Rating: 7.8

Top Comparison: Snowflake

Overview: An end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform.

Oracle Autonomous Data Warehouse

Average Rating: 9.0

Top Comparison: Snowflake

Overview: Optimised to deliver unbeatable performance for data warehouse workloads. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes.

SAP Business Warehouse

Average Rating:  8.0

Top Comparison: Amazon Redshift

Overview: Provides businesses with a high-performance infrastructure that helps them evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analysed data.

Snowflake

Average Rating: 8.4

Top Comparison: Microsoft Azure Synapse Analytics

Overview: Fully managed SaaS that provides a single platform for data warehousing, data lakes,

data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

Snowflake Analytics

Average Rating: 8.2

Top Comparison: Amplitude

Overview: Designed with a patented new architecture to be the centrepiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data.

Vertica

Average Rating: 9.0

Top Comparison: Snowflake

Overview: The most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding big data analytics initiatives.

IDG Connect