Best cloud data warehouse platform at the moment. Love, everything Snowflake has to offer. Easy to build pipelines, data sharing from production to non-prod in seconds, 0-copy cloning in 0-seconds :), amazing time travel, robust security, near real-time data ingestions, flexible compute power, and all possible compliance and certifications we can expect (Hippa/PCI/sox etc) indeed "built for the cloud"

Snowflake is easy to onboard and adopt, implement, easy to use.

Limited monitoring capability and data analytics features.

My overall experience with Snowflake has been a pleasurable one. Though there have been some frustrations at times I have learned and overcome and become a better programmer, and SQL developer for it. I feel like Snowflake is an old friend now.

The thing that I like most about this software is really if you can think it you can do it with Snowflake. I mean as long as it deals with data. I first started at my company using oracle and I didn't stick with that for long because we adopted snowflake. When we started using snowflake my knowledge of SQL just jumped sky high. Instead of just selecting from tables, I was using cte's and partitions and all of that fun stuff. Snowflake made it super easy to understand and learn. The ability it has to handle the amount of columns that it does is amazing.

There is a little bit of a learning curve to get the hang of it. But on the surface it is just like any other sql language and you just have to figure out the different quirks that it has. I wish it could give data instantaneously and read my mind on what I want but that is pretty much impossible so I'm going to stick with what I have.

I really like the fact that i can store my data in snowflake and use that to create visualizations in tableau.

1 - I like the way it stores the big data. 2 - Convenient to connect with tableau for visualizations.

1 - Costly if data is too big 2 - You can't own the data, you have to depend on the Data Engineering team.

This is a very good product. I've had a very good experience with Snowflake.

If you know SQL this is an easy product to use. I love that it can search on JSON and it allows us to create very custom User Defined Functions that can use multiple languages such as JS and Python as well as SQL.

Setting up the permissions can be confusing and complicated.

The convenience of a single data lake that can be sectioned off in any way needed paired with a pricing model that encourages a high volume of data storage and ease of use make Snowflake an enjoyable tool to navigate. They've developed a solid community for knowledge sharing and have experienced, competent staff.

It can take a minute to remember which admin account needs to be used for performing specific actions. Sometimes pressure may be felt to save multiple queries and run them close together rather than sporadically to minimize computation costs, although after the first minute these are billed by the second and the pressure lessens.

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.

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.

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.

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.

Snowflake allows us easier access to our data and integration partners are abundant

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.

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.

Earlier we used to have datawarehouse refreshed once a day.Now we are refreshing once every hour.Auto scale up facilities.

High PerformanceSecuredEncryption and Data Masking FeaturesMany new SQL Functions

Client Tool to Query Data needs to be improved

Snowflake is being utilized as a data warehousing system based on cans. We're utilizing Snowflake and additional tools like HVR and Dell Boomi to create a data lake. Currently, different business teams are using different systems for reporting and analytics purposes. We're now working on a centralized solution for the entire company.

Snowflake has its limitation when dealing with unstructured data

Overall it's been very easy to get onboarded and up to speed using snowflake. At my last company, their SQL platform was so complicated I was too intimidated to use it, so I would always have to ask analysts for help getting the data I needed. With Snowflake, I feel that everything I need to do is straightforward, or easy to figure out with some trial & error and reading the documentation. I've even gotten several complete SQL-newbie colleagues to begin using Snowflake and they've had a great experience as well.

Snowflake's Worksheets interface is easy for SQL novices to figure out because it's simple and straightforward, which is exactly the opposite of many competitors. On other platforms, novices are easily intimidated because of the complexity, but Snowflake does a great job of keeping it simple and clean. Their documentation is also good, but it's not as novice-friendly as I would like.

Script error messages could be more specific and helpful with identifying errors and troubleshooting. For example, linking directly to the relevant section of their documentation, based on the type of error. Again, this is something that advanced users probably wouldn't mind too much, but for novice or even intermediate users, this can be the difference between spending a few minutes troubleshooting versus hours of head-scratching.

Snowflake is very appropriate assuming your association needs to begin little with negligible speculation, and afterward develop at any speed. It is additionally useful for groups that definitely know SQL from chipping away at another stage, like MS SQL Server. It matches all around well with incorporation errands on account of its local capacity to deal with JSON information, for both import and questioning. In the event that your instruments can just associate by JDBC (no local Snowflake connector) you might have a few issues with enormous informational collections. This is actually a restriction of utilizing JDBC, not Snowflake, but rather it is something to know about.

This is a cloud-based application that gives me a safe stage to the simple sharing of information with my customers. I feel sure to associate with my various colleagues as a result of its high level security and successful programming. Through this instrument, I am equipped for incorporating, dissecting, and the whole information in an exact structure and with investigation also, because of which I generally have a straightforward thought regarding the information extraction and its exchange from numerous mists.

Security jobs and access are difficult to comprehend and oversee Rollout of new components appears to intensely support US West coast, every other person needs to pause Visual interface doesn't permit you to oversee custom capacities and schedules. For those, it is code as it were. The board of tables and perspectives is visual

Its been very good experience to use snowflake. Our product performance is increased by using this tool.

Its very fast and easy to use. Execution of query is very fast and manage caching for improving performance. For getting data from different different databases its easy to get the data with snowflakes.

As I have used Sql server so some times it’s difficult to find syntax. Finding error if you have long query and showing ambiguous error then its very difficult to resolve as not suggest any line number. Tabs are not movable which I don’t like.

Snowflake automatically integrate, model and visualize data.

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.

I'm using snowflake since 6 months and my overall experience with it very good. It brings itself to the need of the market that I like the most.

The feature I like the most in snowflake is it's ease of use and excellent support.

Sometimes the response time of portal increases which anyone hates. Understanding the data-structures is not always easy.

The ease of using this software. It’s very easy and functional for data work. As a beginner of SQL , you can still smoothly use it.

I don’t have any complaints about this Software

Grabbing data from our data warehouse is 10x more effective and way faster than it used to be. Snowflake is awesome.

Snowflake is a FAST alternative to a software like microsoft sql server. The data is well organized in the cloud, which allows you to pull from it quickly. SQL queries that used to take 20 minutes now only take 10 seconds. The interface is user-friendly and looks great.

There are a couple of nuances that you need to know when you start using Snowflake. If you have someone to help you learn the few things that are unique about writing code with snowflake, you won't have a problem.

I love Snowflake as they have made data warehousing a very easy activity. Having the ability to use SQL to query huge data sets is revolutionary.

Big Data with Simple SQL - it is amazing how easy this product is to use but still as the horsepower to process billions of rows of data without a sweat. The separation of storage-compute and cloud provider agnostic environment support is the best.

Snowflake is expensive if used "incorrectly". Users need to be extremely skilled to be able to reduce cost on the platform and use virtual WHs appropriately.

snowflake has been a key business partner for major companies BI solutions and I have great experience learning and using it

Snowflake had been an integral part of BI solutions and self service BI analytics for the mega clients projects I have worked with.It is seamlessly integrated with other warehouse databases. Storage and compute modules can be separately managed and help users to tune as per requirement

the cost is little higher compared to other products available in market

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

Centralized data.

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.

With Snowflake, developing and deploying a cloud based relational database infrastructure has never been simpler.

Support for unstructured data could be better.

User friendly and easy setup for the AZure based setup

Cost is very high and not transparent for production grade systems

I like best that they have unified all the data-relevant features on one platform, so be it a single database or end-to-end data management, all can be done using snowflake. I was able to store structured, semi-structured, and unstructured data, all in one place.

Their support team was a little slow in addressing my queries. I belive they can improve their onboarding process.