What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
56 Ratings

Snowflake

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
56 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 101
138 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Likelihood to Recommend

Snowflake

Snowflake is great when you need to store large amounts of data while retaining the ability to query that data quickly. It is very reliable and allows for auto-scaling on large queries meaning that you're only paying for the power you actually use. It's taken queries that took 20+ minutes to run on redshift down to 2 minutes on Snowflake.
Jake Schlingman profile photo

Azure SQL Database

The most important positive for our organization is the ability to scale up or down at will. As a startup, we needed to quickly adapt to changing space and performance needs. It's also integral as we grow different branches of the business. Thus far, we haven't encountered much of anything with the tool that hasn't been a good fit for our business.
No photo available

Feature Rating Comparison

Database-as-a-Service

Snowflake
Azure SQL Database
9.1
Automatic software patching
Snowflake
Azure SQL Database
9.2
Database scalability
Snowflake
Azure SQL Database
9.6
Automated backups
Snowflake
Azure SQL Database
9.2
Database security provisions
Snowflake
Azure SQL Database
9.3
Monitoring and metrics
Snowflake
Azure SQL Database
8.3
Automatic host deployment
Snowflake
Azure SQL Database
8.9

Pros

Snowflake

  • Impressive data retrieval and data compression ratio.
  • Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
  • Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
  • Extensive usages documentation with examples makes development easy.
No photo available

Azure SQL Database

  • Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
  • All the tools simply work after you are on Azure SQL Database.
  • The applications do not need changes in order to start using Azure SQL Database.
  • Hybrid Cloud scenarios will work.
  • Clustering and failover - already there.
  • You can start monitoring the use and extract performance insights in a new way in Azure.
Arthur Zubarev profile photo

Cons

Snowflake

  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
No photo available

Azure SQL Database

  • A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
  • Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
  • Price can always be improved as well. It’s not bad, but room for improvement.
No photo available

Likelihood to Renew

Snowflake

Snowflake 8.0
Based on 1 answer
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
No photo available

Azure SQL Database

Azure SQL Database 8.0
Based on 1 answer
This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
Zimran Azim profile photo

Usability

Snowflake

Snowflake 8.8
Based on 11 answers
The web front end is OK, but they could improve the product with a front end GUI. We have connected DBEAVER to snowflake with an ODBC driver, but the queries are a lot slower from DBEAVER, compared to the web front end. SSIS also has an ODBC connection, but it is also a slower to pull data from snowflake. Overall the usability is good.
Wicks Justin profile photo

Azure SQL Database

No score
No answers yet
No answers on this topic

Support

Snowflake

Snowflake 7.7
Based on 3 answers
Overall great group of people and they are very insightful. They try to understand what the overall problem is rather than just focusing on the exact issue, which helps put a lot of things into perspective. The turnaround time is very good. I never found myself waiting for more than a couple of days, which is reasonable.
Duncan Hernandez profile photo

Azure SQL Database

Azure SQL Database 9.0
Based on 4 answers
We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.
No photo available

Alternatives Considered

Snowflake

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.
Andrew Goss profile photo

Azure SQL Database

Comparing with Amazon Aurora: Azure SQL DB is 100% compatible with SQL Server and Aurora is compatible with MySQL and PostGreSQL. Because of if, SQL DB suits large enterprises with hundreds of databases better. Comparing with Oracle: the main issue is that Oracle will try to push all other services available in their product offering.
No photo available

Return on Investment

Snowflake

  • Quick installation/setup for a data warehouse solution.
  • Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model.
  • Make easy and simplified the workload management using virtual warehouses and materialized views.
Jacob Biguvu profile photo

Azure SQL Database

  • Azure SQL Databases are a great solution and with the Azure pricing model, you can reduce costs in most scenarios. They also have added intrinsic value by the products nature of being scale-able to the current task (i.e.- a short term need for more processing power).
Michael Jipping profile photo

Pricing Details

Snowflake

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Azure SQL Database

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Snowflake
9.0
Azure SQL Database
8.9

Likelihood to Renew

Snowflake
8.0
Azure SQL Database
8.0

Usability

Snowflake
8.8
Azure SQL Database

Support

Snowflake
7.7
Azure SQL Database
9.0

Add comparison