Snowflake
What Is Snowflake?
Database management tool assists users with data warehousing, data lakes, analytics, collaboration, and more. Read lessWho Uses Snowflake?
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.
Not sure about Snowflake?
Compare with a popular alternative
Snowflake
Other great alternatives to Snowflake
Reviews of Snowflake
Daniel
Alternatives Considered:
Snowflake has been a game changer
Comments: 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.
Verified Reviewer
A fantastic data warehouse solution that solved all our problems
Comments:
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.
Subramanian
High Performance Cloud Data DWH
Comments: 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
Verified Reviewer
How snowflake is different from other data warehouses present in the market.
Comments: 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.
Kristin
Alternatives Considered:
Superior Cloud Warehousing Capability
Comments: 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.
