4.3 / 5 "Snowflake is a great product and very competitive on pricing." They configured different-sized clusters for different systems, and observed much slower runtimes than we did: In April 2019, Gigaom ran a version of the TPC-DS queries on BigQuery, Redshift, Snowflake and Azure SQL Data Warehouse (Azure Synapse). Snowflake is a true data warehouse as a service running on Amazon Web Services (AWS)—no infrastructure to manage and no knobs to turn. With the ease that is found with Azure, we can invest more time before we spend with small problems, in improving and guaranteeing the operation." On the other hand, Azure Synapse is detailed as " Analytics service that brings together enterprise data warehousing and Big Data analytics ". They used 30x more data (30 TB vs 1 TB scale). Microsoft Azure SQL Data Warehouse is most compared with Oracle Autonomous Data Warehouse, SAP BW4HANA, Amazon Redshift, Oracle Exadata and Microsoft Parallel Data Warehouse, whereas Snowflake is most compared with Amazon Redshift, Vertica, Apache Hadoop, Teradata and Oracle Autonomous Data Warehouse. "Azure came to solve this kind of situation.

"It's so easy to get started and the performance in large datasets is incredible. Compare Snowflake vs Azure SQL Database. 222 verified user reviews and ratings of features, pros, cons, pricing, support and more. This benchmark was sponsored by Microsoft.