What is Snowflake?
Pros from reviewers
-
Quick and cost-effective performance: Snowflake's speed and cost-effectiveness allow for the creation of new architectures, eliminating many maintenance tasks that were previously troublesome
-
Stability and ease of setup: Snowflake is incredibly stable and easy to set up, requiring little cloud knowledge to manage, making it a user-friendly tool
-
Role-Based Access Control (RBAC): Snowflake's detailed RBAC allows for extensive customization and security governance, providing team access to Infrastructure as Code (IaC)
-
Time travel feature: Snowflake has a time travel feature that allows users to back up all deleted data within a 90-day period, providing an additional layer of data security.
-
Pay-per-use pricing model: Snowflake's pricing model scales perfectly with the cyclical workloads common in data warehouse applications, making it a cost-effective solution
Cons from reviewers
-
High cost for non-US dollar revenue businesses: If your revenue isn't in US dollars, Snowflake can be costly, making it a less attractive option for businesses operating in other currencies
-
Difficulty in loading unstructured data: Snowflake does not support unstructured data loading, only structured and semi-structured data, making it less versatile for certain data management tasks
-
Hidden costs and difficulty in monitoring expenditure: Snowflake can occasionally feel overpriced due to additional computing time for certain operations or hidden costs that are difficult to track, making expenditure monitoring challenging.
-
Lack of inherent support for features like uniqueness or referential integrity: Snowflake does not inherently support features like uniqueness or referential integrity, requiring users to verify these things through stored procedures
-
High default pricing and challenging user configuration: The default pricing for Snowflake is high, and user configuration can be more challenging than it should be, potentially creating barriers for new users
Main features
Starting Price
Free Plan
Build a product for the future
Join the data cloud community
Empower your data with Snowflake’s AI-powered capabilities
Collaborate across multiple platforms
Benefit from full support
Starting Price
N/A
Free Plan
No
Build a product for the future
Join the data cloud community
Empower your data with Snowflake’s AI-powered capabilities
Collaborate across multiple platforms
Benefit from full support
How Snowflake compare to similar software?
Product
Price
N/A
Free plan
No
Main features
Pros
Cons
Alternatives
Deal
No available deal at the moment
Confluent and Snowflake are prominent data management solutions with distinct focuses, designed to cater to different aspects of data handling and analysis. As you consider which platform is best for your business needs, it's important to understand the key differences between them.
Confluent is built around Apache Kafka and excels in real-time data streaming capabilities. It allows organizations to process and analyze data as it arrives, which is crucial for scenarios where immediate data utilization can drive significant business value. Confluent’s platform facilitates continuous data ingestion, processing, and re-distribution across company systems, making it a powerful tool for businesses that rely on timely data for operational decision-making. This makes Confluent particularly suitable for industries such as financial services, telecommunications, and online services, where real-time data stream processing is essential.
In contrast, Snowflake focuses on cloud-based data...
Who is Snowflake best for according to our reviewers?
Data Warehouse Users: These users appreciate Snowflake's quick and cost-effective performance, eliminating many maintenance tasks. They find the pay-per-use pricing model scales perfectly with the cyclical workloads common in data warehouse applications
Data Governance and Compliance Officers: These users find Snowflake's dynamic Roles feature helpful in implementing good data governance and compliance practices. They also appreciate the user security options that Snowflake offers right out of the box
Business Decision Makers: These users use Snowflake to monitor and analyze large amounts of data for business decisions. They appreciate its cloud-based warehouse system, which provides faster performance and is cost-effective
Infrastructure as Code (IaC) Users: These users find Snowflake's well-managed Terraform package useful as it provides team access to Infrastructure as Code. They also appreciate the detailed Role-Based Access Control for extensive customization and security governance
Database Administrators: These users find Snowflake to be a reliable and excellent tool. They appreciate its simplicity and clarity, although configuring Roles and Policies can be a bit tough. They believe it's the simplest data warehousing tool available and it performs exceptionally well.
Snowflake Reviews
4.6
Snowflake rating
4.5
Ease of use
4.2
Customer service
4.2
Value for money
4.4
Likelihood to recommend
4.4
Features
19 Snowflake Reviews
-
Zoe J
Effortless Cloud Data Management with Snowflake
I consider Snowflake to be a reliable and excellent tool. I appreciate its simplicity and clarity, although configuring Roles and Policies can be a bit tough. I believe it's the simplest data warehousing tool available and it performs exceptionally well. However, it's somewhat pricey and I occasionally feel overcharged due to additional computing time for certain operations or hidden costs that are difficult to track. Monitoring expenditure is challenging, and it seems like Snowflake doesn't promote tracking of billing. I switched to Snowflake from Oracle because it's outdated, costly, and not a cloud data warehouse.
June 2, 2024
-
Juan
Snowflake: The Ultimate Cloud Database for Building Your Data Warehouse
I would give Snowflake a perfect score of 10 out of 10. As someone with an ORACLE background, I truly value this product. It removes the need for database management tasks as Snowflake takes care of it. The I/O operations within the database are well handled. It even caches repeated queries to prevent unnecessary I/O operations, which is amazing! However, I believe the task functionality could be enhanced with a separate UI for managing scheduled tasks and the Web workbook could use more features. I chose Snowflake because it excellently manages I/O operations within the database.
May 25, 2024
-
Megan Garcia
Essential Data Warehouse Solution for Businesses
I find Snowflake to be feature-rich and user-friendly. Its well-managed Terraform package provides team access to Infrastructure as Code (IaC). The detailed Role-Based Access Control (RBAC) allows for extensive customization and security governance. However, the cost can be high if warehouse expenses are not tracked and alerts are not set.
May 18, 2024
-
Brenda
Snowflake: A Superior Data Warehouse Solution that Tackled All Our Challenges
My experience with Snowflake has been excellent. It outperforms our previous Data Warehouse solution in every way, except for the cost. I feel confident using it as the foundation for all our data needs and have had a positive experience with Snowflake's sales and account managers, who were supportive without being intrusive. Snowflake is incredibly stable and easy to set up, requiring little cloud knowledge to manage. The database administration UI is intuitive, and the dynamic Roles feature helps in implementing good data governance and compliance practices. Snowflake also offers user security options right out of the box, a significant upgrade for us. The documentation is well-written, and SnowSQL provides many useful functions. A significant improvement is how Snowflake manages JSON, which has been very beneficial. However, if your revenue isn't in US dollars, Snowflake can be costly. Despite this, it's a high-quality service that charges accordingly. We're using the smallest possible cluster, which required some internal persuasion to fit into our budget.
May 12, 2024
-
Samantha G
Efficient Data Management with Improved Software
its ability to handle large volumes of data with ease has significantly improved our data management processes. The speed and efficiency of the software are commendable
May 6, 2024
-
Diana M
Snowflake: Uniquely Tailored to Our Needs
My overall experience with Snowflake has been enjoyable, despite some occasional frustrations. These challenges have helped me grow as a programmer and SQL developer. I now see Snowflake as an old friend. What I value most about this software is its versatility - if you can think it, you can do it with Snowflake, as long as it involves data. I initially used Oracle at my company, but we soon switched to Snowflake, which significantly improved my SQL knowledge. I started using more advanced features like CTEs and partitions, which Snowflake made easy to understand and learn. I'm impressed by its ability to handle a large number of columns. There is a slight learning curve, but fundamentally, it's like any other SQL language with its own unique quirks. I wish it could provide data instantly and intuitively understand my needs, but that's virtually impossible. I switched to Snowflake because my company did, and I had to adapt or risk being left behind.
April 30, 2024
-
Charles D
Snowflake: Exceptional Data Warehousing Tool
I have found Snowflake to be an exceptional tool for data warehousing
April 21, 2024
-
Larry M
Snowflake: Excellent Data Sharing for Peace of Mind
it has given us peace of mind knowing that our sensitive data is well-protected. The data sharing capabilities of Snowflake are excellent
April 13, 2024
-
Kenneth Rodriguez
Snowflake: A Revolutionary Game Changer
Snowflake has been a game changer for me. It has allowed for new architectures due to its quick and cost-effective performance, eliminating many maintenance tasks that were previously troublesome. It's incredibly fast, requires almost no maintenance, and its pay-per-use pricing model scales perfectly with the cyclical workloads common in data warehouse applications. However, it doesn't inherently support features like uniqueness or referential integrity, requiring me to verify these things through stored procedures. The SQL worksheet GUI could be better, and brief outages are not rare, but they're usually resolved within a few hours. I chose Snowflake over Synapse because the latter's performance wasn't as good and its pricing model didn't scale as well. I switched to Snowflake because SQL was too slow and didn't scale with my business.
April 13, 2024
