Snowflake Reviews & Insights

Score8.9 out of 10

373 Reviews and Ratings

Community insights

TrustRadius Insights for Snowflake are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

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.

Snowflake Reviews

19 Reviews

Enterprises (1,001+ employees)

Snowflake: Very Flexible Data Warehouse with Great, Scalable Capabilities

Rating: 9 out of 10

Incentivized

December 19, 2024

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.

Verified User

Professional in Corporate (Insurance company, 1001-5000 employees)

Vetted Review

5 years of experience

Performs well

Rating: 8 out of 10

Incentivized

December 18, 2024

Use Cases and Deployment Scope

we use it to find information on orders and supply chain issues. we also use it for various AI/ML and data science projects.

Pros

seems to scale well when needed
good at storing lots of data
modern and performant

Cons

speed could still be faster without requiring more compute
cheaper cost
more robust sql editor

Likelihood to Recommend

good for structured data, not so good if the data is unstructured. seems well suited for most companies that have / had traditional ERP setups.

Matt Lee

Sr Data Analyst at Apple (Computer Hardware, 10,001+ employees)

Vetted Review

4 years of experience

Verified on LinkedIn

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

Rating: 10 out of 10

Incentivized

December 13, 2024

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.

Sahil Khan

Data Analyst in Product Management at Numerator (Market Research, 1001-5000 employees)

Vetted Review

3 years of experience

View profile

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

Processing speed
Scaling warehouses
Ease of use

Cons

Hard to say, they're adding new features all the time.
I feel like Snowflake's documentation is a little too thorough, it can be hard to understand
I'm not a fan of the web interface, I use DBeaver instead.

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.

Jeremy Pierce, MBA

Data Warehouse Engineer in Information Technology at Vivint (Wholesale, 10,001+ employees)

Vetted Review

2 years of experience

View profile

Snowflake Review

Rating: 10 out of 10

Incentivized

December 20, 2022

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

Speed
UI
Short keys

Cons

Auto formatting
Organizing multiple queries/projects

Likelihood to Recommend

Snowflake is a very good tool for analysis, easily used.

Verified User

Analyst in Finance and Accounting (Information Technology & Services company, 5001-10,000 employees)

Vetted Review

1 year of experience

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

Rating: 7 out of 10

Incentivized

December 19, 2022

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

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)

Cons

Graphical user interface for developers to build their applications
In-built CI-CD integration capabilities
In-built data lineage capabilities

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.

Yogesh Kulkarni

Principal Consultant in Information Technology at Infosys (Information Technology & Services, 10,001+ employees)

Vetted Review

2 years of experience

View profile

Cloud-based Data Warehouse solution provided as a Saas.

Rating: 9 out of 10

Incentivized

January 17, 2022

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

Cloud-based Data warehousing
Very fast data processing and Analytics
easy to learn and work

Cons

limitation with unstructured data
while importing data from other sources only bulk load

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.

Shiv Shrotriya

datawarehousing/BI developer in Information Technology at Varian Medical system (Hospital & Health Care, 10,001+ employees)

Vetted Review

2 years of experience

What makes Snowflake amazing

Rating: 8 out of 10

Incentivized

November 9, 2021

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

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

Cons

Graphic outputs
Dashboard creation

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

Verified User

Manager in Product Management (Financial Services company, 5001-10,000 employees)

Vetted Review

2 years of experience

Data Warehousing - Snowflake gives you the best options!

Rating: 9 out of 10

Incentivized

May 19, 2021

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

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.

Cons

I am not able to recover the query sheets which got deleted by mistake.
Higher prices.
Easier integration option with BI tools.

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.

Rounak Verma

Data Analyst in Product Management at Raymour and Flanigan (Retail, 5001-10,000 employees)

Vetted Review

2 years of experience

Snowflake has worked Great in our company!

Rating: 10 out of 10

Incentivized

January 4, 2021

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

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.

Cons

Integration with other tools, particularly with connectivity. We have observed metadata callbacks being generated which are time consuming and annoying. These can be avoided but extra work is required.
Out of the box tools could be better. Specifically the querying tool is lacking a few features that other software offer for easy of use for users and developers.
Not really a Con, but in Snowflake there's no concept for Indexes, maybe because they are not required but we have seen particular cases where we believe an index would help speed some of the queries being executed.

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.

Verified User

Engineer in Information Technology (Retail company, 10,001+ employees)

Vetted Review

2 years of experience

Loading Reviews List....

Snowflake has worked Great in our company!

Rating: 10 out of 10

Incentivized

January 4, 2021

Use Cases and Deployment Scope

Pros

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.

Cons

Integration with other tools, particularly with connectivity. We have observed metadata callbacks being generated which are time consuming and annoying. These can be avoided but extra work is required.
Out of the box tools could be better. Specifically the querying tool is lacking a few features that other software offer for easy of use for users and developers.
Not really a Con, but in Snowflake there's no concept for Indexes, maybe because they are not required but we have seen particular cases where we believe an index would help speed some of the queries being executed.

Likelihood to Recommend

Verified User

Engineer in Information Technology (Retail company, 10,001+ employees)

Vetted Review

2 years of experience