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.
| 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
JSON parsing feature of Snowflake is the best compare to Redshift. I am currently using snowflake as our main data warehouse where multiple application has JSON data and snowflake does it really well.
Support response is slow in case of emergency need. I had need last year and response was very slow.
Firstly, I use Snowflake to build data pipelines using multiple applications and store it in snowflake. and Our business team uses this data for analysis.
I love that t he CX team is so prompt and efficient
Its a little complicated to use. I would love a video tutorial
Using it as a data warehouse
The feature that stands out most to us is the fact that we can send raw JSON into snowflake and each property is automatically indexed. This gives us the ability to operationalize our use of semi-structured data with minimal engineering overhead.
Currently the only headache we're having is that it does not work to seamlessly integrate Azure Append Blobs into Snowflake. It still feels a bit like Microsoft Azure is a bit of a second class citizen.
We wanted to build a robust automated data pipeline that would ultimately result in a de-identified data warehouse that provided scalable reporting functionality across massive data sets. Using semi-structured data allowed us to create a relatively generic, performant pipeline for our big data to get ingested into Snowflake, and the tool's scalability allows us to query that data in an efficient manner regardless of how much data is utilized. Compared to our previous hadoop-based reporting functionality, the performance is not even comparable.
Snowflake is easy to set up and use. It provides a lot of flexibility in terms of performance and cost efficiency by its ability to scale clusters up and down in an instant. Snowflake's best feature though, in my opinion, has to be "time travel". Time travel is a concept of deriving data from any given point in time. Snowflake also has a "share" functionality, which allows us to share data across the company with ease. Snowflake's capability to clone has also helped us in our testing efforts.
There's not much to be said here. Snowflake was one of the most flexible and scalable warehouse options we found in the market when researching for a cloud-based data warehouse.
Snowflake allowed us to centralize most (if not all) of our data sources into a theoretical single space, which made reporting to our clients easier. Snowflake allows us to easily join data across various data sources within one single space.
The query time is significantly better than qubole
There are no stored procedures and no scheduler
Cost saving vis-a-vis reduced query time
Snowflake perfectly suits our needs - it turns on and scales up automatically, and is invisible, and free, when not in use. Couldn't ask for more.
Nothing
A single, consolidated place for our many data sources. Will scale to match our needs seamlessly into the future.
fastness of queries. Easy to understand interface.
when you update a table from a view without a piece of code in it you have to regrant access
fast reporting for the company. This environment is way better than what we have had before
It's faster and easier to go to production with snowflake than any other data warehouse. Performance and scalability are superior without needing to spend time on design.
Support for stored procedures is a good to have for ETL.
We are using Snowflake to store all of our BI data.
It is wicked fast! Queries run faster than out 128 GM memory Oracle DB even when just running the small compute size. Also, everything is simple and they regularly improve the product.
The worksheet functionality could be improved. Would be nice to save worksheets externally. Had issues with them not saving properly and all SQL scripts I had saved were lost.
Bringing in data from disparate sources, cleaning it, and finding new insights. Benefit to us was setting up quickly and not worrying about any DB administration.
Having data and compute decoupled has been amazing. We save lots of money by suspending the warehouse when it's not in use.
I only just learned about the cluster key feature. I'd like more proactivity towards what tuning I can do.
We provide an analytics database to our customers. The flexibility of data types along with the hands off approach to performance and tuning have been very valuable. Having data and compute decoupled has been a big cost saver for us.