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 modern cloud based Datawarehouse solution with great features!

Rating: 7 out of 10
July 24, 2024
IncentivizedVetted ReviewVerified User
Snowflake is giving a very robust cloud-based data warehousing solution with all the benefits of going to the cloud. Data sharing is one critical area in data management and S...
Continue reading
Yogesh Kulkarni
Professional - Information Technology
Principal Consultant
Infosys
Snowflake2 years of experience

Premier data platform warehouse solution!

Rating: 7 out of 10
January 24, 2024
IncentivizedVetted ReviewVerified User
Snowflake within the organization is used as a warehouse location of data that is both refined and curated in nature and able to be used in sourcing for product use cases or o...
Continue reading
Harvey Wyche
Director - Product Management
Director of Technical Product Management
Catalina Marketing
Snowflake2 years of experience

Snowflake: a tool for all-level analysts

Rating: 10 out of 10
July 16, 2023
IncentivizedVetted ReviewVerified User
We use Snowflake to query data from AWS S3. SQL query is easy to use for all level of data analysts/data scientists and as a result, Python or R is not required to pull data f...
Continue reading
Verified user
Analyst
Snowflake3 years of experience

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

Rating: 10 out of 10
June 5, 2023
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

Unleash the power of data with Snowflake - the cloud data platform built for the future

Rating: 9 out of 10
March 9, 2023
IncentivizedVetted ReviewVerified User
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 witho...
Continue reading
Verified user
Project Manager
Snowflake2 years of experience

Don't debate, just migrate to Snowflake already.

Rating: 10 out of 10
December 21, 2022
IncentivizedVetted ReviewVerified User
We use Snowflake in our organization as both our data lake & data warehouse. Instead of ETLing from source to a data lake to then architect our data, we have made internal...
Continue reading
Jeremy Pierce, MBA
Engineer - Information Technology
Data Warehouse Engineer
Vivint
Snowflake2 years of experience

Snowflake Review

Rating: 10 out of 10
December 20, 2022
IncentivizedVetted ReviewVerified User
I work on data analysis of multiple projects and use snowflake to write queries, pull data, and do some analysis. Typically, I use Snowflake to pull data from database in orde...
Continue reading
Verified user
Analyst
Snowflake1 year of experience

Snowflake Review

Rating: 10 out of 10
December 20, 2022
IncentivizedVetted ReviewVerified User
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
Verified user
Analyst
Snowflake2 years of experience

Cloud-based Data Warehouse solution provided as a Saas.

Rating: 9 out of 10
January 17, 2022
IncentivizedVetted ReviewVerified User
Snowflake is being used as a could based data warehousing solution. We are building a data lake using Snowflake and other tools such as HVR and Dell Boomi. Currently, we are h...
Continue reading
Shiv Shrotriya
Analyst - Information Technology
datawarehousing/BI developer
Varian Medical system
Snowflake2 years of experience

Snowflake enables data pull for all levels of analysts

Rating: 10 out of 10
November 23, 2021
IncentivizedVetted ReviewVerified User
My company switched from amazon redshift to Snowflake a while ago, and we got a huge improvement in data to pull by using Snowflake. The tool is widely used in multiple depart...
Continue reading
Verified user
Analyst
Snowflake4 years of experience

What makes Snowflake amazing

Rating: 8 out of 10
November 9, 2021
Vetted ReviewVerified User
Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing them all in one single data warehouse,...
Continue reading
Verified user
Manager
Snowflake2 years of experience

Snowflake the MPP data platform of the future, today!

Rating: 9 out of 10
August 10, 2021
IncentivizedVetted ReviewVerified User
Snowflake is used as a scale-out data lake and data warehouse at Spireon. The separation of compute from storage enables the company to provide timely and scalable insights. T...
Continue reading
dave withers
Director - Engineering
Sr Director
Spireon
Snowflake7 years of experience

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

Rating: 10 out of 10
August 9, 2021
IncentivizedVetted ReviewVerified User
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 t...
Continue reading
Michael Sprague
Administrator - Information Technology
Director
Hamilton College
Snowflake3 years of experience

Data Warehousing - Snowflake gives you the best options!

Rating: 9 out of 10
May 19, 2021
IncentivizedVetted ReviewVerified User
Snowflake is the database used by my company to store data across the organization. It helps us keep the data in one place, organized, and ready to use. The main application f...
Continue reading
Rounak Verma
Analyst - Product Management
Data Analyst
Raymour and Flanigan
Snowflake2 years of experience

Managing data warehouse with Snowflake is amazing

