Snowflake Reviews

Ease to access because of its cloud based platform Roles can be easily assigned

UI when we scroll to the bottom of the results and go to a different worksheet and come back the page displays the top of the results which is very annoying

I like that when I make an error when writing SQL, that I get a prompt that is descriptive enough for me to correct my mistake.

I haven't used it long enough to have any cons. Thus far it does what I need it to do.

It is feature packed and easy to use. Terraform package is well managed hence giving team access to IaC. Granular RBAC provides a lot of opportunity for customisation and security governance.

Bill is costly if warehouse cost is not monitored and alerts are not set.

The most impressive aspect of Snowflake is its scalability and performance. It's truly built for the cloud, with a unique architecture that separates compute from storage, allowing each to scale independently. This means you can handle massive amounts of data without worrying about infrastructure or performance degradation. The pay-as-you-go model is also a big plus, as it allows for cost-effective data management.

While Snowflake offers a lot of advantages, it does have a steep learning curve, especially for those not familiar with SQL or cloud-based systems. The documentation, though extensive, can be overwhelming for beginners. Also, while the pay-as-you-go model is generally a plus, it can lead to unexpected costs if not managed properly.

It is through Snowflake that we eradicated the need for data scientists since it offers self-service data modeling tools that help model and visualize data.

I haven’t used Snowflake for quite long, but I have never had any challenge for the entire duration I have turned to it.

Performance is outstanding. No explicit maintenance is needed. High availability. No need to worry about SQL processing speed, easy scalability.

Quit expensive while comparing to other database.

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.

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.

We used Snowflake after multiple attempts with other clouds and to say it was powerful is the least. It connects all data sources and allows to create a solid data warehouse essential for all BI reporting etc.

Complicated Billing (on purpose?), sometimes waiting for query load can be long and bothersome, could still use UI improvements

High PerformanceSecuredEncryption and Data Masking FeaturesMany new SQL Functions

Client Tool to Query Data needs to be improved

I love how straightforward and performant the solution was

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

Configuring the Warehouses can give you endless possibilities.

There are some implicit casts in data types sometimes that seem to be the default behavior

We can schedule the data synchronization timelines, and store the data for analytical and reporting purposes.

I don't find any thing to dislike, it serves the purpose of data warehousing for reporting.

1. Cloud based 2. Costing based in usage 3. Good performance 4. Access management an governance

License cost but does the job as per expectation

I like that it has a really good interface that is easily accessible. We were using AWS before this and it was really hard to get the connections right. Keeping track of the drivers and everything was really complicated and I never got it to work as seamlessly as Snowflake

I don't know if there are any data visualizations that I could do in the program. That would be a cool value add. If that feature already exists, then I apologize to Snowflake. Another quirk is that not everything worked in the exact way that I wanted it to. There were some weird syntax things that didn't allow me to directly transfer my AWS queries, I had to go through and change them and there is one query that I still cannot figure out where the translation error is.

Snowflake is incredibly flexible and versatile. There are numerous ways to get data into Snowflake, even if there is not already an API built out for the source. The tool has many pre-built integrations as well.

Though it is very flexible, one thing that Snowflake does not handle is unstructured data. This can be a problem if your sources heavily rely on this type of data. They say they are going to support it in the future, but as of right now, they do not.

query response time is way quicker compared to any other product.

I don't see any cons in the product, I like the way it works and gets me the results.

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.

It can be a costly solution if optimizations are not planned accordingly.

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.

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.

Easy to get started if you are familiar with traditional data warehousing

It gets expensive as soon as you use the additional functionality

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.

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 is a database and a storage warehouse on the cloud. Since it's scalable on demand, retrieving data through Snowflake Warehouses is lighting fast. All the computing power required to run the SQL queries are taken care by the Warehouse size we choose. If a query is taking too long to run a quick switch to a bigger warehouse does wonders. Migrating and loading data into Snowflake is a breeze too via Snowflake Stages and COPY TO commands.

Snowflake doesn't enforce constraints, especially primary keys. So, care should be taken while doing INSERTs and UPSERTs to maintain data integrity. This lack of this feature is understandable since it's projected more as a storage warehouse.

Web UI Virtual Warehouses Secure Product Auto-Scaling S3 integration Public Cloud Hosting Forward thinking vendor

Would be good if there was a RESTful API interface with ability to query tables returning JSON format

We use Snowflake to capture some of our larger third party data exports that won't fit into Google Sheets. The process of uploading data is straightforward and keeps our business reporting streamlined despite lean engineering resources on our end. There is a SQL interface to make modifications to data before final exports and data viz.

The UI is clunky and not the most intuitive. The error messages could be more detailed and expanded. The support for Mac seems to be more limited. Encountered issues with data produced via Mac and support took months to fully resolve.

Easy setup and configuration. The Ability to scale up and scale down at needed. Pay as you go and only for what you use.

Limited to AWS currently with planned expansion to Azure and GCP. On-Premise is not an option, but VPC is.

The three features of many great features that stand out are: -The REAL separation of compute and storage gives the ultimate flexibility. You can match workloads to the proper level of compute without having one workload collide with another. You can optimize what you spend by only using what you need with the ability to change the size of your compute multiple times a day and the ability to...

Read more

One of the positives above can also be a negative. Snowflake is a service and not software that you can run in your own data center or your own cloud VPC. This CON can be overcome with end to end encryption where you own the key and other Snowflake features.