Unclaimed: Are you working at Snowflake?
Snowflake Reviews: 4.5/5 — Highly Rated
Snowflake is a cloud-based data warehousing platform designed to efficiently store, process, and analyze large volumes of data. It stands out for its ability to scale computing and storage resources independently, allowing users to manage data and analytics workloads more flexibly. With its unique architecture, Snowflake facilitates seamless data sharing among users, enabling collaborative data-driven decision-making. It supports various data structures and types, including structured and semi-structured data, making it a versatile choice for organizations looking to harness the power of their data.
| Capabilities |
AI
API
CLI
|
|---|---|
| Ease of use |
Intermediate
Advanced
|
| Deployment | Cloud / SaaS / Web-Based |
| Support | 24/7 (Live rep), Chat, Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support |
| Training | Documentation |
| Languages | English |
Snowflake Pros and Cons
- Multi-cloud support across AWS, Azure, and Google Cloud
- Separation of compute and storage for scalable, on-demand analytics
- Native support for semi-structured data formats like JSON and Avro
- Secure data sharing without moving or copying data
- Pay-per-second pricing model for cost optimization
- Advanced capabilities might be excessive for small businesses with limited data needs
- Potential for increased costs with high data storage and compute usage
- Learning curve for users unfamiliar with cloud-based data platforms
- Dependence on internet connectivity for accessing the platform
- Limited offline capabilities
The fact that it auto scales and better manages compute and storage. Adding support for GCP is awesome.
It would be good if you could add feature to manage partitions on top of the base functionality.
modern data estate
I have been able to get some good technical advice on incorporating Snowflake. Since I started looking at Snowflake less than 2 months ago and launched our first app on it yesterday, need all the help I can get. What I love about Snowflake is its speed and flexible sizing for concurrency.
Too new for me to complain. I will need to get more experience.
Our product would not have been able to launch under Redshift because of concurrency issues on 75 terabytes of data. With Snowflake...no problem.
The title of the review says it all. Have been doing Data Management stuff for 26 years now, and Databases are at the heart of it. Nothing is like Snowflake!!!
Nothing so far. Still in implementation phase and POC has completed. The experience so far has been great.
Multiple Data Management solutions.
Cutting edge DW with ability to handle unstructured data. Splitting compute vs. storage is genius.
Sometimes being on the cutting edge has some drawbacks in terms of bugs, but that's part of the fun.
Handling unstructured data.
Snowflake is exactly as described in all their literature. There is no smoke and mirrors here, its all in the platform and it just works!
Nothing I can think of right now. Wishing more organizations will wake up and try the platform. Data Sharing would be better if more orgs were on the platform.
Less time worrying about right sizing our infrastructure for us and our clients. Lights our systems ops and really focused on providing data value to our customers.
Unlimited Concurrency is a feature of Snowflake that can not be imitated by any other DWH.
There is no nasty part as many function will be developed or complemented by the partner ecosystem.
Simultaneous execution performance struggling with Redshift or BigQuery was obtained from Snowflake.
It just works, seriously. We love the support, have had almost issues with it. The SQL dialect is pretty standard, few small quirks, but it's worth taking the time to convert your existing queries to it.
That it didn't come out sooner. The one thing is that UI is a little buggy sometimes but honestly we use various SQL IDE's like Datagrip so it's not an issue for us.
Data management, analytics, and machine learning problems.
The Snowflake Product is way ahead of its time. It is one of a kind Datwarehouse which provides enhanced performance with appropriate billing and increases productivity
Would like to see more Monitoring and Analysis options made available
Problem related to latency, performance and high billing. Snowflake has helped us resolve these problem and have increased our Productivity
The ability to take several approaches in our data warehouse modernization journey - ease of lift and shift vs total refactoring. We can enable our customers at the speed of our data without the worry of replatforming to newer on prem infrastructure.
Need a stronger set of capabilities to enable migration of large data sets.
Ease of scale to respond to heavy on demand workloads.
I like how Snowflake continuously improves it's product and no additional costs. We get new and exciting features that make our data-warehousing easier that we can start using immediately without any upgrades.
I'm sure if I thought about it long enough, I'd find something I dislike. I can't right now though.
We're trying to empower our internal users to analyze and gain insights on the data we're ingesting from out customers.
Speed of query layer (minutes/hours to seconds) ON demand utilization of compute and storage in AWS Cross-cloud support Data sharing capabilities
none.....................................................................................
cost and speed. Both were significantly improved
The ability to scale compute and pay for only what you use helps control costs and have high performing queries for your company.
There really isn't a downside to Snowflake as you can leverage multiple storage technologies and they are continuing to making the product better
Having all of our silo'd data in one centralized area where the company can utilize the data for corporate outcome initiatives
Snowflake shares make it easy for business units to consume, share and leverage out data as well as that of our business partners - securely.
Hard to think of something, features are being added all the time. They are extremely customer centric.
Sharing data with groups that can leverage the insights contained within our data.
Constant innovation to continue to be the best. They took a brilliant idea to separate compute and storage, and keep improving the scope that it can be used for, and making thins easier to maintain.
The current limitations are already being addressed, including integration with streaming data and better multi-cloud support, and replication.
Scalability and cost allocation to business units
The separation of storage and compute can not be understated. It is exceptionally easy to get started and the browser based UI make development easy.
I have yet to find a hard dislike. The IDE in browser could provide better autocomplete features.
Moving from AWS Glue and Redshift, to snowflake we save a significant amount of $.
Speed, scalability, ease, standard sql, minimal Adminstration, price, flexibility
No on premise version. I know...it doesn’t make sense as it was built for cloud....but it would be nice to have a local version
Migration from Netezza, moving warehouses to cloud, speeding up BI for big data
We were on Redshift and we could not scale. We had an engineer dedicated to keeping the lights on. It was not sustainable. Moving to Snowflake allowed us to lift and shift our data warehouse and expand to the data storage and compute that we needed to run the business with a push of a button. That headcount was moved to building features to deliver the company value.
Snowflake is a great data lake, however I think there could be growth there in order to support schemas as well as better querying.
We can scale infinitely and we can unblock teams so they aren't waiting for data. The feedback cycle has decreased. We actually spend more money on snowflake than Redshift because the data is more valuable and useful now.
Snowflake didn't just develop a cutting edge DW and stop there. Instead they ask "how can I make this better for our customers and partners" on a daily basis. These innovations show and contribute to the Blizzard that is Snowflake!
With the exceptional growth of the company, it's difficult to determine who is who, what rep is over each area, and who to reach out to to solve a problem. But this is a great problem to have - a massive growth spurt!
We are helping companies ditch legacy platforms and establish best practices for moving to the cloud. Our mutual customers have been most blown away by the scalability and query speed Snowflake provides.
We've only been using Snowflake for a couple of months, but have been extremely pleased with the performance and usability of the system. We migrated from Redshift and immediately began to see benefits to both performance and cost - the same queries were running in less time on less resources.
As of right now, the main problem with Snowflake has been the ramp to get started. There's not that many resources available for how to properly move over from Redshift/Tableau to using Snowflake and Tableau together. There were some hiccups related to the way in which Tableau reads the column names which come out of Snowflake versus how the column names are read out of Redshift.
Snowflake has been a future-proofing move for us, but we have seen benefits to both cost and performance very quickly. Overall, we are really pleased and excited to continuing to develop with the platform and seeing what it is capable of.
Our organization does not have a constant load on the database. With most solutions, this means that we normally need under powered hardware to save money, or over-sized servers to meet our peak load times. Snowflake's auto scaling and multi-cluster support have been extremely helpful.
The federated login and duo support is buggy at best. We've enforced duo login for our ACCOUNTADMIN roles, but that makes dealing with most IDEs and Tableau a nightmare since they don't support the option to use private keys. Additionally, the role based security is very hard to manage. We have 80 permission levels spread across 7 data domains. Since a user isn't able to utilize more than one role at a time, we have to then create user specific roles that inherit just their permissions. I would much rather simply assign roles to users and skip the role setting during login.
Our biggest problems have been lack of horsepower on our servers. Snowflake has allowed us to scale our infrastructure in a much more cost effective way.
Snowflakes proprietary 3 tiered architecture is enabling analytics and data science at a scale previously difficult to accomplish. My clients need instant data, real-time reporting and the flexibility to blow things up into enterprise solutions without the legacy monolithic burdens that come from traditional alternative technology stacks. Looking forward to the evolution of this already fantastic solution!
I'd like to see more product development on the wed based client for end user local file data upload. A lot of clients today aren't necessarily as technical as others and are certainly not DBAs with the skills necessary to fully exploit the power of the platform. The best client relationships come from working within an organization in the small business units that have to self-service independent from enterprise resources, we need to further enable them to succeed!
Analytics, data science, machine learning, data sharing at scale.
The ability to do datawarehousing easily on the cloud from the web browser.
I don't find anything that I didn't like so far. But the documentations can be improved.
We are organizing the data and save them into snowflake so that everyone in the company has a simple and consistent view of the data.
Learned a lot about Snowflake Technology and it is really wonderful.
Time travel should be more efficient with time series
Performance, Cost and Scalability
Snowflake is really good at isolating compute and Storage, which let us use this technology in innovative ways not possible before. We are in process of making Snowflake core technology as center of new data strategy platform.
Documentation can be a lot better as new product rollouts.
Data Lake, Analytics, Warehousing, Real time data streaming and Data Science and Machine Learning
The ability to separate functional areas of the business to their own warehouse and allow them to work in their own environment without affecting the rest of the business
The integration from Databricks if using okta
We are replacing our Hadoop environment and Datawarehouse while reducing complexity and providing a more reliable environment
Very easy to use yet very powerful. A true cloud solution for managing data.
As a new user, more readily available tutorials wold be helpful.
Scalability with large fluctuations of data ingest
The part of Snowflake I like best is the performance and seamlessness of querying against the cloud.
There is a lot to be learned for best practices for choosing data warehouse size
We are building a self-service platform with Snowflake.
Virtual data warehouses separate out compute workloads and provide isolation
Lack of intellisense Integration with PowerBI is not as tight as it needs to be.
All of them
This software is so easy to use and integrate into my existing infrastructure.
At this current time i have no dislikes of the solution
MIgration from our existing platform that we had outgrown.
Snowflake is the answer to all those data warehousing pains from those on-prem solutions. Scalability, cloning, time-travel, etc... The list just goes on and on
Nothing. Like I said best platform out there
We can have a test/dev database without all the extra hardware and software licenses. We don't have to worry about backups and restores. We can scale up during peak times and scale back down. No need for a DBA or sysadmin to service the box, add more hardware, etc.