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
-
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
-
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.
Cons from reviewers
-
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 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
-
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
-
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.
Main features
Starting Price
Free Plan
Benefit from full support
Optimize your business finances
Build a product for the future
Significantly improve your brand awareness
Join the data cloud community
Starting Price
N/A
Free Plan
No
Benefit from full support
Optimize your business finances
Build a product for the future
Significantly improve your brand awareness
Join the data cloud community
What is Snowflake?
How Snowflake compare to similar software?
Product
Snowflake
5.0
Snowflake reviews
Price
N/A
Free plan
No
Main features
Pros
Cons
Alternatives
Deal
No available deal at the moment
Snowflake
vs
AWS Activate
Snowflake and AWS (Amazon Web Services) are both formidable players in the world of cloud data warehousing and analytics. While they share common ground in providing data solutions, they have distinct differences that make them suitable for various business needs.
One fundamental difference lies in their offerings. Snowflake is renowned for its specialization in cloud data warehousing. It provides a comprehensive platform solely focused on data storage, processing, and analytics. Snowflake's architecture is designed with a multi-cluster, multi-cloud approach, offering unique features such as data sharing and a separation of storage and compute resources.
On the other hand, AWS is a comprehensive cloud computing provider that encompasses a vast array of services beyond data warehousing. Amazon Redshift, AWS's data warehousing solution, is just one piece of its extensive cloud ecosystem. AWS caters to businesses seeking not only data warehousing but also compute, storage, machine...
Snowflake
A platform to increase the growth of your startup
AWS Activate
Amazon's cloud services platform
Snowflake
vs
Microsoft Azure
When evaluating Snowflake and Azure, it's crucial to understand their key differences to make an informed decision for your data management and analytics needs. The primary distinction between these two cloud data platforms lies in their use cases and offerings.
Snowflake is primarily known for its robust and cloud-native data warehousing capabilities. It is designed to handle data storage, processing, and analytics in a scalable and flexible manner. Snowflake excels in providing a platform that can accommodate a wide range of data workloads and use cases, making it suitable for organizations looking to modernize their data infrastructure and harness the power of cloud analytics. Its architecture allows for seamless scaling and efficient data sharing among users and partners.
On the other hand, Azure is a comprehensive cloud ecosystem offered by Microsoft. Within Azure, you'll find various data services, including Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse),...
Snowflake
A platform to increase the growth of your startup
Microsoft Azure
Empowering your cloud journey with Microsoft Azure
$25,000 in Azure Cloud credits for 1 year on Microsoft Azure
Save up to $25,000
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
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
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
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
5.0
Snowflake rating
4.5
Ease of use
4.2
Customer service
4.2
Value for money
4.4
Likelihood to recommend
4.4
Features
4 Snowflake reviews
-
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
