Unclaimed: Are are working at Snowflake ?
Snowflake Reviews & Product Details
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.
( 1 )
| Capabilities |
|
|---|---|
| Ease of use |
|
| 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
Snowflake's architecture is designed to automatically scale resources up or down based on demand, making it a great choice for businesses that experience fluctuating data volumes.
Snowflake can be relatively expensive, particularly for smaller businesses or those with lower data volumes. The pricing model can also be complex, with charges for storage, compute usage, and data transfer.
DWH to empower Business Intelligence and Analytics Solutions for mid to large enterprises.
It pulls information that is not always available in other systems like Mode/Sigma and Tableau. I trust the data from Snowflake more than most, and I like to use it because I know that the information is what I need.
Getting the data you are trying to research can take an incredibly long time. I have often given up after 20 minutes of waiting for data to pull and moved on to another system because I don't have all the time in the world.
Snowflake helps us get information about our merchants, including the stores they are tied to and the transaction history in a given time frame.
The experience using Snowflake has been excellent; I love its ability to store large amounts of data and make it easy to visualize, analyze and generate reports useful for the organization's business decision-making. I also like that it is cloud-based, so there is no need to install programs to use it, and it does not interfere at all with the performance of our computers; its performance during analysis is high-speed. I love that it integrates useful features for safeguarding stored data, such as SecuredEncryption and Data Masking, and it also integrates many updated SQL functions. It is a fantastic tool.
The data to be loaded must be structured or semi-structured; for now, it does not support the loading of unstructured data and might be inconvenient for some as it somehow influences its cost.
We have been using it to store large data sets, and it has had unparalleled performance, works better than many other tools, and has no data load limit. The analytical capability is highly effective and incredibly fast, allowing us to act quickly and make effective business decisions. The reporting tool is perfect; it will enable us to represent data comfortably and efficiently.
It is very easy to learn and use and integrates easily with different ETL tools
It is not supporting unstructured data as of now
We mainly deal with healthcare solutions for pharma based clients and it is extremely useful in maintaining our data repository
I love snowsight usage for quick queries and visualization and also the quickness and easily scallable data warehouse solutions. It is the best all-round data warehouse I've used and has multiple small features that make the whole better.
I think snowsight data visualization tools are a bit limited, and we should have other dataviz options like change colors, stacking bar charts etc. Also better search replace options on notebooks.
Is solving all of our data warehousing needs. We use it to build tables that feed into our BI tool (Looker) and also to make ad hoc analysis on data stored and maintained at snowflake.
It is the only database program large enough to show respectable performance; moreover, its user profile can be adjusted to suit the user's specific requirements for data synchronization and general data generation and can even automatically generate an advantage or disadvantage depending on how things are stored. We could build a complete picture of each user by tying the system code to a customer feedback loop.
Honestly, I think it's costly; I understand that data is necessary for innovative research, but the cost is sky-high.
We can perform searches going back several years to maintain a secure database with impeccable channels or filters. The data and information contained in Snowflake as a whole are crucial. This is excellent software that I can use in my business. Understanding that information is gold and having access to company data, customer data, employee data, etc., is crucial for future decision-making facilitated by this method. It has been perfect and sets very well-defined criteria for doing so.
Ease of setup and linking to underlying table
Chains can be a bit hard to understand but was an easy setup for our Eng team
Automatically pulls in monthly metrics for our reporting
Has a web Based, intuitive interface that is easy to use if you are familiar with SQL and allows complex queries. SnowFlake is easy to interface with multiple and different types of data sources. Specifically, we needed to upload CSV files automatically. Python integration made it easy for our application, where a lot of data comes from production systems that only generate CSV files that are otherwise hard to make part of big data without complex software integration. There are a lot of interfaces out there that support SnowFlake either native or have cheap/free add-on packages. Also integrated nicely with node-RED.
Since the payments are based on "warehouse usage" the initial bill can get quite high as during testing, a lot of the uploads and searches are run multiple times to optimize. Cost came down quickly once we were in "use" mode.
The main use of SnowFlake for us was that we needed to aggregate data from several productions as well as MRP systems, so we could generate meaningful reports. Doing it using Excel is a quick and cheap solution, but it is difficult to do with "live" data without a lot of daily effort. Now it is all automated and data is available when needed.
The UI(Snowsight) has code completion, and it is easier to share queries with colleagues. It also maintains query history
It doesn't have charts that can easily help assess the integrity of data
Data storage. We are ingesting massive amounts of data from S3 and BigQuery into Snowflake
Solid query performance and easy to use and straightforward UI. I like that it has a wide selection of integrations. We use Snowflake with Fivetran and dbt and it works great.
I'm still not 100% sold on the updated user interface. I find myself going back to the classic console, but I think that's probably just a personal preference that I will need to get over.
Snowflake offers a centralized data warehouse solution that ensures easy access to a single source of truth across the organization and across various tools and platforms.