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: Farming
- Company size: 201–500 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Superior Cloud Warehousing Capability
Reviewed on 25/10/2022
Snowflake allows us easier access to our data and integration partners are abundant
Snowflake allows us easier access to our data and integration partners are abundant
Pros
Snowflake is an industry leader and has ample connectors to all data sources. They integrate flawlessly with our BI platform and allow for management by a 3rd party. Compute power is FAST and easily scalable.
Cons
Snowflake, like most, has its own dialect for SQL - not necessarily a bad thing but something to adjust to. There is no data cap, so data usage can get expensive.
Alternatives Considered
Amazon Redshift- Industry: Construction
- Company size: 10,000+ Employees
- Used Daily for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Solid Modern platform for EDW
Reviewed on 28/04/2022
Their customer service and training have been solid - I think MS takes the edge here for training...
Their customer service and training have been solid - I think MS takes the edge here for training but Snowflake wins for customer service (at least on non-business critical issues)
Pros
Exceptionally easy to scale up or out based on needs, and some nice cost-saving features like auto-suspend/resume for compute stuff. It supports ANSI SQL so it's not the end of the world to port over code from legacy SQL platforms. It also has a ton of integrations with your cloud provider of choice (as long as it's GCP, AWS, or Azure). According to their roadmap it will support Python eventually as well as their current SQL and JavaScript syntax for stored procs. Just a ton of functionality out of the box.
Cons
Pricing isn't the MOST transparent at first glance, but is fairly intuitive/controllable once you understand it . The current WebUI is absolute garbage. Luckily that's being deprecated for "Snowsight". Role inheritance and object ownership also has a decent learning curve compared to SQL Server, for example. This isn't a knock against Snowflake, but users should not expect this to have the same sort of OLTP-type performance and a typical relational DBMS. Just know the limits.
- 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 11/11/2022
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: Retail
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
Best Data Warehouse in the Market
Reviewed on 03/03/2023
Overall for us Snowflake platform is highly scalable and secure. It includes a number of advanced...
Overall for us Snowflake platform is highly scalable and secure. It includes a number of advanced features and functionalities that help businesses store, process, and analyze large amounts of data in real time. The advantages for our organization include its ease of use, fast query processing, and robust security features. Lately we have used for snowflakes to migrate from our legacy systems as this platform was faster and easier and also integration with other tools was also very efficient.
Pros
For us Snowflakes has been critical to process and store the data day in and day out. Integration with various data sources and tools, including ETL/ELT tools, BI tools, and data science platforms has been critical for our organization and the teams. Snowflake's ability to handle large amounts of data and process it quickly is impressive. The platform is adaptable and provides us with numerous options for data management. Snowflake's distinct architecture enables us to easily manage and process data. The user interface is simple, and the platform is dependable.
Cons
Lately the new user interface is not comfortable and is confusing. The older user interface was much more easier. At times query performance issues are observed and timeout happens. Also cost per query is concern and expensive. Cost should be priced reasonable.
- Industry: Information Technology & Services
- Company size: 51–200 Employees
- Used Daily for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Skip Redshift, Snowflake scales reliably
Reviewed on 25/08/2020
Snowflake supports both our analytics (dashboards and ad-hoc queries) and machine learning,...
Snowflake supports both our analytics (dashboards and ad-hoc queries) and machine learning, including PySpark clusters. Our data scientists have found it a pleasure to work with, with rich analytics query support. The cloud-based technical architecture provides significant advantages over other offerings, including the critical ability to segment usage patterns and scale reliably.
Pros
We switched from Redshift to Snowflake for two primary reasons: 1. Snowflake's virtual warehouses allow scaling reliably, whereas Redshift becomes unstable; 2. First-class JSON support.
Having switched to Snowflake, data warehouse administration has gone from nightmare to almost nothing. We continue to scale our data and analytics, and Snowflake handles it easily.
Cons
Snowflake's approach to sales and support is a blend of on-demand cloud offering and enterprise tool. They could improve certain aspects, such as simplifying the set up of Snowpipe to stream data from AWS. But these are minor features involved in initial setup.
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.
