TrustRadius Insights for Snowflake are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Intuitive User Interface: Users have consistently praised Snowflake's intuitive and easy-to-use interface, with many stating that it is beginner-friendly. The drag and drop feature for tables into queries has been particularly helpful for users when writing complex queries.
Advanced Security Features: Snowflake's security features have received high praise from users, who feel confident in connecting with numerous business partners due to the platform's advanced security measures and effective programming. This positive sentiment indicates that Snowflake successfully prioritizes data protection and privacy.
Seamless Data Integration: Users appreciate Snowflake's ability to integrate, analyze, and transfer data from multiple clouds. They find it easy to have a transparent idea about data extraction and transfer. This feature allows users to efficiently work with their diverse datasets across different cloud platforms without any hassle or complications.
My company switched from amazon redshift to Snowflake a while ago, and we got a huge improvement in data to pull by using Snowflake. The tool is widely used in multiple departments within the company and people with all level of data science skill and retrieve the data easily by using SQL.
Pros
data pull
access management
data transfer
Cons
speed
data type
better integration
Likelihood to Recommend
Snowflake is suitable for the situations that you are working with all levels of analysts in terms of data science skills. By using SQL, the user does not need to understand data type, etc. before using the tool. However, it could be potential trouble when consuming the data in python later.
VU
Verified User
Analyst in Corporate (Cosmetics company, 10,001+ employees)
A few months ago, we'd decided to migrate our on-premise BI stack to cloud as on-premise solutions were not able to meet growing demands. Clearly, we were looking for cloud-only solutions. After extensive research and POC of several tools, we've on-boarded Snowflake. Snowflake is primarily used by the BI developers as our primary data warehouse and the resulting data is used by the whole organization via the dashboard or Excel extracts. Impressive data compression rate and faster data retrieval make it the best choice as an enterprise data warehouse.
Pros
Impressive data retrieval and data compression ratio.
Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
Extensive usages documentation with examples makes development easy.
Cons
Stored procedures are implemented through JavaScript. Would be an additional overhead if your team doesn't have expertise.
No option to run multiple queries and analyze the results set in the same console window.
Likelihood to Recommend
Snowflake is the data warehouse built for the cloud, enabling the data-driven enterprise with instant elasticity, secure data sharing, and per-second pricing. Faster data retrieval and on the fly retrieval of semi-structured data in tabular format. Excellent data compression ratio. Could be pricey for very large deployments.
VU
Verified User
Analyst in Information Technology (Consumer Goods company, 51-200 employees)
We are using Snowflake as our data warehouse. We currently are loading in our tables and data from an old IBM System to Snowflake. It is currently being used by a few departments but is planning to be used across the whole organization.
Pros
Performance is extremely fast
Pay for what you use
Simple and Pleasant User Interface
Cons
The mouse pointer can be laggy at times when hovering over a preview of a table
Make it easier to switch between data warehouses
Likelihood to Recommend
Snowflake is great for storing data and using it as an endpoint to query off of. It is cloud-based so the it can be scaled to any business need. It is great for analytics as well as simply storing data.
VU
Verified User
Employee in Information Technology (Automotive company, 10,001+ employees)
