Snowflake Pricing, Features, Reviews and Alternatives

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.

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.

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.

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.

Snowflake is easy to use and clear. Maybe the hardest part is to set up Roles and Policies. Overall, I think it is the easiest data warehousing in the market and works very well.

It is kind of expensive and sometimes I feel I am getting "over billed". With this I mean that some operations take extra computing time that is not really needed or there are hidden costs difficult to track. To know how much money are you spending is difficult and overall I feel like Snowflake does not want you to track billing that much.

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.

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.

The I/O operation within the database are handled well . Repeated same query results are being cached to avoid I/O operations, which is great!

The Task functionality can have a separate UI to manage the scheduled tasks . The Web workbook could have been improved with more features.