IT Central Station is now PeerSpot: Here's why

Microsoft Azure Synapse Analytics vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Executive Summary
Updated on March 24, 2022

We performed a comparison between Microsoft Azure Synapse Analytics and Snowflake based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.

  • Ease of Deployment: Microsoft Azure Synapse Analytics reviewers had mixed reviews on the deployment, with many feeling it was complex. On the other hand, Snowflake reviewers felt it was an easy setup and deployment.
  • Features: Microsoft Azure Synapse Analytics users felt the software helped them control expenditures and was very scalable, but they had security concerns and felt the software wasn’t intuitive. Reviewers of Snowflake liked the stability and scalability of the solution and felt the software addressed challenges for traditional data warehouses, but said the UI needed improvement, especially when it came to extracting data.
  • Pricing: Users of Microsoft Azure Synapse Analytics gave mixed reviews on the pricing, with many feeling it was expensive. Users of Snowflake liked the efficient pricing model and felt it was high yet fair.
  • Service and Support: Both Microsoft Azure Synapse Analytics and Snowflake reviewers felt the support they received was helpful.

Comparison Results: Based on the parameters we compared, Snowflake had a better user rating regarding ease of deployment and pricing. Both softwares had the same rating when it came to service and support. In terms of features, Microsoft Azure Synapse Analytics users felt the software had security issues and didn’t feel it was very intuitive. In contrast, users of Snowflake felt the UI needed improvement.

To learn more, read our detailed Microsoft Azure Synapse Analytics vs. Snowflake report (Updated: July 2022).
Buyer's Guide
Microsoft Azure Synapse Analytics vs. Snowflake
July 2022
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Snowflake and other solutions. Updated: July 2022.
622,358 professionals have used our research since 2012.
Q&A Highlights
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
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch.""It's scalable; you can scale up and scale down.""Overall deployment and integration is pretty fast.""We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on.""They are available on the Cloud, and the platform is very intuitive.""The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services.""The solution has been working well overall.""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."

More Microsoft Azure Synapse Analytics Pros →

"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services.""The most valuable features of Snowflake are its performance and power.""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.""The syntax is advanced which reduces the time to write code.""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 is a very easy-to-use solution. It is user-friendly, and its setup time is very less.""For us, the virtual warehousing is likely the most valuable aspect.""All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."

More Snowflake Pros →

Cons
"Comes with a pretty steep learning curve.""Integration with other products is an area that can be improved.""The need to improve a little bit in terms of user-friendliness.""The only issue that we have run into with the solutions performance is with regards to concurrency.""Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets.""The initial setup is complex.""They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed.""Right now, we are really struggling with the performance. it's not as good as we had hoped."

More Microsoft Azure Synapse Analytics Cons →

"I am still in the learning stage. It has good security, but it can always be more secure.""Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety.""These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions.""It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud.""The solution needs more connectors.""It would be better if they had a data profile tool that tells me where the gaps are in my time series data.""Product activation queries can't be changed while executing.""They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."

More Snowflake Cons →

