Snowflake
by Snowflake
Top Features
Snowflake
by Snowflake
- Performance Analysis4.3
- Data Migration4.2
- Access Controls/Permissions3.9
- Backup and Recovery
- Data Replication
OTHER USERS CHOSE
- Performance Analysis5.0
- Data Migration4.5
- Access Controls/Permissions4.7
- Backup and Recovery4.6
- Data Replication4.5
Snowflake Reviews
Showing 5 of 63 reviews
Overall
4.6
Ease of Use
4.5
Customer Service
4.2
- "Best cloud data warehouse platform at the moment. Love, everything Snowflake has to offer."
- "I also very much like that role-based access is a fundamental part of it. Its data sharing features are terrific too."
- "Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large."
- "Initial upfront documentation was a little difficult to navigate but once we got a hang of it, setting up everything else was relatively simple."
- "This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about."
- "It is costly to use Snowflake so as a company you always have to fight for the value it brings to the company as a whole."
Pros
- "Best cloud data warehouse platform at the moment. Love, everything Snowflake has to offer."
- "I also very much like that role-based access is a fundamental part of it. Its data sharing features are terrific too."
Cons
- "Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large."
- "Initial upfront documentation was a little difficult to navigate but once we got a hang of it, setting up everything else was relatively simple."
- "This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about."
- "It is costly to use Snowflake so as a company you always have to fight for the value it brings to the company as a whole."
Most Recent Video User Review for Snowflake
Andrew: Hi, my name is Andrew. I am an SEO manager. I would give Snowflake a four out of five. For more views like this, click below. Prior using Snowflake, we were looking for some kind of aggregating software that would be able to take all of our different data sources and aggregate them to one data source, and Snowflake fit this bill perfectly. The reason we decided to go with Snowflake was because it is Exxon name in the industry. It's well known as an industry leader, and there really was very little consideration that went into it. Getting started with Snowflake required some initial configuration. However, for the most part, it runs in the cloud, and therefore it was really easy to get up and going with it. For any organization that is thinking about Snowflake, I'd recommend to them that they look at what data sources they want to use, and whether Snowflake is a good tool for aggregating those sources.
Snowflake is an excellent choice for centralizing data and acting as a database "hub"
4.0
Andrew B.
SEO Manager•Chemicals
Most Helpful Reviews for Snowflake
Daniel K.
EVP Operations IT
Information Technology and Services, 201-500 employees
Used the software for: 2+ years
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
November 23, 2021
"Snowflake has been a game changer"
Overall: Snowflake has been a game changer for us. It has enable all kinds of new architectures due to it's fast and low-cost performance. It has eliminated the need for so many maintenance tasks that used to be such a hassle.
Pros: Snowflake is super fast, requires virtually no maintenance (no logs, indexes, tuning, etc.) and the pay per use price model scales perfectly with cyclical workloads which are common in data warehouse applications.
Cons: It does not natively support any real constraints such as uniqueness or referential integrity which requires the user to explicitly check all these things via stored procedures. The SQL worksheet GUI still has remove to improve but they have been rapidly enhancing it. It's not too uncommon to have brief outages but they are usually resolved within a few hours.
Alternatives Considered: Azure Synapse Analytics
Reasons for Choosing Snowflake: The performance of Synapse was not nearly as good and it is essentially just SQL server running on the cloud so you still have all the annoyance of indexes, etc. to have to think about. Also the pricing model doesn't scale as well.
Switched From: Microsoft SQL Server
Reasons for Switching to Snowflake: SQL got too slow and did not scale with our business.
Reviewer Source
Source: Capterra
November 23, 2021
Verified Reviewer
Financial Services, 51-200 employees
Used the software for: Less than 6 months
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
May 5, 2022
"A fantastic data warehouse solution that solved all our problems"
Overall: I have an amazing experience using Snowflake. It is better than out previous Data Warehouse solution in everything I can think of (besides pricing). We are very satisfied with, and I feel very confident on having it as the backend of all our data needs.
It is also important to notice that we had a very pleasent experience with Snowflake's sales and account managers: they were very helpful and not pushy at all.
Pros: Snowflake is exteremely stable and easy to setup. I was able to turn it on and have a reliable Data Warehouse that didn't require me having a lot of cloud knowledge to administrate.
The database administration through the UI is intuitive and the Roles dynamic helps with implementing good data governance and compliance pratics inside the company.
Snowflake also offers user security options out of the box, which was a huge improvement for us. The doccumentation is very well written and SnowSQL offest a lot of useful functions. The main improvement on this front was how Snowflake treats JSON, which helped us a lot.
Cons: If your revenue is not on US dollars, Snowflake is an expensive product, there is no way around that. It is indeed a very good service that charges accordingly. We are using the smallest cluster possible and it was necessary to do some convincing inside the company to approve it for our budget. That being said, the smallest cluster we are using is more than enough for our needs and will be for a long time, so it will take a long time for this cost to increase again, but it was a pretty big budget increase initially.
Switched From: Amazon Redshift
Reasons for Switching to Snowflake: Amazon Redshift was very difficult to manage as a non-AWS expert. It also lacked a lot of administration and security features we needed. And even if it was cheaper at first, I kney we would run into pricing problems as we scaled, and we think these will be more manageable on Snowflake.
Reviewer Source
Source: Capterra
May 5, 2022
Subramanian S.
Senior Consultant
Information Technology and Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
Ease of Use
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
December 7, 2022
"High Performance Cloud Data DWH"
Overall: Earlier we used to have datawarehouse refreshed once a day.Now we are refreshing once every hour.Auto scale up facilities.
Pros: High PerformanceSecuredEncryption and Data Masking FeaturesMany new SQL Functions
Cons: Client Tool to Query Data needs to be improved
Reasons for Switching to Snowflake: Better Performance, Scalability
Reviewer Source
Source: Capterra
December 7, 2022
Verified Reviewer
Information Technology and Services, 10,001+ employees
Used the software for: 6-12 months
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
April 11, 2022
"How snowflake is different from other data warehouses present in the market."
Overall: Used for monitoring large amount and data and also use for analysis purposes for taking business decisions for the companies.
Pros: The best thing is snowflake is a cloud based Warehouse system.and it's completely based on shares nothing architecture so its gives faster performance during analysis.one more thing i like about this warehouse that the amount of time that you use the main warehouse here for that specific period of time you have to pay other than the warehouse is off for normal queries.particularly in dml statement mainly its uses the warehouse.so its manage automatically weather to use warehouse or not so it is very much good for saving money That's why now big giants company are shifting towards snowflake for cost effective purposes and the smarter and faster performance it gives.and it also provides a feature call time travel where you can back up your all deleted data in a period of 90 days.
Cons: There are two things I don't like about the snowflake is it's doesn't support unstructured data loading it's only support the structure and semi structure data. And other one is it's only support the bulk loading files so it's difficult for a small size files loading or adding some few columns on it.
Switched From: Vantage
Reasons for Switching to Snowflake: Need more faster and cost effective warehouse for managing data and analysing the data that's why sifted from teradata to snowflake.
Reviewer Source
Source: Capterra
April 11, 2022
Kristin G.
Business Systems Manager
Farming, 201-500 employees
Used the software for: 1-2 years
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
October 25, 2022
"Superior Cloud Warehousing Capability"
Overall: Snowflake allows us easier access to our data and integration partners are abundant
Pros: Snowflake is an industry leader and has ample connectors to all data sources. They integrate flawlessly with our BI platform and allow for management by a 3rd party. Compute power is FAST and easily scalable.
Cons: Snowflake, like most, has its own dialect for SQL - not necessarily a bad thing but something to adjust to. There is no data cap, so data usage can get expensive.
Alternatives Considered: Amazon Redshift
Reviewer Source
Source: Capterra
October 25, 2022
Compare Alternatives
Snowflake
Starting from:
$23.00/Per-Month
Pricing Model:
Flat Rate
Starting from:
Not provided by vendor
Starting from:
$25.00/Per-Month
Pricing Model:
Per User
Overall Rating:
- Ease of Use4.5
- Customer Service4.2
- Features4.4
- Value for Money4.2
Overall Rating:
- Ease of Use4.2
- Customer Service4.8
- Features4.8
- Value for Money4.3
Overall Rating:
- Ease of Use4.0
- Customer Service4.0
- Features4.2
- Value for Money4.3
Snowflake Pricing
Starting From:
$23.00 /monthPricing Model: Flat Rate
- Yes, has free trial
- No free version
Pricing Details (Provided by Vendor):
Capacity storage pricing starts at $23/TB/month.
On-demand storage pricing starts at $40/TB/month.
Snowflake pricing is based on the volume of data stored and compute time of use. For more information, please contact Snowflake Inc.
Pricing Resources:
What is Snowflake?
Database management tool assists users with data warehousing, data lakes, analytics, collaboration, and more.
Featured In
- Best Ease of Use Mobile Business Intelligence Software (2022)
Best For
Designed for businesses of all sizes in media, healthcare, finance, retail, and other industries, Snowflake is a database management tool that helps with data engineering, data exchange, and more.
Snowflake Video and Images
Deployment & Support
Deployment
- Cloud, SaaS, Web-Based
- Desktop - Mac
- Desktop - Windows
- Desktop - Linux
- Desktop - Chromebook
- On-Premise - Windows
- On-Premise - Linux
- Mobile - Android
- Mobile - iPhone
- Mobile - iPad
Support
- Email/Help Desk
- Knowledge Base
- Phone Support
- 24/7 (Live Rep)
- Chat
Training
- In Person
- Live Online
- Webinars
- Documentation
- Videos
Contact Details
- Snowflake
- Located in United States
- Founded in 2012
- https://www.snowflake.com/