What do you like most about Snowflake?
Thanks for sharing your thoughts with the community!
The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
I like the idea that you can assign roles and responsibilities, limiting access to data.
It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.
The snapshot feature is good, the rollback feature is good and the interface is user-friendly.
The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.
The initial setup is straightforward. You just need to follow the documentation.
They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.
The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.
As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.
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.