Rating: 8 out of 10
May 9, 2021
IncentivizedVetted ReviewVerified User
Snowflake has enabled me to connect with data service providers. Through this software, I am capable of making data-driven decisions and providing my customers modern and inte...
Continue reading
Darren Mihalic
Manager - Other
Business Development Manager
Torqx Capital Partners
Snowflake2 years of experience
Log in with LinkedIn to see content from your network

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
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?

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

Cyral

Cyral

$50
per month
What is Cyral?

Cyral is a cloud-native Security-as-Code solution to protect the modern data layer. It allows engineering teams to observe, secure, and manage data endpoints in a cloud via a sidecar.

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

(355)

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.

Reviews

(1-25 of 35)
Companies can't remove reviews or game the system. Here's why

Snowflake - a modern cloud based Datawarehouse solution with great features!

Rating: 7 out of 10
Incentivized
July 24, 2024
YK
Yogesh Kulkarni
Principal Consultant
Infosys (Information Technology & Services, 10,001+ employees)
Vetted Review
Verified User
Snowflake
2 years of experience
View profile
Use Cases and Deployment Scope
Snowflake is giving a very robust cloud-based data warehousing solution with all the benefits of going to the cloud. Data sharing is one critical area in data management and Snowflake's innovative way of sharing data without physically moving it as a great feature. This is the exact needs that many of my clients had and Snowflake was just about a perfect fit!
Pros and Cons
  • Data sharing without physically moving data and without compromising security aspect
  • Unlimited scalability and elasticity (with proven client examples)
  • Almost no to very little maintenance (Snowflake takes care of it for you)
Likelihood to Recommend
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.

Premier data platform warehouse solution!

Rating: 7 out of 10
Incentivized
January 24, 2024
HW
Harvey Wyche
Director of Technical Product Management
Catalina Marketing (Marketing & Advertising, 501-1000 employees)
Vetted Review
Verified User
Snowflake
2 years of experience
View profile
Use Cases and Deployment Scope
Snowflake within the organization is used as a warehouse location of data that is both refined and curated in nature and able to be used in sourcing for product use cases or offered in the various methods of data exchange. It solves for a single location source of data truth, and is the landing place of finished data engineering product for various use cases.
Pros and Cons
  • Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
  • Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
  • Snowflake manages concurrency better in our trials than other premium competitors
  • Snowflake has little to no setup and ramp up time
  • Snowflake offers online training for various employee types
Likelihood to Recommend
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.

Snowflake: a tool for all-level analysts

Rating: 10 out of 10
Incentivized
July 16, 2023
Verified User
Vetted Review
Verified User
Snowflake
3 years of experience
Use Cases and Deployment Scope
We use Snowflake to query data from AWS S3. SQL query is easy to use for all level of data analysts/data scientists and as a result, Python or R is not required to pull data from Snowflake. Snowflake is widely used in my organization from customer acquisition to customer management.
Pros and Cons
  • Query.
  • Easy to use.
  • Low requirements.
Likelihood to Recommend
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.

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

Rating: 10 out of 10
Incentivized
June 05, 2023
DW
David Williams
Head of Engineering
Damstra Technology (Information Technology & Services, 51-200 employees)
Vetted Review
Verified User
Snowflake
2 years of experience
View profile
Use Cases and Deployment Scope
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 different databases - SQL Server, MySQL, Postgres, AWS, Azure, etc.

My challenge was to implement an awesome and consistent reporting suite that allowed customers full access to all of their data across all of our products. While the software development team is working on integrating all these disparate products, that's a significant multi-year challenge.

Implementing a data lake in Snowflake greatly empowered my team to make tremendous reporting, blending data from many sources, without adding any load to the transactional databases. What's more, Snowflake has a vast array of excellent built-in features such as row-level security, data masking, secure sharing, and other items that allowed us to push security right down to the database level so we secure data no matter how customers access it, without relying on complex where clauses, etc., in queries.

The Snowflake model of separating compute from storage and allowing us to have differing workloads for differing usage scenarios is also very helpful.
Pros and Cons
  • Security
  • Scaling
  • Support
  • Separating compute from storage
  • Flexible disparate compute models
  • Detailed history of all your queries and activity, for analysis/review/troubleshooting
  • Cloning, undeletion, sharing - all tied to how Snowflake stores data
Likelihood to Recommend
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.

Unleash the power of data with Snowflake - the cloud data platform built for the future

Rating: 9 out of 10
Incentivized
March 09, 2023
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
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
Pros and Cons
  • 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.
Likelihood to Recommend
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.

Don't debate, just migrate to Snowflake already.

