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

Learn from top reviewers

Snowflake a great data warehousing tool.

Rating: 9 out of 10
January 17, 2025
IncentivizedVetted ReviewVerified User
We work as a team setting up the Snowflake environment for our clients, which includes setting up production, development, and testing environments, setting up the role-based ...
Continue reading
Verified user
Engineer
Snowflake3 years of experience

Your data team will love Snowflake, just be sure to manage cost

Rating: 9 out of 10
January 13, 2025
IncentivizedVetted ReviewVerified User
Our company has grown organically and by acquisition, and as a result we have a series of disparate software products with around 800 databases across different clouds and dif...
Continue reading
David Williams
Manager - Information Technology
Head of Engineering
Damstra Technology
Snowflake2 years of experience
Verified on LinkedIn

Performs well

Rating: 8 out of 10
December 18, 2024
IncentivizedVetted ReviewVerified User
we use it to find information on orders and supply chain issues. we also use it for various AI/ML and data science projects.
Continue reading
Matt Lee
Analyst - Other
Sr Data Analyst
Apple
Snowflake4 years of experience
Verified on LinkedIn

Fastest Cloud-Base Data Storage in the world.

Rating: 10 out of 10
December 17, 2024
IncentivizedVetted ReviewVerified User
We use Snowflake daily, where all of our data is stored. It is straightforward to use and gives you a lot of flexibility to import your tables for custom analysis; it also pro...
Continue reading
Verified user
Analyst
Snowflake2 years of experience

Snowflake - a scalable, secure and cost effective cloud based data storage platform.

Rating: 10 out of 10
December 13, 2024
IncentivizedVetted ReviewVerified User
At Numerator, Snowflake is used as a cloud based data storage platform and it also provides robust data warehousing solutions. The amount of data at Numerator is at a very lar...
Continue reading
Sahil Khan
Analyst - Product Management
Data Analyst
Numerator
Snowflake3 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
Snowflake

Snowflake

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?

10 people also want pricing

Alternatives Pricing

Amazon Redshift

Amazon Redshift

$0.24
per GB per month
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
View more demos
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 Data Intelligence Platform are common alternatives for Snowflake.

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

The most common users of Snowflake are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(368)

Reviews

(1-5 of 31)

Snowflake(cloud-only) Data Warehouse: Excellent Performance and Scalability

Rating: 9 out of 10
Incentivized
June 20, 2019
Verified User
Analyst in Information Technology
Consumer Goods Company, 51-200 employees
Vetted Review
Verified User
Snowflake
1 year of experience
Use Cases and Deployment Scope
A few months ago, we'd decided to migrate our on-premise BI stack to cloud as on-premise solutions were not able to meet growing demands. Clearly, we were looking for cloud-only solutions. After extensive research and POC of several tools, we've on-boarded Snowflake. Snowflake is primarily used by the BI developers as our primary data warehouse and the resulting data is used by the whole organization via the dashboard or Excel extracts. Impressive data compression rate and faster data retrieval make it the best choice as an enterprise data warehouse.
Pros
  • Impressive data retrieval and data compression ratio.
  • Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
  • Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
  • Extensive usages documentation with examples makes development easy.
Cons
  • Stored procedures are implemented through JavaScript. Would be an additional overhead if your team doesn't have expertise.
  • No option to run multiple queries and analyze the results set in the same console window.
Likelihood to Recommend
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.

Snowflake: Very Flexible Data Warehouse with Great, Scalable Capabilities

Rating: 9 out of 10
Incentivized
December 19, 2024
Verified User
Professional in Corporate
Insurance Company, 1001-5000 employees
Vetted Review
Verified User
Snowflake
5 years of experience
Use Cases and Deployment Scope
We use Snowflake as a data warehouse and as an analytics environment. It stores data captured rom production and transformed data tables built for various use cases. These data sets are then piped into other BI tools for self serve analysis or queried directly within Snowflake to answer various analyses / business questions.
Pros
  • Ease of Use: sophisticated enough for technical users but navigable enough for analysts / business users
  • Structured: easy to trace lineages and how different data sets are related to each other
  • Integration: easy to connect to other systems
