Snowflake Reviews and Ratings

Rating: 8.7 out of 10

Score

8.7 out of 10

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.

Reviews

44 Reviews

Snowflake Cloud Data Management Performance Review

Rating: 7 out of 10

February 26, 2026

Use Cases and Deployment Scope

We use Snowflake as one of our cloud data management platforms, and the main problems it solves for us are

a) Serving as a data repository and an analytics engine for both our structured and unstructured data, from which we can extract real business intelligence, in real time.

b) It also serves as a Data Lake where raw data is can be dumped irrespective of the format it is in, without worrying about our compute and storage constraints.

c) Lastly, we also use if for clean rooms and secure data sharing which is especially important when doing M&A deals and due diligence.

Pros

Handles both structured and unstructured data
Compute and Storage scale automatically
Powerful analytics and data visualization capabilities
Secure data sharing solution

Cons

Does not handle multi-cloud data portability very well
It is not 100% vendor agnostic and hence not "open" in the true sense of the word
It is not our first choice for engineering, AI and ML related work and applications

Likelihood to Recommend

Excellence for data storage across formats, especially for teams that live and breathe SQL (analysts, consultants etc.). However, the lack of a truly open architecture means that SI can be a bit of a headache in a multi/hybrid cloud environment. Also, it does not lend itself work to AI/ML application use/development.

Prateek Rao

Partner and MD at Roland Berger in Professional Services at Deloitte (10,001+ employees)

Vetted Review

6 years of experience

Verified on LinkedIn

Snowflake a great data warehousing tool.

Rating: 9 out of 10

Incentivized

January 17, 2025

Use Cases and Deployment Scope

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 access control, and implementing masking policies. We create pipelines using tools like Azure Data Factory, airflow, and Matillion to bring clients' raw data into a Snowflake. Then, we create procedures and tasks on top of them to clean that data and transform the data for reporting purposes, and then we use the Snowflake consumption layer for all our reporting purposes and create reports out of it. We also use Snowsight for some of the Snowflake usage reports, such as cost monitoring and query monitoring. We have also made use of the dynamic table tables where we had a requirement to refresh the tables on an hourly basis so that we don't have to create multiple elements like task stream. The dynamic table can take care of everything.

Pros

Creating Procedures.
Python integration.
Snowsight for reports.
Data masking.
RBAC

Cons

Subquery.

Likelihood to Recommend

Snowflake is well suited when you have to store your data and you want easy scalability and increase or decrease the storage per your requirement. You can also control the computing cost, and if your computing cost is less than or equal to 10% of your storage cost, then you don't have to pay for computing, which makes it cost-effective as well.

Verified User

Engineer in Information Technology (501-1000 employees)

Vetted Review

3 years of experience

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 (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 (10,001+ employees)

Vetted Review

4 years of experience

Verified on LinkedIn

Fastest Cloud-Base Data Storage in the world.

Rating: 9 out of 10

Incentivized

December 17, 2024

Use Cases and Deployment Scope

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 provides more advanced functions, such as LISTAGG, which is not available on other cloud platforms.

Pros

Fast Query.
Reliable
Simple to Use.
Dark Mode.

Cons

Python files.
Import Python files from notebooks.
When pinning a table, the pinned items should always be visible.

Likelihood to Recommend

If you need a quick query, snowflake is the way to go. It's super simple and scalable; we were struggling before with Azure, and with Snowflake, everything runs smoothly, and we have more control over our schemas and warehouses. Snowflake, in my opinion, is the next step when you want to scale your business and manage data. If your company is still small, there may be cheaper options.

Verified User

Analyst in Research & Development (501-1000 employees)

Vetted Review

2 years of experience

Scalable cloud data warehouse with fair pricing

Rating: 10 out of 10

Incentivized

December 17, 2024

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.

Verified User

Professional (501-1000 employees)

Vetted Review

5 years of experience

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 (1001-5000 employees)

Vetted Review

3 years of experience

View profile

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

Rating: 9 out of 10

Incentivized

March 9, 2023

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

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.

Cons

Data visualization capability has improved though have lot of areas of improvement
Data governance and catalog capabilities

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.

Verified User

Project Manager in Information Technology (501-1000 employees)

Vetted Review

2 years of experience

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 (10,001+ employees)

Vetted Review

2 years of experience

View profile