I've found Snowflake to be a powerful and versatile solution for connecting multiple data sources. Snowflake really shines when it comes to handling data of all shapes and sizes. Snowflake is designed to be accessible to folks from all backgrounds, whether you're a tech whiz or just dipping your toes into the data lake world. The SQL-based approach makes managing and querying data lakes a breeze. Snowflake's cloud-native setup ensures things run smoothly. So, you can count on optimal performance even when you're dealing with heavy data workloads. Queries run efficiently, and concurrency, making it relaible for ad hoc analytics and reporting. Review collected by and hosted on G2.com.
It takes some time to get familiarized with their UI. While Snowflake is user-friendly, those new to cloud-based data lake platforms will need some time and patience to get caught up. However, Snowflake provides lots of documentation and resources help mitigate this challenge. Review collected by and hosted on G2.com.
Video Reviews
Snowflake is core to our Data Hub
586 out of 587 Total Reviews for Snowflake
Overall Review Sentiment for Snowflake
Log in to view review sentiment.
1. Pay for what you use
2.Integration with different CSP's
3.Quick Data Copies Without Extra Storage
4.You can go back and see or restore older versions of your data.
5. Secure Data sharing
6.Handles Complex Data Formats
7. No Servers to Manage
8. Safe and secure
9. Multiple people can use it at same time
10. implementation is simple with great customer support Review collected by and hosted on G2.com.
We have been using snowflake for more than a year or 2. till now we didn't have any issues. So No dislikes. Review collected by and hosted on G2.com.
The ability to manage very large data sets, straightforward queries and fast performance. Their integration with powerBI which is our preferred reporting tool is very easy to use also. Their design is quite slick and modern. They also take data security very seriously but also allow for cross team collaboration. Review collected by and hosted on G2.com.
It can take some time to familiarise yourself with snowflake when moving from other platforms and the cost of maintenance can tend to increase over time due to the pay per use model. Review collected by and hosted on G2.com.
So in our company users were creating databases and warehouses for doing poc and then they do not delete or pause the warehouses that give the higher costing. So we created specific roles and users and one common databases for all so that cost optimization can work and created a dashboard which shows which warehouse using how much credits and we set the default to xs. Review collected by and hosted on G2.com.
So far i dont find any problem now the mfa also enabled for the users so security also no issue Review collected by and hosted on G2.com.
- Simple and Modern UI.
- User management and Provisioning is much simpler once you implment the Single sign on with provisioning functionality.
- Roles and permission management is straight forward, snowflake has detailed documents for priviledges syntex etc.
- Manging databases, schema and it's objects is a breeze (be it via worksheet or via snowflake UI).
- Setting up resource monitor helps a lot to track your credits consumption and get alerts for exhausting credit quota depending on the alerts that you set.
- Dashboard and budget functionality is also there, by which getting insights of credit usage by warehouse, by role, etc. all details are easily available.
-Snowflake supports various Warehouse sizes from Xsmall to 4XL to support you ETL needs, with auto pause and clustering features. Review collected by and hosted on G2.com.
As of now everything is working fine and nothing that I dislike as of now. Review collected by and hosted on G2.com.
Ease of usage
Fast in memory querying
Fast query response
Seamless integration with dbt [data build tool]
Easy to learn and understand
Easy to implement with existing data engineering pipelines and solutions
Support is very fast and effective
can be used across multiple teams concurrently daily Review collected by and hosted on G2.com.
Trial period usage is very less, although credits given for trial period is more than enough to develop and tes any usecase but validity is vvery less of 30 days. Review collected by and hosted on G2.com.
Snowflake makes it easy to dive in and start loading, querying, and analyzing your data with minimal setup. Unlike with some competitors ' solutions, there's no infrastructure as code to write. Data sharing is extremely powerful and has virtually eliminated the lift of vendor data integration. Scaling up the warehouse is as easy as a few lines of SQL or a few clicks in the UI. Review collected by and hosted on G2.com.
Worksheets are convenient to write SQL quickly, but these quickly get out of hand. Ideally these could be synced with a Git repository so we don't have to reach for DBT. Review collected by and hosted on G2.com.
I like that Snowflake is very flexible and scalable. It can handle a lot of data processing and that makes it a highly performant data warehouse. My organization uses Microsoft Power Platform heavily and Snowflake integrates really well with this platform. Encyption of data is the other features that I like. You can do full encryption and configure roles downstream to very the cleartext. Customer support is reliable. If there is something you don't understand they are always ready to explain, clarify or provide hands-on assistance. Security features are very grandular. Review collected by and hosted on G2.com.
Snowflake can be costly. There is also a bit of a learning curve coming from a trade database to a platform like Snowflake. I don't have much dislikes for the product. Review collected by and hosted on G2.com.
The best thing that I like about Snowflake is that we can create number of database,and the feature to include AI in that really help us to integrate and make our work process easier and its very easy in implementation Review collected by and hosted on G2.com.
Sometime the query performace and the new UI feature. Review collected by and hosted on G2.com.
The best part about snowflake is the security and compliance in my opinion. Snowflake being compliant with various security standards such as HIPAA, GDPR and others kinda makes it reliable and secure and moreover considering Snowflake's service of total management where a user doesnt have to worry about infrastructure, management and tuning of the data accordingly.
Time Travel and Cloning is just icing to the high performance and speed snowflake offers. Additionally, Colloboration and secure data sharing makes it so easy for lot of software engineers to collab. Review collected by and hosted on G2.com.
The pricing primarily is very unpredictable even though it is cost effective due its scalable features but it can get really expensive when is not montiored properly. Since the users pay for compute time and storage seperately, unexpected spikes in queries, large data ingestion, or poor optimization can result in higher bills. The learning curve for the new users gets complicated in terms of Sql extensions and virtual warehousing sizing because it took me some time to understand the sizing and it was more like a trial and error because it lead me either under provisioning or over provisioning the resources. Review collected by and hosted on G2.com.
Ease of use snowflake provide is top in the industry. Snowflake provide ease of implementation to implement multiple ideas which evoles around and Snowflake is very easy to integrate with other platforms such as boomi. Review collected by and hosted on G2.com.
Some time customer support did'nt provide me the expected output. Review collected by and hosted on G2.com.
