We changed our name from IT Central Station: Here's why

Microsoft Azure Synapse Analytics vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Comparison Summary
Question: Which is better - Azure Synapse Analytics or Snowflake?
Answer: If you are dealing with semi-structured data like json Snowflake has great support in handling and querying json data. it is also good to use as data lake and can act as one stop solution for a data lake and cloud data warehouse. query performance and low maintainability is also what makes snowflake a great choice.
Featured Review
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Snowflake and other solutions. Updated: January 2022.
564,599 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 solution's scalability is very, very good. It's one of the most important aspects for us.""I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics.""The most valuable feature is the level of processing power, and being able to complete tasks in parallel.""The product is very user friendly.""Technical support is okay in terms of the help they provide.""They are available on the Cloud, and the platform is very intuitive.""We have found that it is easy to develop and to do the analytics in the modules of data.""It's user-friendly and has a good dashboard."

More Microsoft Azure Synapse Analytics Pros →

"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also.""The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business.""It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it.""Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems.""Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake.""It's ultra-fast at handling queries, which is what we find very convenient.""The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do.""Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."

More Snowflake Pros →

Cons
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.""The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them.""Documentation could be improved.""I would like to see them provide the ingestion of images.""If I'm looking for something good in the cloud, I would want it to have better standard connectors.""It's a complicated product.""The performance and data consistency need to be improved.""Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."

More Microsoft Azure Synapse Analytics Cons →

"There is a need for improvements in the documentation, this would allow more people to switch over to this solution.""They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that.""The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL.""Their UiPath, the workspace area, needs some work.""It's not that flexible when compared to Oracle.""Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution.""It would be better if they had a data profile tool that tells me where the gaps are in my time series data.""They should improve the reporting tools."

More Snowflake Cons →

Pricing and Cost Advice
  • "All of the prices are available online."
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

  • "It is not cheap."
  • "The pricing for Snowflake is competitive."
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • More Snowflake Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    564,599 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer: 
    Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer: 
    Fills the gap between big data and classic data warehouses.
    Top Answer: 
    Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.
    Top Answer: 
    For our licensing, we renew every January by $25,000 in both credits. Their pricing structure is a pay-per-second usage in terms of credits, but you can get discounts if you buy them in bulk. I think… more »
    Top Answer: 
    The documentation could improve. They should provide architecture information. There could be better integration with tools other than the common databases used to receive data. There are other tools… more »
    Ranking
    2nd
    Views
    26,962
    Comparisons
    19,760
    Reviews
    31
    Average Words per Review
    530
    Rating
    8.0
    1st
    Views
    37,053
    Comparisons
    27,399
    Reviews
    40
    Average Words per Review
    578
    Rating
    8.4
    Comparisons
    Also Known As
    Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
    Snowflake Computing
    Learn More
    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 Synapse Analytics
    Learn more about Snowflake
    Sample Customers
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Top Industries
    REVIEWERS
    Computer Software Company21%
    Comms Service Provider16%
    Manufacturing Company11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider18%
    Financial Services Firm6%
    Energy/Utilities Company6%
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm11%
    Comms Service Provider7%
    Manufacturing Company7%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider15%
    Financial Services Firm8%
    Insurance Company5%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise21%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business25%
    Midsize Enterprise27%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise68%
    Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Snowflake and other solutions. Updated: January 2022.
    564,599 professionals have used our research since 2012.

    Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 41 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Snowflake is rated 8.4. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Microsoft Azure Synapse Analytics is most compared with Amazon Redshift, SAP BW4HANA, Apache Hadoop, Oracle Autonomous Data Warehouse and AWS Lake Formation, whereas Snowflake is most compared with Amazon Redshift, Vertica, Teradata, Oracle Exadata and AWS Lake Formation. See our Microsoft Azure Synapse Analytics vs. Snowflake report.

    See our list of best Cloud Data Warehouse vendors.

    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.