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-2 of 2)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have used Snowflake to ingest, store and process data from the customer devices telemetry data for various insights. Ease of creating a pipeline from multiple sources without worrying about the amount of data and scalability of compute for different departments helped us a faster go to market solution. Continuous discovery is the core of our team means fail fast with minimum cost, with Snowflake we are able to do quick proof of concept and align project goals to the organization strategy
  • Ingestion from different cloud platforms like AWS, Azure and GCP
  • Ability to store data in multiple formats including structured and unstructured
  • Compute is dynamic. Ability to chose a compute based on cost and performance.
  • Data visualization capability has improved though have lot of areas of improvement
  • Data governance and catalog capabilities
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.
  • Data Security
  • Cost of Ownership
  • Scalability
  • Ability to expedite continuous discovery
  • Instant Infra availability with minimum planning
  • Ability to monitor the cost and scope of optimization
Cloud -Native architecture, Separation of Storage and Compute provides flexibility, Scalable Compute, Cost and Data Security
1000
Sales, Marketing, Supply Chain, Finance, Operations
100
Data Engineers, Application Team, Functional Analysts
  • Data Storage
  • Data Insights
  • Data Analytics
  • Ability to Integrate with multiple cloud platforms and support Hybrid Architecture
  • Collaborate with Customer and Partners
  • Create and Support Data Mesh
  • Ingest and process Streaming data
No known issues with the product
Yes
We replaced Big Data - Hadoop with Snowflake because of its SQL native and can support both Structure and Unstructured Data. We struggled with Hadoop on the scalability, performance and architecture
  • Price
  • Product Features
  • Product Usability
Cloud-Native architecture and support for SQL which aligns to our transaction data in Oracle. Compute is dynamic and scalable allows to control and optimize the cost
Not a part of Implementation team
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Snowflake is currently being used to ingest daily JSON files exported from an analytics package into S3. We use Snowflake for Ad Hoc Queries, aggregating daily KPIs and pushing that data into a SQL Server, as well as creating Tableau extracts for our dashboards. We have also started using it for deeper Machine Learning types of analysis - such as creating predictive models.
  • Process Engine control - we can stop/pause/start engines for various tasks.
  • Processing speed is adequate unless there are many users on at the same time.
  • Web interface is easy and intuitive, like the fact that your queries are automatically saved in tabs.
  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
Snowflake is great in quick process and ad hoc queries of JSON files (with built-in JSON support). Snowflake would not be the best alternative for sitting on top of Tableau Dashboards - mostly because of the engine being idle and filtering might take additional time. The fact that you only pay for engine time you actually use makes Snowflake is very cost-effective.
  • We are able to organize all the various data sources into one place and run Ad hoc queries against them.
  • Snowflake being very cost effective is definitely saving us $ over their competitors.
  • We are able to track KPIs across various games and compare them to each other, thus knowing where to invest our marketing dollars.
Snowflake is cheaper, but TreasureData has a better interface and much more functionality. Also, TreasureData is able to process a greater number of records more efficiently. TreasureData has the ability to run both Hive and Presto. Also, TreasureData has native APIs for many various products, as well as native SDKs. We are currently using both of them for various things.
10
We have several DBAs from Business Intelligence using Snowflake primarily to ensure the data in SnowFlake has been correctly loaded from our S3 buckets. We have several Data Analysts who run ad hoc queries, do in-depth investigations and create dashboards to be be published on Tableau. We also have several Product Managers who sometimes writer their own queries and use Tableau dashboards data analysts have created for them.
7
Three Database Administrations from the Business Intelligence department, four Data Analysts from the Data Analytics department. We load the data into Snowlfake every morning from our S3 buckets, so it is important for database administrators to ensure the data gets loaded into SnowFlake correctly. Our data analysts run ad hoc queries, do spot checks and create dashboards to be used by our Product Managers.
  • Ad Hoc Analysis of various things that are going on in our games.
  • In-Depth model building to improve our users' experience.
  • Aggregating data and create dashboards to display our KPIs to management.
  • We've been able to leverage the cost of Snowflake to get better deals out of our other vendors.
  • Machine Learning model building.
  • In-Depth analytics investigation into performance of our games.
  • Expand our portfolio of games that use SnowFlake.
  • Add data from other marketing sources into SnowFlake to integrate with gaming data.
  • Build a warehouse sitting on top of SnowFlake with aggregated data.
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to.
Return to navigation