Rating: 10 out of 10
Incentivized
December 21, 2022
Use Cases and Deployment Scope
We use Snowflake in our organization as both our data lake & data warehouse. Instead of ETLing from source to a data lake to then architect our data, we have made internal schemas that we can ETL the data into. We then use an on-prem SQL Server to execute our SSIS packages, which support a DSN connection.

So far it's been very easy and very successful.
Pros and Cons
  • Processing speed
  • Scaling warehouses
  • Ease of use
Likelihood to Recommend
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.

Snowflake Review

Rating: 10 out of 10
Incentivized
December 20, 2022
Verified User
Vetted Review
Verified User
Snowflake
1 year of experience
Use Cases and Deployment Scope
I work on data analysis of multiple projects and use snowflake to write queries, pull data, and do some analysis. Typically, I use Snowflake to pull data from database in order to check the current status or pull experiment results for some tests we run. I like to use app. Snowflake instead of the main site.
Pros and Cons
  • Speed
  • UI
  • Short keys
Likelihood to Recommend
Snowflake is a very good tool for analysis, easily used.

Snowflake Review

Rating: 10 out of 10
Incentivized
December 20, 2022
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
It is used by the whole company. We went with Snowflake because it is faster than Vertica and easier to manage different warehouses with.
Pros and Cons
  • Great for managing different warehouses.
  • Quick and efficient.
Likelihood to Recommend
Snowflake is very efficient for my company, and it's very easy to assign and manage different warehouses with it.

Cloud-based Data Warehouse solution provided as a Saas.

Rating: 9 out of 10
Incentivized
January 17, 2022
SS
Shiv Shrotriya
datawarehousing/BI developer
Varian Medical system (Hospital & Health Care, 10,001+ employees)
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake is being used as a could based data warehousing solution. We are building a data lake using Snowflake and other tools such as HVR and Dell Boomi. Currently, we are having different solutions used by different business teams for reporting and analytics purposes. Now we are building a centralized solution for the entire organization.
Pros and Cons
  • Cloud-based Data warehousing
  • Very fast data processing and Analytics
  • easy to learn and work
Likelihood to Recommend
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.

Snowflake enables data pull for all levels of analysts

Rating: 10 out of 10
Incentivized
November 23, 2021
Verified User
Vetted Review
Verified User
Snowflake
4 years of experience
Use Cases and Deployment Scope
My company switched from Amazon Redshift to Snowflake a while ago, and we got a huge improvement in data to pull by using Snowflake. The tool is widely used in multiple departments within the company and people with all level of data science skill and retrieve the data easily by using SQL.
Pros and Cons
  • data pull
  • access management
  • data transfer
Likelihood to Recommend
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.

What makes Snowflake amazing

Rating: 8 out of 10
November 09, 2021
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing them all in one single data warehouse, it gives access to the whole company to data in almost real time, the lag is about 5 to 30 minutes depending on the size of the DB. with this solution all teams have access to data in a single place in order to perform their respective tasks
Pros and Cons
  • Provide a front to make queries of different DBs in a single place
  • Cross tables from different schemas
  • Run complex queries faster than other providers
Likelihood to Recommend
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

Snowflake the MPP data platform of the future, today!

Rating: 9 out of 10
Incentivized
August 10, 2021
dw
dave withers
Sr Director
Spireon (Information Services, 501-1000 employees)
Vetted Review
Verified User
Snowflake
7 years of experience
Use Cases and Deployment Scope
Snowflake is used as a scale-out data lake and data warehouse at Spireon. The separation of compute from storage enables the company to provide timely and scalable insights. The confluence of streaming and batch processing at a pay-as-you-go pricing model aids in being intelligent and efficient on budget planning and use.
Pros and Cons
  • Massive parallel processing
  • SQL for schema-on-read data lakes
  • Secure and compressed storage for semi-structured data
Likelihood to Recommend
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.

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 and Cons
  • 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
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.

Data Warehousing - Snowflake gives you the best options!

Rating: 9 out of 10
Incentivized
May 19, 2021
RV
Rounak Verma
Data Analyst
Raymour and Flanigan (Retail, 5001-10,000 employees)
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake is the database used by my company to store data across the organization. It helps us keep the data in one place, organized, and ready to use. The main application for this data is to analyze and report back to the stakeholders on how the business is running. Snowflake also helps us to create tables and schemas in the existing database for sandbox analytics.
Pros and Cons
  • User friendly.
  • Easy to use even for beginners.
  • Specifically, I like the drag and drop of tables into the query which makes it easier to write complex queries.
Likelihood to Recommend
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.

This Snowflake is Unique, Fast and High Performing

