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.

Reviews

43 Reviews

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

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 (5001-10,000 employees)

Vetted Review

1 year of experience

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

Rating: 9 out of 10

Incentivized

December 20, 2022

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

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

Cons

There is no support for triggers
Materialised views are limited to only one table
You can't create dynamic SQL in functions

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.

David Williams

Head of Engineering in Information Technology at Damstra Technology (51-200 employees)

Vetted Review

2 years of experience

Verified on LinkedIn

Loading Reviews List....

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

Rating: 9 out of 10

Incentivized

December 20, 2022

Use Cases and Deployment Scope

Pros

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

Cons

There is no support for triggers
Materialised views are limited to only one table
You can't create dynamic SQL in functions

Likelihood to Recommend

David Williams

Head of Engineering in Information Technology at Damstra Technology (51-200 employees)

Vetted Review

2 years of experience

Verified on LinkedIn