How has it helped my organization?
We were using MySQL and MongoDB for our regular operations but when we grew, we were forced to handle a huge number of datasets. We could have petabytes of data in and out on a regular basis. We struggled a lot to complete the operations in a timely manner. With Amazon Redshift, we gained a lot in terms of timing, as well as project completion. Even-through we are happy with Redshift, in terms of pricing and availability of nodes, I am more comfortable with Snowflake. Some of the scoring mechanism really works well in the distributed architecture of Snowflake.
What is most valuable?
- Scalability. This solution has the ability to load a huge number of datasets (I have experience with petabytes of data) and process them. Storage is not limited, and we can increase what we want.
- Performance. The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs.
- Flexibility. This feature is helpful for the user to increase the node size and config depending on their need. There is no need to wait for hardware to be in place whenever we increase the dataset. Snowflake provides the option to increase the node or cluster size whenever required.
- Multi-formatted accessibility. The Snowflake engine has the capability to read the following file formats: CSV, DELIMITER, FIXEDWIDTH, AVRO, JSON, BZIP2, GZIP, LZOP. The user can choose which format is best for their requirements.
- Configuration. Even though its running in the AWS platform, it beats their platform product. I feel more flexible with this solution than I do with Redshift.
- Snowpipe. Snowpipe is a better system to feed stream data to the Snowflake database.
What needs improvement?
Snowflake has to improve their spatial components since it doesn't have much in terms of geo-spatial queries.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
How are customer service and technical support?
It's really good. I am happy with the product and the service.
Which solution did I use previously and why did I switch?
With Amazon Redshift, we gained a lot in terms of timing as well as project completion. Even through we are happy with Redshift, in terms of pricing and availability of nodes, I am more comfortable with Snowflake.
How was the initial setup?
The initial setup of Snowflake is very simple and straightforward. We do not need to read or understand any of the technical documentation. It is a plug-and-play service or platform.
What about the implementation team?
I have implemented this solution through an in-house team.
What was our ROI?
I can't directly convey ROI because we are not using only Snowflake. We are using multiple products to increase our revenue and decrease time consumption. This makes it difficult to calculate ROI.
Which other solutions did I evaluate?
I have experience working in Hadoop & Redshift as well. When I compare the three (Snowflake, Hadoop, and Redshift), Snowflake is more user-friendly in terms of configuration and maintenance.