Skip to main content
TrustRadius
Snowflake

Snowflake

Overview

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed,…

Read more
Recent Reviews

TrustRadius Insights

Snowflake is widely used by organizations as a data lake and data warehouse, allowing users to blend data from multiple sources and …
Continue reading

Snowflake Review

10 out of 10
December 20, 2022
Incentivized
I work on data analysis of multiple projects and use snowflake to write queries, pull data, and do some analysis. Typically, I use …
Continue reading

Snowflake Review

10 out of 10
December 20, 2022
Incentivized
It is used by the whole company. We went with Snowflake because it is faster than Vertica and easier to manage different warehouses with.
Continue reading

What makes Snowflake amazing

8 out of 10
November 09, 2021
Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the…

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.snowflake.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

8 people also want pricing

Alternatives Pricing

What is Amazon Redshift?

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Return to navigation

Product Demos

Snowflake Must Know New Objects | Chapter-8 | Snowflake Hands-on Tutorial

YouTube

Webinar: Snowflake on Azure: Modern Data Analytics

YouTube

Snowfall Projector Light

YouTube

Snowsight - Snowflake Modern Web UI | Chapter-5 | Snowflake Hands-on Tutorial

YouTube

Snowflake Database/Schema/Table & Container Hierarchy | Chapter-7 | Snowflake Hands-on Tutorial

YouTube

DesignsBySiCK.com Wash Away Fibrous Free Standing Lace FSL Snowflake demo

YouTube
Return to navigation

Product Details

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.

Snowflake Data Marketplace gives data scientists, business intelligence and analytics professionals, and everyone who desires data-driven decision-making access to live and ready-to-query data from your ecosystem of business partners and customers, and from potentially thousands of data providers and data service providers.

Snowflake Screenshots

Screenshot of Snowflake Installation

Snowflake Video

Product Introduction

Snowflake Competitors

Snowflake Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.

Amazon Web Services and Databricks Lakehouse Platform are common alternatives for Snowflake.

Reviewers rate Support Rating highest, with a score of 9.7.

The most common users of Snowflake are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(337)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Snowflake is widely used by organizations as a data lake and data warehouse, allowing users to blend data from multiple sources and generate comprehensive reports without impacting transactional databases. Users appreciate the excellent built-in features of Snowflake, such as row-level security, data masking, and secure sharing, which enable them to implement robust security measures at the database level. The software's model of separating compute from storage and accommodating different workloads for different scenarios proves to be highly advantageous for users. Additionally, Snowflake serves as a central repository for data, providing a single source of truth and facilitating data engineering for various use cases. Users can easily connect with data service providers, make data-driven decisions, and create modern and integrated data applications. The cost-effectiveness of Snowflake simplifies online data handling and supply to customers. It is widely used by data analytics clients across various industries due to its efficient, scalable, and easy-to-use data environment.

Furthermore, Snowflake enables quick and effective data querying, allowing users to gain insights into program aspects and user behavior for smarter business decisions. Its architecture, scalability, and data sharing capabilities make it a reliable cloud-based data warehousing solution for managing and sharing data efficiently. Many organizations are leveraging Snowflake to build a centralized solution for their reporting and analytics efforts. Snowflake's separation of compute from storage and pay-as-you-go pricing model enable intelligent and efficient budget planning and use. Customers are also using Snowflake to drive machine learning projects and gain valuable insights into their business data.

In addition to serving as a primary data warehouse for organizations, Snowflake is also instrumental in powering dashboards, machine learning solutions, ad-hoc queries, daily KPI aggregation, predictive modeling, customer acquisition management, telemetry insights, and more. Data teams across different departments rely on Snowflake for their compute purposes. The software offers an impressive data compression rate and faster data retrieval compared to other solutions like Amazon Redshift, making it an ideal choice as an enterprise data warehouse. The ease of use and accessibility of Snowflake make it widely adopted across entire organizations, catering to users with varying levels of data science skill. From basic data munging and querying to deep machine learning analysis and real-time access to data, Snowflake powers the entire data warehouse for many companies, providing crucial analytical understanding of performance and influencing business strategy.

Intuitive User Interface: Users have consistently praised Snowflake's intuitive and easy-to-use interface, with many stating that it is beginner-friendly. The drag and drop feature for tables into queries has been particularly helpful for users when writing complex queries.

Advanced Security Features: Snowflake's security features have received high praise from users, who feel confident in connecting with numerous business partners due to the platform's advanced security measures and effective programming. This positive sentiment indicates that Snowflake successfully prioritizes data protection and privacy.

Seamless Data Integration: Users appreciate Snowflake's ability to integrate, analyze, and transfer data from multiple clouds. They find it easy to have a transparent idea about data extraction and transfer. This feature allows users to efficiently work with their diverse datasets across different cloud platforms without any hassle or complications.

Limited Reporting Tools: Some users have mentioned that the reporting tools in the software are limited, which has led them to rely on additional tools like Tableau for more advanced reporting capabilities. They feel that having more robust built-in reporting features would enhance their data analysis and visualization options.

Cloud-Only Data Warehouse: The fact that the data warehouse is entirely cloud-based has raised concerns for some businesses. They worry about potential issues with data security, privacy, and control. These businesses prefer an on-premises solution or a hybrid approach where they can have more direct control over their data storage.

Complexity of JavaScript Implementation: Users have noted that implementing stored procedures through JavaScript can result in unnecessary overhead if their team lacks expertise in this programming language. This creates challenges when it comes to developing and maintaining complex procedures, leading to frustration among users who prefer a simpler implementation process.

