Snowflake is a future full stack database
December 28, 2020

Snowflake is a future full stack database

Sudarshan Kothari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Modules Used

  • Snowflake Data Marketplace

Overall Satisfaction with Snowflake

Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. The ability to change the computational resources anytime is one of the biggest advantages. We have from manager to analyst been consuming the Snowflakes as a data repo. We have around a few hundred TB of data stored and it works smoothly on data growing exponentially too.
  • Hosted on cloud: Helps with scalability.
  • Community is active and ever-growing: You will have someone from the community to help whenever you need it.
  • The new functionality and thoughtful design are based on new world problems.
  • Support for JSON and XML is one of the main advantages.
  • Beta testing functionality needs to be properly tested and stick to the committed deadline set at the initial release.
  • The ODBC connector could be improved to accommodate multiple roles.
  • Updates on functionality need to be informed to the user. Just a document update might not be the right approach every time.
  • Snowflake turned out to be a single platform that is pay per use.
  • It's becomes challenging when data needs to physical separate for security reasons.
  • Usage of Snowflake from one team has increased to the entire organization in 2 years.
Accommodates future data types such as JSON and XML. Scalability is another advantage. Pay per use is beneficial for organizations like yours. Direct connectors with AWS help us to go with it. No limit on user creation and clone data not eating up extra disk space are a few reasons why Snowflake was chosen.

Do you think Snowflake delivers good value for the price?

Yes

Are you happy with Snowflake's feature set?

Yes

Did Snowflake live up to sales and marketing promises?

Yes

Did implementation of Snowflake go as expected?

Yes

Would you buy Snowflake again?

Yes

Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage. The only scenario where Snowflake would require second thought would be data that has PII information, as it doesn't have encryption options for such data points.