Rating: 9 out of 10
Incentivized
May 02, 2021
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake was our data warehousing solution of choice, which we migrated from Treasure Data. It is used across the whole organization. It is used as a source of data for the entire organization, powering our dashboards and machine learning solutions.
Pros and Cons
  • Computation is handled under the hood, freeing resources that would be used for maintainence of clusters
  • Handling large data scale and ingestion
  • Ability to query large volumes of data with speed due to their unique architecture
Likelihood to Recommend
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.

The Snowflake data cloud is the most complete cloud data platform

Rating: 10 out of 10
Incentivized
January 07, 2021
Use Cases and Deployment Scope
Snowflake is a modern cloud data platform that InterWorks refers, resells, and implements for our data analytics clients. We also use it to back our internal data analytics initiatives within InterWorks. Customers of ours use Snowflake across every vertical and industry for any problem where they need an efficient, easy to use, scalable data environment.
Pros and Cons
  • Snowflake is very easy to use and doesn't have heavy DBA overhead.
  • Snowflake's ability to separate storage and compute is a radical departure from how databases of the past were built.
  • Snowflake is very easy for customers to scale as their needs shrink and grow.
Likelihood to Recommend
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.

Is Snowflake really nirvana for data warehousing?

Rating: 6 out of 10
Incentivized
January 05, 2021
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake was chosen as our data warehouse to replace Amazon Redshift. It is used by all areas of the company including data science, product teams, sales, marketing, operations, finance, executives, etc. It sources data from various cloud data sources and is being fed from integration tools (Fivetran, Stitch) or ETL (Matillion).
Pros and Cons
  • Can scale up or across depending on workload type
  • Separation of compute and storage
  • Query Profiler gives you a pictorial idea of where the query is spending time
Likelihood to Recommend
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.

Snowflake has worked Great in our company!

Rating: 10 out of 10
Incentivized
January 04, 2021
Verified User
Vetted Review
Verified User
Snowflake
2 years of experience
Use Cases and Deployment Scope
Snowflake is being used across all departments of the company. It's our main data warehouse and system of record for sales, inventory and other metrics of the company. Snowflake helps us address different business questions from executives and help them make decisions based on the different metrics being analyzed.
Pros and Cons
  • Snowflake computes really fast and can handle high volumes of data with ease.
  • Snowflake has some features that have really helped DBAs and developers particularly with Time Travel, it has help us with many processes in our company where we had to rollback or re-apply sweep processes which would be time consuming.
  • Snowflake has forced ETL developers to write better code (forcing ANSI standards) and avoided implicit conversions in specific data-types for different subject areas.
  • Loading processes have improved. Prior to Snowflake, some ETL processes would take double the time to execute. With Snowflake those same processes finish in half the time.
Likelihood to Recommend
- Well suited when handling high volume of data.
- In the cloud computing. Quick availability of data online.
- Data sharing across multiple departments and perhaps companies.
- Good for Archiving of data.

Snowflake is a future full stack database

Rating: 10 out of 10
Incentivized
December 28, 2020
SK
Sudarshan Kothari
Lead Analyst
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Vetted Review
Verified User
Snowflake
2 years of experience
View profile
Use Cases and Deployment Scope
Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. The ability to change the computational resources anytime is one of the biggest advantages. We have from manager to analyst been consuming the Snowflakes as a data repo. We have around a few hundred TB of data stored and it works smoothly on data growing exponentially too.
Pros and Cons
  • Hosted on cloud: Helps with scalability.
  • Community is active and ever-growing: You will have someone from the community to help whenever you need it.
  • The new functionality and thoughtful design are based on new world problems.
  • Support for JSON and XML is one of the main advantages.
Likelihood to Recommend
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.

Amazing cloud-based DB

Rating: 10 out of 10
Incentivized
November 25, 2019
TV
Torrey Vegter
Senior Data Engineer
Outsell (Marketing and Advertising, 51-200 employees)
Vetted Review
Verified User
Snowflake
2 years of experience
View profile
Use Cases and Deployment Scope
We use Snowflake on our Data Engineering team to house our data warehouse and offload a substantial amount of our ETL processes to Snowflake. Snowflake enables us to offer ultra-fast querying to the business to quickly gain insights into our current data set.
Pros and Cons
  • Extremely intuitive and easy to use querying language.
  • Allows high performance querying of large data sets with very little setup and configuration.
  • Interfaces very easily with AWS S3.
  • Works seamlessly with both structured and unstructured data sets.
  • Very granular security.
Likelihood to Recommend
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.

A vast improvement to the cloud!