Attribute Ratings

Reviews

(1-25 of 34)
Companies can't remove reviews or game the system. Here's why
Harvey Wyche | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
In my opinion, the other tools have similar and some different features; however, when I ran proof of technologies between Synapse and Snowflake. Snowflake did things better or just had functionality that the other tools did not. One that stuck out at the time was scale up and scale down of a warehouse, Snowflake did this right out the gate. While other tools scaled up but could not scale down natively without having a separate process created to do so, and that separate process was costly from a resource, monitoring, and application impact.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Compared to Amazon Redshift, Snowflake is slightly easier and faster to achieve ROI but based on the user's perspective, the two tools have very little difference since both are leveraging SQL to pull data from AWS S3. Snowflake is also working with Microsoft Azure but it is not used in my organization.
David Williams | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We particularly liked Snowflake's security model as well as its unique storage (whereby everything is essentially a pointer to immutable micro-partitions, which is the key behind its zero-copy cloning, its secure sharing, its time travel, etc.). and also how it separates compute allowing many different warehouses of different sizes for different purposes.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Cloud -Native architecture, Separation of Storage and Compute provides flexibility, Scalable Compute, Cost and Data Security
December 20, 2022

Snowflake Review

Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is much faster and easier to write queries and pull data. But the visualization part of Snowflake is not as good as them. Also, Snowflake only supports SQL queries but not python or other languages. So basically Snowflake is the expert in its field but not suitable for a broad use case.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
While Snowflake is more open to cloud eco system, SAP integrated well with SAP eco system products like SAP ECC or SAP S/4. So for people who have invested heavily in SAP eco system including SAP ECC or S/4, it makes sense to go with SAP DWC which is also evolving very rapidly. For other customers, Snowflake could be the tool of choice which offers great flexibility when it comes to integration with any other third party solutions.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Since we switch from Amazon Redshift to Snowflake, we found Snowflake is much better than redshift in many ways, including the data integrate and data pull. However, comparing directly pull data from Amazon S3, Snowflake is quite slow in terms of data pull speed and the more method to process data in python.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams worried about vendor lock-in.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Azure and Snowflake compared very similarly, but Snowflake provided more options to integrate and connect with tools/companies that were not partners. It seemed to be a more flexible environment. The barrier for entry on Oracle and Google we just too complicated. In particular, working in the Google environment felt like learning an entirely new language and was highly technical. We were up and running with Snowflake in less than a day, without advanced technical knowledge about cloud platforms. Oracle was both complicated and extremely expensive.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.
Darren Mihalic | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Snowflake has won the match because it is giving an excellent performance with its efficient features and reliable results. This is a totally secure program for our precious and important data.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our initial data warehousing solution was Treasure Data. We had issues with the costly pricing model, which would be exhorbitant if we want to hold our data in memory and query using Presto. As a result, some heavy lifting was done in Hive (managed by Treasure Data); unfortunately, this is also very slow.
As a result, dashboards are updated slowly, and analysts found it hard to deliver insights to stakeholders in a timely manner.
Snowflake was a blaze compared to Treasure Data. It solves two problems: computation can be easily scaled with respect to the data volume, and this is handled by Snowflake, and query speeds are much faster than Treasure Data.
Brian Bickell | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
ResellerIncentivized
In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best among them for most customers. It's easier to manage, in many cases faster, and in almost all cases it is less expensive because of the ability to automatically resume and suspend depending on usage.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Redshift compute and storage can be scaled up/down together (though they added some features recently, they don't quite add up). I haven't tried Avalanche or Firebolt but would love to in the near future, due to their pedigree or revolutionary billing methods.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
- Cost was the main aspect on the decision.
- Performance was in par or better compared to other tools in the market.
- Snowflake in my opinion stacks better than other tools I have used in the past.
Sudarshan Kothari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Accommodates future data types such as JSON and XML. Scalability is another advantage. Pay per use is beneficial for organizations like yours. Direct connectors with AWS help us to go with it. No limit on user creation and clone data not eating up extra disk space are a few reasons why Snowflake was chosen.
Duncan Hernandez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our issue with Redshift was that it was very expensive. On top of that, queries were still slow and if we used more of Redshift's memory, then it would have cost even more. Snowflake is not cheap, but less costly for us. Plus, the performance was much better. Also, we got to keep Amazon S3 since Snowflake was compatible with it.
Jake Schlingman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
For us our previous solution in this space was Redshift which we found to be much less reliable and was hardware capped. There may very well be cloud options that our company just wasn't utilizing. For us, queries constantly ran out of memory and failed. Even when they didn't outright fail, they took significantly longer to run. Overall the switch to Snowflake has been awesome and we've definitely increased our efficiency when it comes to accessing our data.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Delivered as an easy-to-use data warehouse service, Snowflake enables you to process and analyze all your diverse data, build multiple databases, query with a common robust ANSI SQL environment, and execute ACID transnational capabilities.
  • No need to create indexes and optimize query plans—plan storage capacity months in advance.
  • Easy to configure new instances, create databases and set up security.
Andrew Goss | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Jacob Biguvu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Redshift and Hive both have unique architecture. Both have their own cons. My guess is that Snowflake is made up by using the concepts of the two architecture concepts such as Amazon Redshift and Haddop, addressed the issues or gaps found in Redshift and Hadoop.
Return to navigation