Most Helpful Review
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 asked business professionals to review the solutions they use. Here are some excerpts of what they said:
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.
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.
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.
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.
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.
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.
out of 8 in Cloud Data Warehouse
Average Words per Review
out of 8 in Cloud Data Warehouse
Average Words per Review
Compared 47% of the time.
Compared 10% of the time.
Compared 7% of the time.
Compared 25% of the time.
Compared 20% of the time.
Compared 14% of the time.
Also Known As
|Microsoft Azure SQL DW, Azure SQL Data Warehouse||Snowflake Computing|
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.
Learn more about Microsoft Azure SQL Data Warehouse
Learn more about Snowflake
|Toshiba, Carnival, LG Electronics, Jet.com, Adobe,||Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops|
Software R&D Company39%
Comms Service Provider9%
Financial Services Firm6%
Software R&D Company37%
Financial Services Firm8%
Comms Service Provider7%