Snowflake Reviews: 4.5/5 — Highly Rated

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.

No need to setup the infrastructure, With just 3-4 clicks, you get the account in your Cloud and get $400 credit for next 60 days. This enables all the functionality and we play with any functionality on this trial version. Native support for loading semistructured data Data is automatically encrypted at rest and in transit Automatic partitioning and Clustering and compression Automatic versioning, Time Travel, and Fail-Safe Provides Cross Cloud replication

Snowflake is still in the very early phase of supporting the Delta table functionality. Moreover in Replication, we are supposed to replicate one Database at a time, But what if we have multiple databases in Account we need to replicate each and every Database manually. Account level replication should be there. Also Snowpipe is there but near real-time , waiting for snow pipe streaming.

Working closely with Business stakeholders and drawing from our strong Expertise in Snowflake, we defined our focus, determined the data migration strategy and advised Snowflake as Cloud Warehouse because of the following benefits: Scalable Storage layer: Store data such as Amazon S3 bucket. This ensures data scaling, and availability without any management by customers. Automated Zero Administration: Snowflake supports Auto-Scaling, Auto-Suspend, Sharing, query management, optimization, security automatically. Lower Cost: Snowflake works on Pay Per Use model. Pricing depends on the amount of data stored and the compute hours used. High availability: Replicating the data across three availability zones in the event of node failures. Query resiliency: If a single compute instance fails within a virtual warehouse, Snowflake automatically replaces that instance and completes the query without disruption

The easy and quick away to change the compute power for your SQL queries. I don't think there is anything like this on the market. Unlimitted storage makes Snowflake THE data lake on the market.

The new query interface. I'm not sure what Snowflake was thinking here. I always go back to the original UI. The new one is way too confusing. New features are not always well communicated. I wish there were a page in the account where we can get a summary of new elements and which one is available and active for the current account.

Building Data Warehouse solution. We use Fivetran and Airbyte for data integration to bring any data source to Snowflake. We then build a dimensional model to transform data and provide our clients with faster BI reporting capability. We then use DBT to automate the data transformation and implement our dimensional models.

User-interface and easy to work with an environment

if we have standalone software it could be usefull

data migration and process of data

My organisation consumes Snowflake as the leading service for storing and analysing data points collected from customers and clients. It provides a spotless and straightforward user interface. The ability to work on multiple tabs and queries is wholesome. It also supports different databases users need to select for querying the data point. It also has a separate canvas showing the status of query progress and SQL tree structure of the query with the amount of time each operation takes. Once the query is completed, it provides a download button to save the result. They recently introduced Snowflake Lite, which is also easy to use and valuable.

It doesn't include the feature to run multiple queries from a canvas. Sometimes the queries take longer than usual, and waiting is painful without a progress bar. There is no historical version of the canvas where the queries are written, so once it is lost, it is gone forever. There is no autocomplete feature support for table names or SQL syntax.

I am using Snowflake to store the data points collected via pipeline from customer clients to the prod database. We use two different versions of Snowflake; one is for developer testing, and another is for the production database. I can filter data points through SQL queries based on dates, types, strings, etc on the Snowflake. The SQL tree is helpful to optimise the queries as it provides a breakdown of each component consuming resources and time.

Really strong performance and speed, also easy sharing

The only thing I don't like is that you cannot collaborate with teammates on a query

It makes it easy to query data and quickly get metrics that we need

Snowflake is best for unpredictable workloads or sudden spikes in user queries. 1. Since Compute & storage are decoupled, queries don't get queued for resources. 2. Another killing feature is it has Auto Pause & auto suspend modes which stops consuming credits when no queries are running. 3. Snowflake is an apparent winner compared to AWS Redshift when it comes to maintenance. Almost zero admin tasks everything is taken care of for you. You can either change a warehouse’s size or increase the number of clusters with almost zero downtime seamlessly. 4. As already mentioned it is best in the situations where you get temporary high workloads, so you can increase the compute capacity without increasing storage. 5. Built-in support for Semistructured data like JSON is worth mentioning. 6. Lift & shift from On-prem Relational DW to Snowflake is easy compared to other cloud warehouses.

