Audience
Organizations interested in a powerful and comprehensive cloud data platform
About Snowflake
Your cloud data platform. Secure and easy access to any data with infinite scalability. Get all the insights from all your data by all your users, with the instant and near-infinite performance, concurrency and scale your organization requires. Seamlessly share and consume shared data to collaborate across your organization, and beyond, to solve your toughest business problems in real time. Boost the productivity of your data professionals and shorten your time to value in order to deliver modern and integrated data solutions swiftly from anywhere in your organization. Whether you’re moving data into Snowflake or extracting insight out of Snowflake, our technology partners and system integrators will help you deploy Snowflake for your success.
Pricing
Integrations
Company Information
Product Details
Snowflake Frequently Asked Questions
Snowflake Product Features
Data Warehouse
Database
ETL
Snowflake Additional Categories
Snowflake Reviews
Write a Review-
Probability You Would Recommend?1 2 3 4 5 6 7 8 9 10
"Snowflake is unique, fast and efficient data warehouse tool. Impressive data retrieval and data compression ratio!" Posted 2021-06-20
Pros: Snowflake is being used across our whole organization. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources.
It has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL.
- Reporting queries run in a fraction of the time that they would in our production systems
- We can run simple SQL queries.
- Scales up and down seamlessly
- Optimized table structures under the hood
- Sharing data between accounts
- Easy if use
- Continuous data pipelines
- Snowflake also includes caching at various levels to help speed up your queries and minimum costs.
- Support members are very good.Cons: Nothing to dislike in Snowflake. Awesome data warehouse for huge data set.
Overall: 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.
Read More...
Snowflake is well suited for performing data ETL when data is stored in AWS S3 and one needs fine control over instance costs.
- Performance is extremely fast
- Great documentation
- Pay for what you use
- You only pay for the resources when you are using them
- Native Apache Spark connector
- Simple and pleasant User Interface -
Probability You Would Recommend?1 2 3 4 5 6 7 8 9 10
"Managing data warehouse with Snowflake is amazing! It's a future full stack database." Posted 2021-06-18
Pros: Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage.
Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage.
- Hosted on cloud: Helps with scalability.
- Handling large data scale and ingestion
- Separation of compute and storage
- Community is active and ever-growing: You will have someone from the community to help whenever you need it.Cons: - Very expensive
- Indexing by primary key is non performantOverall: 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.
Read More...
It works extremely well for storing a data warehouse as the querying is optimized for larger tables that are filled in batches. It also works extremely well with unstructured data and has basically replaced any need we previously had for NoSQL databases
- It can now sit on Google Cloud, S3, and Azure.
- Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
- Well suited when handling high volume of data.
- In the cloud computing. Quick availability of data online. -
Probability You Would Recommend?1 2 3 4 5 6 7 8 9 10
Pros: Nice for scaling as a business grows with pay as you go functionality. Cloud based database platforms provide easy to access data.
Cons: Large queries run slowly on web database. Performance slows considerably with simultaneous use.
Overall: Provides great flexibility and accessibility of data for a variety of different business uses. Very affordable for a small business.
Read More... -
Probability You Would Recommend?1 2 3 4 5 6 7 8 9 10
Pros: Simple & clean interface
Great querying performance
Integration with all the major cloud providers
Easy to learn querying language
Good documentationCons: Web based IDE is not suitable for writing complex queries, it feels sluggish when heavily used.
Overall: Snowflake is an easy to use & high performance data warehouse solution on cloud. It helps in efficient & quick search on huge data-sets and can be utilized in various use-cases. I used it for metadata storage in a data migration project and it turned out to be really good.
Read More... -
Probability You Would Recommend?1 2 3 4 5 6 7 8 9 10
Pros: (+) Easy to adapt and easy to use.
(+) The run time of queries is much faster compared to other products in the market.
(+) One can select a part of a query for execution.
(+) Integration with S3 and other data storage platforms makes snowflake more compatible.
(+) One may run concurrent queries without giving up on speed.Cons: (-) Performance drops in the case of multiple users.
(-) No option for scheduling of a task or a query.
(-) The coding syntax has some restrictions like the case-sensitivity issue.Overall: I have been using snowflake for almost a year now, my experience on an overall level is quite smooth. Snowflake is very easy to maintain data warehouse system. It can integrate with Amazon S3.
Read More...
Snowflake is a very good recommendation for a company of any size. The analytics workload can be easily handled by snowflake.