Pricing and Cost Advice
  • "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."
  • "Because it's cloud the cost is a different convention and the licensing costs are not the same."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

  • "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."
  • "We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
  • "Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
  • More Snowflake Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    622,358 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:This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere.
    Top Answer:They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the… more »
    Top Answer:Sometimes when I'm trying to refresh the data, my different application or tool has to connect to its backend database through the connection I create. Sometimes, I face some issues like not having… more »
    Ranking
    2nd
    Views
    33,074
    Comparisons
    22,599
    Reviews
    44
    Average Words per Review
    491
    Rating
    7.9
    1st
    Views
    39,423
    Comparisons
    29,410
    Reviews
    48
    Average Words per Review
    559
    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

    Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.

    Microsoft Azure Synapse Analytics is built with these 4 components:

    1. Synapse SQL
    2. Spark
    3. Synapse Pipeline
    4. Studio

    Microsoft Azure Synapse Analytics Features

    Microsoft Azure Synapse Analytics has many valuable key features, including:

    • Cloud Data Service: WIth Microsoft Azure Synapse Analytics you can operate services (data analytics, machine learning, data warehousing, dashboarding, etc.) in a single workspace via the cloud.

    • Structured and unstructured data: Microsoft Azure Synapse Analytics supports both structured and unstructured data and allows you to manage relational and non-relational data - unlike data warehouses and lakes that tend to store them respectively.

    • Effective data storage: Microsoft Azure Synapse Analytics offers next-level data storage with high availability and different tiers.

    • Responsive data engine: Microsoft Azure Synapse Analytics uses Massive Parallel Processing (MPP) and is designed to handle large volumes of data and analytical workloads efficiently without any problems.

    • Several scripting languages: The solution provides language compatibility and supports different programming languages, such as Python, Java, Spark SQL, and Scala.

    • Query optimization: Microsoft Azure Synapse Analytics works well to facilitate limitless concurrency and performance optimization. It also simplifies workload management.

    Microsoft Azure Synapse Analytics Benefits

    Some of the benefits of using Microsoft Azure Synapse Analytics include:

    • Database templates: Microsoft Azure Synapse Analytics offers industry-specific database templates that make it easy to combine and shape data.

    • Better business insights: With Microsoft Azure Synapse Analytics you can expand discovery of insights from all your data and apply machine learning models to all your intelligent apps.

    • Reduce project development time: Microsoft Azure Synapse Analytics makes it possible to have a unified experience for developing end-to-end analytics, which reduces project development time significantly.

    • Eliminate data barriers: By using Microsoft Azure Synapse Analytics, you can perform analytics on operational and business apps data without data movement.

    • Advanced security: Microsoft Azure Synapse Analytics provides both advanced security and privacy features to ensure data protection.

    • Machine Learning: Microsoft Azure Synapse Analytics integrates Azure Machine Learning, Azure Cognitive Services, and Power BI.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by Microsoft Azure Synapse Analytics users who are currently using the solution.

    PeerSpot user Jael S., who is an Information Architect at Systems Analysis & Design Engineering, comments on her experience using the product, saying that it is “Scalable, intuitive, facilitates compliance and keeps your data secure”. She also says "We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."

    Michel T., CHTO at Timp-iT, mentions that "the features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."

    A Senior Teradata Consultant at a tech services company says, "Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."


    Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

    Its platform is made up of three components:

    1. Cloud services: As part of its cloud services, Snowflake uses ANSI SQL, which empowers users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    1. Query processing: With Snowflake, workload concurrency is never a problem because its compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses do not compete for computing resources nor do they affect the performance of each other.
    1. Database storage: Snowflake manages all parts of the data storage process automatically, including file size, compression, organization, structure, and metadata, as well as statistics.

    Snowflake Features

    Snowflake has many valuable key features. Some of the most useful ones include:

    • Scalability: Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports an unlimited amount of concurrent users and workloads, from interactive to batch.
    • Automation: Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • Seamless cross-cloud and cross-region connections: With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Third-party data integrations: Snowflake’s Data Marketplace offers third-party data which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    Snowflake Benefits

    There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:

    • Helps optimize costs
    • Reduces downtime
    • Improves operational efficiency
    • Built for high reliability and availability
    • Automates data replication for fast recovery

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.

    Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "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."

    A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."

    A Solution Architect at a wholesaler/distributor comments, "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."

    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 Company24%
    Comms Service Provider14%
    Manufacturing Company10%
    Healthcare Company10%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider16%
    Financial Services Firm7%
    Energy/Utilities Company6%
    REVIEWERS
    Computer Software Company38%
    Financial Services Firm12%
    Manufacturing Company9%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider13%
    Financial Services Firm10%
    Insurance Company6%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise24%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise15%
    Large Enterprise67%
    REVIEWERS
    Small Business24%
    Midsize Enterprise22%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    Microsoft Azure Synapse Analytics vs. Snowflake
    July 2022
    Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Snowflake and other solutions. Updated: July 2022.
    622,358 professionals have used our research since 2012.

    Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 44 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 47 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, Azure Data Factory, Apache Hadoop, SAP BW4HANA and Oracle Autonomous Data Warehouse, whereas Snowflake is most compared with Amazon Redshift, Vertica, Teradata, AWS Lake Formation and Oracle Exadata. 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.