Complicated Billing. Snowflake’s On-Demand pricing model can be enticing initially, but it can be very unpredictable in the long run, and its cost increases as you go higher. As compared to Snowflake, Redshift has a simple pricing structure based on redshift clusters. Redshift also offers Reserved Instance Pricing, which allows you to unlock 75 percent savings which was the primary driver for switching from Snowflake to ASW redshift for one of our customers.

Highly scalable Data Warehousing solution which can serve organizations' BI, Analytics & Decision support needs. Highly useful for unprecedented /workloads which need instant scaling. Helps quick migration from On-prem relational data warehouse(Oracle) to scalable cloud snowflake warehouse. Flexibility to choose any public cloud storage be it AWS/Azure or GCP.

Data sharing, zero-copy cloning, time travel

There is nothing to be disliked about it

Data Ingestion/Processing with separate storage and processing capabilities through virtual warehouses

Easy to understand through user guide. Nice gui. Fast results. Additional feature snowsight is an amazing add on.

Every feature i have used so far is great

Database querying -results are fast The result table can b directly copied without downloading.

I enjoy how easy it is to search up different tabs that I'm working on. Another feature I find helpful is Snowflake highlighting the specific syntax or part of the query causing the query to run unsuccessfully.

Snowflake's documentation on its syntax and the examples provided can be confusing and hard to follow. I want Snowflake to provide more detailed and broken-down SQL queries with the matching results for more complicated functions.

Using Snowflake, I've run a distribution analysis and set target goals for an incentive program rolling out for the company's Customer Service representatives.

It is seamless to integrate data from multi-cloud and on-premise repositories. Automatically prepare, model and visualize data.

I am fully satisfied with Snowflake in terms of features coverage and customization.

I relish a lot with Snowflake from saving time, finances to unlocking actionable insights on data.

- Excellent user interface and navigation features in the web portal. - Easy to log in via SSO (Single Sign-On) - Users can create unlimited worksheets and works are auto-saved for future use. - Easy to run SQL queries just by highlighting the portion to execute. - On the sidebar, we can find database objects like tables present in the dev/prod database. - When executing complex queries, you can monitor running performance on each node. - Another app version called Snowsight is available which also includes all features.

- Whenever you want to execute a query you have to select it before running. - Once a worksheet is deleted it's hard to find it back. - Not easy for fresh eyes. Requires learning or background knowledge before using it. - It will be really good to have a one-liner description pop-up when we hover a mouse on any button in UI.

I am using Snowflake for collecting logs and stats data from customers cluster. For the development and testing I prefer to use dev version and for publishing final data we use Prod version and create tables to store/query on data. The SQL query also supports all operations which I use to filter the results and store the output on aws for sharing with team. Depending on the role of user, we can set their limitation to acces the prob db tables and data.

Simplicity of use, performance Almost compatible with every other tools : legacy or new Data tools

nothing, we haven't find, so fare, any limitation to the datacloud platform

One unique source of truth in the company for IT department and data departement, serving all the business needs

The features which are utterly unique, like time travel, zero copy cloning and separate costs for storage and compute. Snowflake is especially controllable - I can create data warehouses for specific purposes and groups of users or processes, and determine when they're available - all on the basis that the cost relates to the value.

Snowflake is still new. There are some features which would be useful around metadata management for data analysts, and other functions which other databases have. But I'm sure these are on the roadmap and will come in time - probably sooner than I expect!

To become more customer centric, to improve the efficiency of business operations, and to make it easier to comply with regulations. All of these can be achieved more effectively, faster and at a cost that more directly reflects the benefits achieved, than with other databases I've come to know.

Easy usage for non-data savvy users and readers

The setup is not as straightforward as the usage

Using SQL to analyze financial and customer data

Snowflake is the best data warehousing tool in the market it gets all the features as one connects to any cloud Environment like AWS, Azure or GCP to store its data plus the virtual warehouse is pretty fast and its internal micro partitioning feature is also pretty handy.

As it is pretty new to the market there are very few documentation or training to learn this tool also they can add new cloud environment like oracle cloud to the snowflake.