Cons
  • AI capabilities: not much in terms of integrated machine learning or AI workflow capabilities
  • Relative cost: you get what you pay for, but it is relatively more expensive than some other options
Likelihood to Recommend
It works really well if you want one data warehouse that is very flexible, has many capabilities, and can serve multiple different use cases. It works great for a scaled tech company, but imagine for other businesses in different industries or different scales there could be other solutions that make more sense.

Scalable cloud data warehouse with fair pricing

Rating: 10 out of 10
Incentivized
December 17, 2024
Verified User
Professional in Other
Computer Software Company, 501-1000 employees
Vetted Review
Verified User
Snowflake
5 years of experience
Use Cases and Deployment Scope
We use Snowflake as our central data warehouse where we collect raw data from various different source systems and combine, harmonize, and transform them into reporting-ready formats. This helps us to better understand behavioral patterns amongst our customers, better understand the financials, the usage of our products, Go To Market strategies etc.
Pros
  • Scalability and Performance
  • Auto-Suspend and Auto-Resume
  • Ingestion of Real-Time data via Snowpipe
Cons
  • Add constraints for views and not just for tables
  • Do not force customers to renew for same or higher amount to avoid loosing unused credits. Already paid credits should not expire (at least within a reasonable time frame), independent of renewal deal size.
Likelihood to Recommend
Very well suited for small and large scenarios. Very well suited for structured and semi-structured (e.g. JSON) data. Maybe less ideal for photo / video materials as there are cheaper storage alternatives.

Snowflake - a scalable, secure and cost effective cloud based data storage platform.

Rating: 10 out of 10
Incentivized
December 13, 2024
SK
Sahil Khan
Data Analyst
Numerator (Market Research, 1001-5000 employees)
Vetted Review
Verified User
Snowflake
3 years of experience
View profile
Use Cases and Deployment Scope
At Numerator, Snowflake is used as a cloud based data storage platform and it also provides robust data warehousing solutions. The amount of data at Numerator is at a very large scale and it is growing very fast, Snowflake manages this large volume of data very efficiently. We also use Snowflake for analytical purposes, it provide us a platform to run SQL queries to analyze our data and create dashboards.
Pros
  • Snowflake provides faster data warehousing solutions.
  • Snowflake can be easily integrated and connected with other third party tools.
  • Snowflake does well in ETL and ELT task.
Cons
  • Snowflake can provide more data visualization options in their worksheets.
  • In Snowflake worksheet, the query results are cached for 24 hours and it is not possible to see the query result after 24 hours. Snowflake can provide option to see query results even after 24 hours, that will be very helpful.
  • Snowflake can implement more data masking and encryption options.
Likelihood to Recommend
Snowflake is very well suited for all data storage and data warehousing needs of your business. As Snowflake is a cloud based platform, so you only pay for what you use, independent of the scale of your business. Snowflake can be used to store your data securely. Snowflake is slightly less appropriate for analytical purposes because it provides very limited data visualization options with very less feature.

Scalable Cloud Warehouse Tool with Low Cost of Entry and Minimal Staff Training

Rating: 10 out of 10
Incentivized
August 09, 2021
MS
Michael Sprague
Director
Hamilton College (Higher Education, 501-1000 employees)
Vetted Review
Verified User
Snowflake
3 years of experience
Use Cases and Deployment Scope
Snowflake is used as the central data warehouse for data coming from all divisions of the College. Once in Snowflake, we use a variety of business intelligence tools to pull the data and do reporting and analysis. It also allows us to spend as we grow our data needs, rather than spending a huge up-front investment.
Pros
  • Efficient handling of large data sets in a scalable way
  • Ability to connect from a variety of tools (Tableau, Metabase, JDBC, many more)
  • Querying and output of data in JSON format
  • Built-in query and export tools
Cons
  • Security roles and access are hard to understand and manage
  • Rollout of new features seems to heavily favor US West coast, everyone else has to wait
  • Visual interface does not allow you to manage custom functions and routines. For those, it is code only. Management of tables and views is visual.
Likelihood to Recommend
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.
Return to navigation