Item: Snowflake
Rating: 10
Author: Sahil Khan

Overall Satisfaction with Snowflake

Use Cases and Deployment Scope

At Numerator, Snowflake is used as a cloud based data storage platform and it also provides robust data warehousing solutions. The amount of data at Numerator is at a very large scale and it is growing very fast, Snowflake manages this large volume of data very efficiently. We also use Snowflake for analytical purposes, it provide us a platform to run SQL queries to analyze our data and create dashboards.

Pros and Cons

Pros

Snowflake provides faster data warehousing solutions.
Snowflake can be easily integrated and connected with other third party tools.
Snowflake does well in ETL and ELT task.

Cons

Snowflake can provide more data visualization options in their worksheets.
In Snowflake worksheet, the query results are cached for 24 hours and it is not possible to see the query result after 24 hours. Snowflake can provide option to see query results even after 24 hours, that will be very helpful.
Snowflake can implement more data masking and encryption options.

Return on Investment

With separate compute and storage feature, the queries get executed quickly and it improves our overall productivity.
Earlier we were using a different product for analytical purposes, but with Snowflake's in-built analytical feature we are now able to save money.
Snowflake is cost efficient, features like auto suspend for compute resources helped to control the costs.

Usability

Snowflake has faster query performance, it allows our team to analyze the data quickly and deliver the insights, which improves the overall productivity. Snowflake is very scalable, it easily handles growing data and workloads as per the demand with less investments . Snowflake can be easily integrated with other third party tools which gives more flexibility.

Key Insights

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?

I wasn't involved with the selection/purchase process

Did implementation of Snowflake go as expected?

Yes

Would you buy Snowflake again?

Yes

Other Software Used

dbt, Apache Airflow, Atlassian Confluence

Likelihood to Recommend

Snowflake is very well suited for all data storage and data warehousing needs of your business. As Snowflake is a cloud based platform, so you only pay for what you use, independent of the scale of your business. Snowflake can be used to store your data securely. Snowflake is slightly less appropriate for analytical purposes because it provides very limited data visualization options with very less feature.

Comments

Please log in to join the conversation

Snowflake - a scalable, secure and cost effective cloud based data storage platform.