We do all the ETL stuff with snowflake and now using snowflake we can easily migrate our existing project to any cloud environment. it is very cot effective supports all the major clouds one connects to multiple languages using different connectors are all of the benefits of a snowflake.

Everything about it is amazing. It is super fast, computes queries so fast. Can get you more than 6 million rows in less than 5 seconds. It has the feature of time traveling which lets you go back to a previous stage of your data and it is very helpful. Since it has the storage and compute separated, it lets you query in a very fast way and maintains different warehouses. Is very cost-effective as well. It handles so many things together, handles the security of the data also in the best way. One should just go for the migration to Cloud and should choose Snowflake

I haven't come across anything till now which I dislike about the product. Although it does not seem to handle unstructured data as of now but seems like it will be included in the future. If that will also be covered, other than semi-structured and structured, it'll be simply awesome!

We migrated the data from DB2 to Snowflake as we wanted easier deployments, better security and wanted to move to the cloud for higher performance and cost-effectiveness as well. Snowflake fulfilled everything we were aiming for.

I like the power and capability of Snowflake, as well as its aesthetic user interface. It's not only a database - with SQL and all you'd expect there - but it also provides tremendous functionality for sharing and controlling access. We've made row-access policies, for instance, to even let clients into their data and only their data. I like the concept of roles which allow us to easily specific access levels to specific pieces of data, I like how we can visualise items from a query within the console, and many, many other things. In short, working in Snowflake is quite pleasant and enjoyable with a great user interface.

I wish the worksheet editor allowed us to search and replace - it seems a little basic this is missing. I also wish the product would make warehouse recommendations - for clarity, Snowflake pricing is based on the warehouse you use for your work, with a warehouse essentially being CPU, RAM, etc. So, an extra small warehouse is the lowest amount of compute power and, correspondingly, the lowest price. Yet, it's possible for some newcomers to inadvertently run their work in (say) a large warehouse when this costs more money. Or, conversely, maybe we're too worried about cost and we're causing a complex query to take excessive time to run. It'd be nice if Snowflake itself gave some advice around queries - e.g. you run it, and it says "hey, if you did this on a small warehouse it would have taken only 0.2ms longer but would have been cheaper" or "this query took 25s to run. If you used an XL warehouse it would have completed in under 2s" or something like that. It'd also be nice if Snowflake SQL supported string concatenation with the + symbol like T-SQL.

We're using Snowflake as a cloud-based data warehouse to aggregate data across all our many diverse databases and products. We have applications using AWS and Azure, with databases in SQL Server, MySQL, and others, and with some apps using multi-tenanted databases and others using one database-per customer. We have thousands of databases across products and clouds and DBMS engines - so ingesting all our relevant data (for reporting purposes) into Snowflake allows us to make awesome reports in one place, for all customers, across all products.

It could churn through data so fast, which is nice in a data warehouse tool. I wasn't the only one either in our company there were probably 20 analysts or more doing simlar things to what I was doing and it rarely missed a beat.

The thing that I didn't like about it was the fact that the only interface that we had to interact with it with was online. There were other ways but they were build directly from snowflake.

Being able to pull a ton of data, and check results so that we can publish the data to our BI Tool. This is used for reporting purposes to see how the company was doing.

It turns lots of source data into SSoT and feeds many data consumption tools, and potentially shares data with many other New Zealand Government organizations in a copy-less clone.

I am looking forward to unstructured data capability as it is restricted to structured and semi-structured data.

SF is SaaS, so we spend more time on data loading than managing the tech. True SSoT allows many users to access the same SSoT data to form MVoT info.

The separation of compute and storage and the flexibility in being able to control costs. Snowflake role hierarchy is also a very nice feature that allows for a flexible yet robust privilege hierarchy.

It would be nice if Snowflake offered a cost breakdown per user. Having the resource monitors is nice, but having the ability to see who is utilizing compute would make cost management a lot nice.

We are solving the problem of concurrency. Our current solution is not a highly concurrent system, and a couple of big queries can impact the rest of the users in the system. Snowflake does an excellent job of isolating the problematic compute areas.