Unclaimed: Are you working at Snowflake?
Snowflake Reviews: 4.5/5 — Highly Rated
Snowflake is a cloud-based data warehousing platform designed to efficiently store, process, and analyze large volumes of data. It stands out for its ability to scale computing and storage resources independently, allowing users to manage data and analytics workloads more flexibly. With its unique architecture, Snowflake facilitates seamless data sharing among users, enabling collaborative data-driven decision-making. It supports various data structures and types, including structured and semi-structured data, making it a versatile choice for organizations looking to harness the power of their data.
| Capabilities |
AI
API
CLI
|
|---|---|
| Ease of use |
Intermediate
Advanced
|
| Deployment | Cloud / SaaS / Web-Based |
| Support | 24/7 (Live rep), Chat, Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support |
| Training | Documentation |
| Languages | English |
Snowflake Pros and Cons
- Multi-cloud support across AWS, Azure, and Google Cloud
- Separation of compute and storage for scalable, on-demand analytics
- Native support for semi-structured data formats like JSON and Avro
- Secure data sharing without moving or copying data
- Pay-per-second pricing model for cost optimization
- Advanced capabilities might be excessive for small businesses with limited data needs
- Potential for increased costs with high data storage and compute usage
- Learning curve for users unfamiliar with cloud-based data platforms
- Dependence on internet connectivity for accessing the platform
- Limited offline capabilities
Data sharing within our organization is simplified with Snowflake. It's fast and it has everything we need to make our jobs easier.
It's expensive but when you need an enterprise solution, you pay an enterprise price.
Getting all our data in one location
Snowflake does a lot to remove the time consuming aspects of DB adminstration and management and streamlines a lot of its functionality eliminating developer overhead.
Cost management and querying metadata can quickly become cumbersome without soliod forethought and planning
Reducing silos and overhead from managing multiple SQL Servers. Creating a unified Data Warehouse.
Snowflake is one of the best data warehouse tool out there. It is super easy to use, so gone are the days of menotinous DBA tasks needing to be done. The pricing model is based on pay-for-what-you-use and is very cost efficient. You have total control over how much compute power you use, with incredible scalability. Every query can use a different size compute engine if you want! In addition, they have built in stored procedures, triggers, events, etc to make ELT easier. They also have a service called SnowPipe which allows you to easily create real-time streaming from common storage locations such as S3 and Azure Blob.
The new GUI is still difficult to get used to. It used to be much cleaner/simpler of an interface but along with more and more capabilities, you sometimes need to have more and more complex interface. With all that said however, you don't have to use the GUI. Everything you can do in the GUI can be done in any ODBC/JDBC compliant data tool you like to use.
Snowflake is the perfect tool for having a powerhouse data warehouse that is strong enough for fortune 50 companies to use, yet simple enough for anyone with minimal data warehousing experience.
Snowflake has the very user-friendly feature of maintaining track of data and tickets, and their progress can be tracked easily. The data loading and running of query languages like SQL is smooth and satisfies users.
A few times when there needs to be up-to-date chat among the users regarding the ongoing project, users need to wait for the client or others to comment, so there is a need for an interpersonal chat feature that can help the users to act immediately
Snowflake is a platform that provides excellent consistency as well as user-friendliness while setting up a process. to activate or load a data cloud or sources to the platform users do not need expertise on the same as the features are very easy to understand, which helps manage projects very efficiently.
Easy Growth: Scales effortlessly as needs change. Smooth Sharing: Many users without slowdowns. Mixes Data Well: Blends different data types seamlessly.
None that I can think of, super satisfied with its technical capabilities. Price is definitely higher side for startups.
Building seamless data analytics combining all SAAS platforms data at one place.
Encrypted data storage and compute capability with time travel.
Newer version of UI is little bit difficult with previous version.
On cloud datawarehouse with fast computation results.
Easy to integrate with other tools, Cloud based, Multicluster warehouse, Stremlit,Snowflake Marketplace
Not cost effective and can not use Locally, need good infrastructure
Creating data model , Writing views for Reporting, Continuous data processing
The databases are easily organized. You can search them on your own. The features allow you to keep an easy track of your projects and because of that you´re able to recicle code and separate your queries according to the project.
Sometimes when the query fails you are not told very specifically where the error is being generated. A FAQ section should be included or a section with tips to get started with SF
Working with relational databases without having to dowload them and work on them in R or Python. Thanks to snowflake I´m able to get just the data I need. It simplifies my job because some of the communications I send extract the most recent data from SF instead of hurrying to upload data.
The UI is one of my favorites. It is clean and usability is easy. For someone who uses it everyday, I have very few frustrations with it.
I wish there was an option to just left click a table and explore the data. Right now you can only input the table name into table.
It incorporates the large datasets we have from various sources, and allows us to consolidates the data to provide key reports off of and make business decisions.
Snowflake Feature such as simplicity , increased performnace,high concurrency and profitability.
Performance low when having large volumes of data in snowflake, getting warehouse timeout error while running a base more than Million plus.
Snowflake Integrates with a number of big tools including business intellignece. It helps to run a Million base querys within seconds, and infrastructure kind of cool user friendly.
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.
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.
We needed a centrailized space to build a data lake. Snowflake can integrate with mulitple CRMs. It's like the social butterfly of data platforms as we are conencting Google Cloud Storage. They have lots of options for payment plans based on your data load. We are now saving money by deploying a centralized data front.
Snowflake's architecture is build for scalability. The data sharing capabilities are exceptional; ot requires literally zero maintainince. I would rate Snowflake the best out there in terms of easy of use, support and value for money. Pretty much everything about Snowflake is great!
The only disadvantage I can see is it being slightly expensive. If you're a very early stage organization, I wouldn;t recommend spending a lot until you have a 5-6 person data team to set up the infrastructure.
I use Snowflake as a central place to manage, modify, combine and organize data. Snowflake acts as a central hub to pull in and push data to various tools and our CRM (Salesforce).
Snowflake is one of the best datawarehouse cum ETL cum database tool. I like it's multiple features like 1) We can create multiple warehouses with different sizes and use them as per our requirment. Also the warehouse will suspend automatically when not in use. So you only pay what you use. Also it has many features. Below are few major among of them: 1) Data sharing for business need 2) Time travel, which helps us to debug in case of any bug or issue, retrive old data 3) Fail-Safe for disaster recovery 4) Stream to track SCD change 5) Task for scheduling
Snowflake does not enforced Primary Key concept in tables. So we need to create separate process to avoid duplicate data loading.
Snowflake has many useful features, below are few among of them. 1) Data sharing. In Snowflake we easily can share data among multiple accounts. So without giving access to the main snowflake account we can share our data to another team for analysis. 2) Time travel, which helps us to debug in case of any bug or issue, retrive old data 3) Fail-Safe for disaster recovery 4) Stream to track SCD change 5) Task for scheduling
The ever availability of core system processes. Ligtening fast query executions. Support from dedicated Snowflake Engineering team around the globe and 24/7 mode.
The latency in set-up. The access heirarchy and time taken to go-live with the provided access credentials. Seldom system outages that are faced with unstable network.
Snowflake is our back-bone of reporting. Snowflake facilitates the tableu reporting for our organization. The live data feeds translated to Snowflake level queries.
Snowflake with it's wide acceptance and snowpipes for different cloud platforms like AWS, GCP makes it a great to tool to implemenet single datalakes for processing
Snowflake implementation can be really complex and difficult to follow even with the documentations.
It is serving as data lake for all my security tools!
I personally love having a contact a Snowflake that reaches out to me proactively and informs me of upcoming changes, configurations needed, etc. It seems like a very soft-core DWH tech which mostly aims to lower the barrier (and cost) for entry rather than offer the best DWH. I can see Redshift, Postgres, SQL Server etc. all be better if you have the necessary skills to manage it and money is not a big deal.
There's a bit of a learning curve when it comes to understanding roles and access permissions, but Snowflake has a lot of documentation out there for it (which I find easier to understand than other DB's documentation).
If we want new features with SQL Server, we'd have to go through the process of upgrading it to the next version and doing all of the testing necessary (etc etc), but with Snowflake, new features get rolled out as they come, and they're available for use if you want to use them
Built in geospatial functions in Snowflake, easy way to search the db, easy way to see parsed json in one click before querying, and all around intuitive to use.
I don't like if you are working and accidentaly swipe to the left it kicks you back to the login screen. Super annoying. Also, when i work in snowsight to share queries when I save it and try to share with someone else it's still blank. Also stop trying to push snowsight on users. Snowsight has bugs (memory issues limits on big querys) and hidden stuff (uploading data), I just want a direct log in to the classic console.
querying data for adhocs, build pipelines for visuals in Tableau or other products, and keep data organized, help with geospatial queries to identify lat/long within geometries
1. The data is divided into smaller micro-partitions making the queries on the dataset super fast. 2. Awesome access control capabilities. 3. Getting support for Data Lake
1. Initial stages of data lake implementation and hence behind competitors. 2. Frequent formatting issues on the browser. 3. Too costly and therefore not suitable for low-scale business.
The biggest problem that Snowflake is solving is making queries run super fast no matter what size of the table queried upon, thanks to its micro partitions. The ability to do time travel and restore lost data is a boon for real.
Limitless Power to Tame the Data Storm The Flexibility that Adapts to Your Ever-Changing Needs A User-Friendly Journey to Data Exploration Architecture Unshakable Security for the data Overall, my experience with Snowflake is pretty good
It is a bit costly Integration with a legacy system is sometimes challenging It sometimes takes time to query complex queries or unoptimised queries Dependence on internet
For us we dump all the data into snowflake then we run complex queries on Snowflake and create Tableau dashboards on top of it to visualise the data and for better business understanding
Very nice online User interface. A lof new features appear every year.
Not so cheap. Moreover, it's not so easy to understand a real cost, because there are some background prosses that exist.
Nice performance, low latency, big concurrency, and good scalability.
its computing speed, timely updates, documentation everything is fantastic. Its unique architecture help us to vanish disadvantages of tradition database tools.
I think snowflake is costly if you can't use it properly. So some open guidelines should be provided. The snowflake cost calculator should provide so that customers can take a decision accordingly
On prem sql server taking 3-4 hour to complete job but same implementation in snowflake takes only 6-8 mins. We don't need to keep DBA team as snowflake is SAAS.
The best thing about Snowflake is that it is cloud independent and solves the problems for both data warehousing and storage.
Snowflake can work on solving edge cases for all the solutions provided by it.
Snowflake combines data warehousing and Storage into a single product without affecting the performance. It provides faster data retrieval as compared to other open source frameworks like Hive.
The best thing I like about it is its compatibility with standard SQL making it very easy to work with data for data analysis and data operation. I also like its scalability and ability to customize.
Although Snowflake is a great tool and serves its purpose in the best possible way but going through multiple data frames and databases exploration can get a little tricky.
Snowflake is really helpful in bringing largescale data together in a Data Warehouse. It helps manage this large amount of data. It also helps integrate this data with various data analysis and processing tools.
It's multi domain data platform and milti cluster shared database concepts.snowflake ETL tool provides ease to access source system and dump the structured and semi structured data.
So far not much drawbacks observed but better to have some connectors to connect with other commercial products like IBM Watson,IBM infosphere MDM etc
We are using big data and snowflake helps us to processing, loading, cleaning data.
Easy-to-use interface to access and analyze data. Easy to to add/export data
Snowsight is a less powerful view than the original console
Snowflake allows us to create a centralized (edit/view) access to large amounts of data for analysts of all levels. It increases the amount of information I am able to consider when making decisions, and therefore builds my confidence in the decision.
Snowflake is a robust and reliable platform for any company, small or large. Since data is stored in one system, integrating and automating pipelines becomes very easy. It is very user-friendly; as an analyst, we can quickly harness the data to find insights and make reports.
It becomes hard to troubleshoot errors, and there are not many resources available on the internet for Snowflake. Documentation also sometimes feels outdated for fixing errors.
Snowflake is mainly used for making all our data available in the central repository for all the departments in our organization to access and see a single source of truth. Apart from that, it is very easy to process big data with it's compute power.
Using Snowflake has been a great experience; I appreciate how easy it is to view, analyse, and produce reports that are helpful for the organization's business decision-making. Its cloud-based nature, which eliminates the need to install software and does not affect how quickly our PCs work at all during analysis, is another feature I enjoy.
The data that needs to be imported must be structured or semi-structured; as of right now, it does not support loading unstructured data, which may be a hassle for some since it affects the price.
It is the only database program with a user profile that can be customized to the user's unique needs for data synchronization and general data generation. Depending on how things are saved, it can even automatically generate an advantage or disadvantage. We could create a complete image of each user by connecting the system code to a customer feedback loop.
By far the best SQL tool out there. The interface is so incredibly smooth and simple not too much stuff crowding your view like other SQL clients typically have. Does this all while maintaining better features like the ability to look back at historical data using time travel or other big data manipulation functions for flattening or expanding data.
Would be cool to have a desktop application rather than being solely web based. Nothing wrong with the web app at all but I suppose just more of a personal preference.
As an analytics manager this has a rich set of features and functions that helps my team work much more efficiently. Fewer data joins and CTEs to do stuff since snowflake already has functions for it. The ability to filter and segment your query results is also amazingly helpful for QA.
I like the UI/UX, and ease of use of the application. It's really intuitive and provides great use cases.
There's not much to dislike, maybe just add additional funcitionality.
It helped me sanitize and feed big amount of data into a simple software
Snowlight is where it's at for me regarding fast searches and clear visualization. It's beneficial to have access to numerous tabs and searches at once. The data point can be queried from a variety of databases that are supported.
The default user interface is my go-to. It's much too complicated, the new one. Problems with introducing new features and explaining their purpose often arise. Plenty of different interfaces offer built-in support for SnowFlake or inexpensive or even free supplementary programmes that add support for it.
Wherever your data or users may be located, Snowflake offers a consistent experience across several public clouds.