Rating: 9 out of 10
Incentivized
November 20, 2019
DH
Duncan Hernandez
Product Owner, Business Intelligence
Answer Financial Inc. (Insurance, 201-500 employees)
Vetted Review
Verified User
Snowflake
3 years of experience
View profile
Use Cases and Deployment Scope
Snowflake is being used on top of our Azure data warehouse. It solves our issue of queries running at the same time and has drastically improved our server performance. All of our reports connect to Snowflake and they all run very fast. It is currently being used across the entire company.
Pros and Cons
  • You are able to adjust the power that you give a query. For the big queries, you can give more CPU to it so it runs faster.
  • It can now sit on Google Cloud, S3, and Azure.
  • Concurrency is a thing of the past.
Likelihood to Recommend
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.

Extremely fast and efficient data warehouse tool.

Rating: 9 out of 10
Incentivized
July 31, 2019
Use Cases and Deployment Scope
Snowflake was implemented around 6 months ago to replace Redshift as the SQL level that allows us to query our data. Snowflake enables us to query our data quickly and effectively to get insights into various aspects of the program as well as various aspects of our users' behavior. It allows us to make smarter business decisions by making that data more readily available and reliable than our previous solution was.
Pros and Cons
  • Resources that scale up and down automatically to ensure that queries run quickly and efficiently without paying for computing power that is not being used
  • Much more reliable than our previous software
  • No noticable limit to query size
  • Runs very quickly
Likelihood to Recommend
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.

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

Rating: 9 out of 10
Incentivized
June 20, 2019
Verified User
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 and Cons
  • 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.
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's ease of use allows you to focus on what matters most - the data you're filling it with

Rating: 9 out of 10
Incentivized
June 10, 2019
AG
Andrew Goss
Data Engineer
Interfolio (Internet, 51-200 employees)
Vetted Review
Verified User
Snowflake
1 year of experience
Use Cases and Deployment Scope
My company adopted Snowflake as our first cloud-based data warehouse. It is being used as a central repository for all company data from each business unit for the purposes of business intelligence.
Pros and Cons
  • Ease of use
  • Separation of storage and compute resources
  • Simple to scale up or down with virtual warehouses
  • Built-in support for the most popular data formats
  • Standard SQL dialect
  • Robust function library
Likelihood to Recommend
Snowflake architecture was designed at its foundation to take advantage of the cloud and then adds some unique benefits that support ease of use and increased productivity. The most popular cloud data warehouse platforms are all powerful tools and solid choices. With an investment in one of these, what really matters is how productive will you be using the data warehouse.

Snowflake's 'data-warehouse-as-a-service' model lessens the maintenance tasks of optimization/tuning that have traditionally fallen to DBAs and ETL developers. There are no servers to manage, software to install, or indexes to tune. This allows data engineers and analysts to focus more exclusively on analytic tasks that will translate into growth for the company.

While Snowflake doesn’t have all the performance optimization bells and whistles of other cloud data warehouse platforms, this is actually a good thing and that most people don't really need all of them or miss them. Using Snowflake on the whole means less knob-turning and futzing with setup/tweaking. Snowflake has its query optimizer already built-in.

Snowflake - flexible and isolated workloads

Rating: 9 out of 10
Incentivized
June 06, 2019
JB
Jacob Biguvu
Database Engineer/DBA (Cloud and On-Premises)
Capital One (Financial Services, 10,001+ employees)
Vetted Review
Verified User
Snowflake
1 year of experience
View profile
Use Cases and Deployment Scope
Capital One has many LOBs (lines of business). I have supported IAM and Commercial LOBs. They are using Snowflake as a data warehouse solution. The team is also using Redshift. The team noticed the concurrency limit with Redshift. Snowflake is a simple architecture with isolated compute capabilities. Redshift does not separate storage and computer capacities. Based on the workloads, the capacity is scaled up and scaled down using the option: Dataware. Right now, Snowflake is the heart-cake requirement for the company.

Pros and Cons
  • The beauty of Snowflake is virtual warehouses. This provides an isolated workload and capacity (Virtual warehouse ). This allows separating or categorizing workloads and query processing according to our requirements.
  • Snowflake provides a unique architecture that supports structured and semi-structured data. provides the ready-made solutions to process with the semi-structured data such as JSON, Avro, ORC, Parquet, and XML
  • SQL kind queries make easy to write/develop the code. Provided features such as materialized views to optimize the query processing and loads
  • Snowflake database is managed by snowflake team. This simplifies the DBA job from maintenance kinds of tasks such as patchworks and regular upgrades.
Likelihood to Recommend
Snowflake is best for a data warehouse. When you want to compute capacities separately to manage the workloads independently, Snowflake is the best option, because it provides isolated virtual warehouses.
Return to navigation