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.8.

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

(336)

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 37)
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
Snowflake data exchange is a great product with its competitors slowly following suit creating their own marketplaces of sort. The fact that the core data warehouse services on Snowflake are in most cases more ahead of other tools tied with the ability to drive marketplace exchanges from a B2B and B2C use case allows you to not only use your warehouse solution for building core data platform enterprise architecture, but it also provides a different way for you to look at delivering products to existing and prospect clients.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake works really well when you have all different levels of data analysts in one team. Snowflake can be the common tool to pull data and create tables since SQL is such a basic and easy-to-use data science language without the requirement of fully understanding the data type.
David Williams | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is definitely suited for analytics, querying, reporting purposes.

It is not so well-suited for being your operational database. You could, but given it charges based on consumption, you wouldn't want to have it as a 24x7x365 thing.

We've also found once we adopted Snowflake we began to find many more areas where it solved problems for us - for example, secure sharing, data science explorations, training ML models, etc.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Data Security while ingestion and during storage, ability to support multiple data formats, dynamic compute to support varied use cases, low cost of maintenance and operations.
Jeremy Pierce, MBA | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I am over our HR data, and we use Workday for our HR management system.

I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket.

Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Snowflake can be based on any of the three major cloud service providers namely GCP, Azure and AWS. So it is easy for organizations to stick to their preferred CSP and avail Snowflake services. So it is well suited for clients with any of the CSPs in their landscape and wants to make use of features of a robust cloud based data warehousing solution.
Shiv Shrotriya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is a cloud-based warehousing solution that is very quick and easy to maintain. Snowflake stores data in blocks by compressing the data. This allows query processing to be much faster compared to fetching rows. Also, you can change the resource consumption as per need. It has limitations while working with unstructured data.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is suitable for the situations that you are working with all levels of analysts in terms of data science skills. By using SQL, the user does not need to understand data type, etc. before using the tool. However, it could be potential trouble when consuming the data in python later.
Score 8 out of 10
Vetted Review
Verified User
it is really useful when it comes to running highly elaborated queries that will die in other environments. it also is great for crossing tables of different schemas that are not necessarily related. It doesn't perform well when it comes to dashboard creation/sharing or graphic solutions like drawing pies or bars out of a query
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Cloud based analytical data store type workloads where data is volumous and query access patterns are well-known is Snowflake's sweet spot. The MPP engine is second to none and being able to scale up or down on demand enables queries that weren't previously possible. Where Snowflake isn't particularly suited is for on-premise or smaller data workloads or transactional processing workloads.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is very well suited if your organization wants to start small with minimal investment, and then grow at any pace. It is also good for teams that already know SQL from working on another platform, such as MS SQL Server. It pairs really well with integration tasks because of its native ability to handle JSON data, for both import and querying.

If your tools can only connect by JDBC (no native Snowflake connector) you may have some issues with large data sets. This is really a limitation of using JDBC, not Snowflake, but it is something to be aware of.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
For an organization that has small, medium, or large data collection, Snowflake provides the best infrastructure to store, manage, utilize and analyze the data. Especially for companies that are growing at a really fast pace, it helps you not only with warehouse capabilities but also its connection with several BI tools give you the flexibility and option to connect and analyze the data [in] real time.
Darren Mihalic | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is highly recommended to those companies that need a track and secure mode for the transfer of the data. Its sharing is amazing for the business community. It will be suitable for the B2B type business setups. This tool is very cost-effective and will align your daily technical queries for better handling.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is a powerful warehousing solution and suits companies with large scale of data. It helps with fast querying of data, and there is little need to manage computation, since it is managed for you.

However, it does require a dedicated team and an upfront cost in setting up an structuring the warehouse. Some solutions such as AWS's Redshift or GCP's Bigquery could be a better alternatives if is already within the AWS or GCP ecosystem. Bigquery in particular has a low upfront cost and a better pricing model.
Brian Bickell | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
ResellerIncentivized
Specific scenarios where Snowflake is very strong include analytical data processing scenarios. Snowflake is wonderful at inexpensively consolidating and storing data and allowing very fast access to that data while maintaining a low cost profile with it's ability to automatically resume and suspend virtual warehouses.

Snowflake is less suited to transaction processing scenarios and isn't a best choice to back up an online order processing system.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
It's easy to scale up/down or expand/shrink. However, without any tuning capabilities in SQL, more materialization of the data needs to be done to use the database cost effectively. It is time to look into other services that don't charge arm and leg. Customer service is slow to respond.
Sudarshan Kothari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage. The only scenario where Snowflake would require second thought would be data that has PII information, as it doesn't have encryption options for such data points.
November 25, 2019

Amazing cloud-based DB

Torrey Vegter | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Snowflake works extremely well for storing a data warehouse as the querying is optimized for larger tables that are filled in batches. It also works extremely well with unstructured data and has basically replaced any need we previously had for NoSQL databases. Snowflake does not perform well for transactional databases.
Duncan Hernandez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The best reason to go to Snowflake is if there is a lot of stress on the server and queries are running slow. Snowflake does what it says it will do and improve this dramatically.

The only reason why someone would is because it is pricy or if there isn't much data at one's organization.
Jake Schlingman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is great when you need to store large amounts of data while retaining the ability to query that data quickly. It is very reliable and allows for auto-scaling on large queries meaning that you're only paying for the power you actually use. It's taken queries that took 20+ minutes to run on redshift down to 2 minutes on Snowflake.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is the data warehouse built for the cloud, enabling the data-driven enterprise with instant elasticity, secure data sharing, and per-second pricing. Faster data retrieval and on the fly retrieval of semi-structured data in tabular format. Excellent data compression ratio. Could be pricey for very large deployments.
Return to navigation