Compare Microsoft Azure SQL Data Warehouse vs. Snowflake

Microsoft Azure SQL Data Warehouse is ranked 4th in Cloud Data Warehouse with 8 reviews while Snowflake is ranked 2nd in Cloud Data Warehouse with 7 reviews. Microsoft Azure SQL Data Warehouse is rated 7.8, while Snowflake is rated 8.2. The top reviewer of Microsoft Azure SQL Data Warehouse writes "A good solution for simple data warehousing that scales well, but it needs better technical support". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". Microsoft Azure SQL Data Warehouse is most compared with Snowflake, Amazon Redshift and SAP BW/4HANA, whereas Snowflake is most compared with Apache Hadoop, Microsoft Azure SQL Data Warehouse and Amazon Redshift. See our Microsoft Azure SQL Data Warehouse vs. Snowflake report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Anonymous User
Anonymous User
Find out what your peers are saying about Microsoft Azure SQL Data Warehouse vs. Snowflake and other solutions. Updated: November 2019.
384,324 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to.The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.The most valuable feature is the scalability.The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.The initial setup was really easy and straightforward.The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.Scaling this solution is easy and the uptime is okay.

Read more »

The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.The initial setup is straightforward. You just need to follow the documentation.They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs.

Read more »

Cons
I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.The configuration for things like high-availability could be more user-friendly for non-technical users.With respect to what needs to be improved, concurrent connectivity has some limitations.It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill.This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market.It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database.The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster.I would like to see better integration with Active Directory, because we have had problems, and we still do.

Read more »

Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.The solution could improve the user interface and add functionality to the system.The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.Support needs improvement, as it can take several days before you get some initial support.There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries.

Read more »

Pricing and Cost Advice
The licensing fees for this solution are on a pay-per-use basis, and not very expensive.When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version.The pricing is okay. You can pay as you go.The price of this solution could be improved.

Read more »

The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year.Pricing can be confusing for customers.

Read more »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
384,324 professionals have used our research since 2012.
Ranking
4th
Views
7,456
Comparisons
6,534
Reviews
5
Average Words per Review
535
Avg. Rating
7.6
2nd
Views
16,833
Comparisons
12,129
Reviews
5
Average Words per Review
558
Avg. Rating
8.2
Top Comparisons
Compared 25% of the time.
Compared 14% of the time.
Also Known As
Microsoft Azure SQL DW, Azure SQL Data WarehouseSnowflake Computing
Learn
Microsoft
Snowflake Computing
Overview

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.

Offer
Learn more about Microsoft Azure SQL Data Warehouse
Learn more about Snowflake
Sample Customers
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
VISITORS READING REVIEWS
Software R&D Company39%
Comms Service Provider9%
Manufacturing Company8%
Financial Services Firm6%
VISITORS READING REVIEWS
Software R&D Company37%
Financial Services Firm8%
Insurance Company8%
Comms Service Provider7%
Find out what your peers are saying about Microsoft Azure SQL Data Warehouse vs. Snowflake and other solutions. Updated: November 2019.
384,324 professionals have used our research since 2012.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
Sign Up with Email