Snowflake
About Snowflake
Snowflake is a cloud data platform that can enable critical data workloads and secure collaboration. This solution can be used to run data across multiple regions for a single, unified experience across a business ecosystem. Using a multi-cluster shared data architecture, Snowflake provides access to the same data without affecting business performance. The platform can scale to any volume of data and number of users.
Snowflake provides real-time data that can be distributed across business units and other stakeholders without the need to copy, move, or make changes to existing data sets. With built-in security features, Snowflake allows access to be controlled and monitored. Other features include data discovery enablement, personalized views, access request workflows, and more. Additionally, this solution integrates with many third-party solutions including data management and data analytics platforms.
Images
Not sure about Snowflake?
Compare with a popular alternative
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
Alternatives
Google Cloud
Amazon S3
IBM Db2
Oracle Database
Reviews
Already have Snowflake?
Software buyers need your help! Product reviews help the rest of us make great decisions.
- Industry: Computer Software
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Snowflake - The next generation cloud data warehouse
Reviewed on 2021/08/09
It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses...
It's really great, Snowflake offered a lot of flexibility which parallel cloud-based warehouses could not offer the same. Snowflake can scale both vertically and horizontally to cater all needs.
Pros
Snowflake is very easy to use and scale. It provides helpful features like merge, JSON flattening which are very handy options. Snowflake cloud SQL editor is very fast and helps easy developments.
Cons
It can be a costly solution if optimizations are not planned accordingly.
- Industry: Retail
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Cloud based database and warehousing improves performance and reduces cost
Reviewed on 2020/12/19
its a great experience, our API's have become faster in response time, we stoped worrying about...
its a great experience, our API's have become faster in response time, we stoped worrying about storage size and computation power , now its scalable and decoupled
Pros
This is a fully managed cloud data-warehousing solution , or database as a service, the advantage of this with the traditional server based database is the performance boost, here the warehouse or the computing power and data storage is fully decoupled, this means , you can pay for what you need, your warehouse can be in sleep when its not in use so you save money, you can modify the size of warehouse so you get your performance as you want, and it supports the advance queries like 'copy' into local files and s3 etc ..,
coming to the operations, the snowflake has query history well maintained with importance performance metrics , and they have a good support team who responds quick,
they have a web workbench which stores our query on different tabs with different configurations, they have role based authentication for each elements on database,
they have good documentations and community for an help regarding the queries etc..
Cons
we use to have some outages in the past, which was resolved quick, now a days i don't see those that's a good thing, if you are trying to migrate from a psql to snowflake then some query syntaxes will be different
- Industry: Financial Services
- Company size: 10,000+ Employees
- Used Monthly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
A great example of a data warehouse solution
Reviewed on 2022/11/11
Pros
I love how straightforward and performant the solution was
Cons
Data visualisation was a little lacking, meaning you had to tether to a system like Google Data Studio or Sigma/Tableau to make sense of the data
- Industry: Information Technology & Services
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
My take on Snowflake
Reviewed on 2023/02/13
It perfectly bridges the gap between a Data Warehouse and a Data Lake being highly available, good...
It perfectly bridges the gap between a Data Warehouse and a Data Lake being highly available, good for scaling up or down as per needs automatically to provide the best performance and optimization for your queries. Can store and give access to huge volumes of data which can be necessary for future decision making.
Pros
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. Its cloud nature, eliminates the need to install software and does not affect how our machines work at all during analysis, is another feature I thoroughly appreciate. I adore how it offers many modernised SQL capabilities as well as practical tools for protecting data which can be sensitive in nature.
Cons
The capability to launch numerous queries is absent. The searches occasionally take longer than usual, and with no estimated time as to how long it takes is agonising. There could be a history tab for instance to see all the previous queries written or executed so it can be easy to refer and take part of the previous query instead of writing it again from scratch. There is no straightforward way to convert the SQL queries to Snowflake.
- Industry: Marketing & Advertising
- Company size: 51–200 Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 9.0 /10
Impressive product with a promising future
Reviewed on 2021/06/24
Overall, Snowflake has made managing, processing, aggregating and sharing data easier across the...
Overall, Snowflake has made managing, processing, aggregating and sharing data easier across the organization. It still has some work to do in terms of UI to make the user experience smoother, but the underlying technology at its core is solid and solves many issues with backups, data retention and overall user error in working with data.
Pros
The "Time Travel" aspect of Snowflake, being able to pick a point in time and see the state/contents of nearly any table is astonishing. Very useful and impressive feature.
What is equally as impressive is the overall performance of the platform. I've worked with Oracle, DB2, MySQL, Vertica, Teradata, ParAccel, and others. Maybe not always in the most optimal configurations, but Snowflake's performance has been overall the best in my experience.
Cons
As a newer platform, there are certain convenience elements that Snowflake lacks.
- No auto-complete of object names.
- No "easy" import wizard to import data.
- Some bugs with the browser-based interface (worksheets did not properly save).
- Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large.
Snowflake FAQs
Below are some frequently asked questions for Snowflake.Q. What type of pricing plans does Snowflake offer?
Snowflake offers the following pricing plans:
- Starting from: US$23.00/month
- Pricing model: Subscription
- Free Trial: Available
Capacity storage pricing starts at $23/TB/month. On-demand storage pricing starts at $40/TB/month. Snowflake pricing is based on the volume of data stored and compute time of use. For more information, please contact Snowflake Inc.
Q. Who are the typical users of Snowflake?
Snowflake has the following typical customers:
11–50, 51–200, 201–500, 501–1,000, 1,001–5,000
Q. What languages does Snowflake support?
Snowflake supports the following languages:
Dutch, English, French, Japanese, Spanish
Q. Does Snowflake support mobile devices?
Snowflake supports the following devices:
Q. What other apps does Snowflake integrate with?
Snowflake integrates with the following applications:
Alation, AtScale, Collibra, DataRobot, Dataiku, Domo, Fivetran, HVR, Immuta, Informatica Big Data, Matillion, Rivery, Salesforce Platform, Segment, Sisense, SnapLogic, Tableau, ThoughtSpot, Workato, h2o
Q. What level of support does Snowflake offer?
Snowflake offers the following support options:
Email/Help Desk, Knowledge Base, Phone Support, 24/7 (Live rep), Chat
Related categories
See all software categories found for Snowflake.