Snowflake Reviews

We use Snowflake as a database to store all the data we stream from the source system.

The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power. If I want to change the computation with other tools like Netezza, I would have to add a hard disk to it. With Snowflake, being on the AWS side, changing warehouses provides me with faster execution of my queries.

The real-time streaming feature is limited with Snowflake and could be improved.

Currently, Snowflake doesn't support unstructured data. With Snowflake, you need to be very particular about the type of data in your source systems. It has to be in a proper structure. You cannot push data to Snowflake in any possible way.

I have been using Snowflake for a couple of years.

Snowflake is a stable solution.

Around 400 users are using the solution in our organization.

We previously used IBM Netezza. We switched to Snowflake in 2020 because it provided us control over its scalability and costing model.

The solution’s initial setup is comparatively easier.

Snowflake is a cloud-based, scalable solution that provides strong data security. Handling all the data is much easier in Snowflake, and it has a very nice interface to control user access. The administration of Snowflake is also comparatively easier.

Snowflake is a cost-effective solution.

Choosing Snowflake completely depends on the quantum of data your organization has and the requirements. Snowflake is suitable for someone looking for a scalable and cost-effective solution that provides quick analysis.

Overall, I rate Snowflake a nine out of ten.

The solution is very good for building data warehouses. However, it has some limitations if we need it for more use cases.

All the features of the product that are needed for the data warehouse are good. The solution enables the ingestion of data and the usability of preferred languages while creating the data. The performance of the engine is good. The solution speeds up the process of onboarding. We can connect to different sources and get the data very fast. 

The tool does a very good job in reporting and data transformation. We can adapt it well to our needs. When we try to ingest data from many sources, it helps harmonize the data sources. It also helps with duplication and cleaning of the data. It is a pretty difficult and time-consuming task, and Snowflake helps us with it.

I do not like the proprietary format of the solution. Getting data out of the tool to third-party applications is difficult. The data science workloads must be improved. Snowflake has a lot to learn. There are better options in the market for data science.

I have been using the solution for almost three years.

The tool is stable. I rate the stability a nine or ten out of ten.

If we need to scale up, it will impact our costs. I work in a consulting company. We have a department dedicated to Snowflake. We have seven to eight people on our team. Our clients were medium-sized businesses with 1000 employees. They are focused on data analytics solutions. They also have departments for Azure and AWS. I rate the tool’s scalability a seven or eight out of ten.

I rate the ease of setup a seven or eight out of ten. The tool is deployed on the cloud. The time taken for deployment depends on the workload and how we build it.

The solution is expensive. I rate the pricing a nine out of ten.

We are partners. The impact of the solution’s automatic scaling feature on the workload depends on how we build our workload. The vendor must take a look at the market and how technologies evolve. The solution can do more in the area of distributed systems. If our use cases require data scientists, I rate the tool a three or four out of ten. I rate the tool a nine or ten out of ten for SQL data warehouse use cases. Overall, I rate the product a seven out of ten.

Our primary use case for Snowflake is inputting data generated by AWS.

This solution has helped our organization by being easy to maintain and having good technical support.

The features I have found most valuable are the options to connect with extendable sources in three buckets in which we can also create stages.

I think that Snowflake could improve its user interface. The current one is not interactive.

I have been using this solution for about one year.

I would rate the stability of this solution a nine, on a scale from one to 10, with one being the worst and 10 being the best.

I would rate the scalability of this solution a 10, on a scale from one to 10, with one being the worst and 10 being the best. There are around five developers in our company and 500 end users for this solution.

We previously worked in AWS.

I would rate the initial setup process an eight, on a scale from one to 10, with one being the worst and 10 being the best.

I would advise other people trying to use this solution to build a skill balance as it's quite difficult to work in Snowflake.

I would rate this solution as a whole a nine, on a scale from one to 10, with one being the worst and 10 being the best.

The use cases are data warehousing, data pipelining, data engineering, reporting, and dashboarding. Instead of using Oracle or other systems, you can simply put Snowflake there. It works like a normal database. This way, you avoid consuming the system with extra data. So the experience so far is good.

One of Snowflake’s most valuable features is that you don't need to worry about computing. You don't need to scale up the compute size. When you are using a compute pay-per-use model and the storage is cheap, the data can go from terabytes to petabytes. In this case, you don't need to procure any new hardware or software, it automatically scales up.

I think the problem is maybe the design of the product. It is supposed to be a warehouse product, you can't expect it to be a transaction system. It is not designed for transaction systems. It's purposely built for data warehouses. So people cannot expect to use Snowflake for transaction systems. They misunderstand the product.

So I would not call it a product negative. I would say it's more of a user error, for example, people using a hammer for something else. But that's a problem. It works perfectly fine, otherwise.

They need to work on the design. That would suffice.

I have been using Snowflake day in and day out for four and a half years now.

It’s a stable product. I don't think there is any problem. I think the product is engineered well.

It is good at scaling. You can scale it horizontally or scale vertically. That's a big plus. Scaling easily is a big thing.

They are really good and responsive. I normally raise the ticket and they immediately come back with an email. They keep posting updates and follow-up promptly.

There is no setup issue at all. It's very smooth. You need to do a simple login. If you're doing the initial setup, it's maybe a couple of days of work. That's it. If you are migrating or want to do a proper new database setup, it's just a day's work.

We use Snowflake pretty heavily. We pay a significant amount of money for the tool. I'd say we pay $300k to $400K every year.

It's a great product. I think people don't need to stick to traditional Oracle systems and rather go for Snowflake. There you don't need to worry about any updates. It is a cloud product, so it automatically updates regularly. The advice is to get used to this way of working as it's new. You have to get familiar with the technology, and a little bit of the terminology. It's a very good product. I would rate it eight out of ten.

I use the tool with visualization tools like Tableau and Power BI. We load the data into these tools and use them to build customer reports. We often need to write scripts to perform transformations before sending the data to the visualization tools.

The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL.

I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool.

I have been working with the product for four years. 

The tool is scalable. I've used it for datasets with more than ten million records.

I only put data in and modify data. Most of the time, I don't require technical support. We occasionally had downtimes, and the data engineer would escalate these issues to Snowflake to resolve them.

The solution's deployment is simple. You purchase the license on the Internet—I think there's only a free trial for thirty days—and set it up like a Gmail account. It takes less than a minute to set up. You can set up your Snowflake server or use an enterprise vendor like AWS or Azure. Recently, Snowflake has been moving away from third-party vendors. They want to set up their remote infrastructure.

The tool's pricing is based on the number of queries you want on your database. The cost is small. To get the tool's pricing, you can do the math based on the cost per query, which is $0.002. If you're running your queries frequently, your charges will be higher than running fewer queries.

I would give Snowflake a ten out of ten in terms of performance and a nine out of ten in terms of scalability. I rate the overall solution a ten out of ten. 

Data warehousing is typically a rich guys' toy. Large enterprises are only able to leverage data warehouses for data analytics purposes. We wanted to change that and wanted to build a data warehouse template model for businesses across industries. 

If Snowflake was not around, we would have used Google's Big Query or Amazon's Redshift, or a MYSQL/Postgres database in a Windows VM (virtual machine). However, Snowflake made it a lot easier for us with loads of features such as encryption of data in motion and at rest, masking policies, time travel (to correct data load issues), controlled access based on roles, data sharing, third-party data from marketplaces, etc.

It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses. 

About ten years ago, force.com from salesforce.com offered a similar platform for us to build data warehouses. However, our staff with a data engineering background found it easier to build the data warehouse in Snowflake, with the easy-to-use SQL interface and RBAC models (role-based access control). The platform saved us money as it automatically shuts down the compute engines after about five minutes of idle time. Per second billing (above the first minute) is great. 

In my view, cost optimization for the computing power required by the ETL jobs, reports, and dashboards is the most valuable feature. Especially for startups, this helps us to keep cost spending within control without having to worry about manually shutting down the server when not used.  

As a Google partner, we like to leverage GCP (Google Cloud Platform). Snowflake supports GCP, AWS & Azure platforms. This works just fine for us. Encryption of data with multiple keys for both data in transit and data at rest gives us enough confidence to use snowflake for our customer 360 solutions.

Currently, we use Snowsight only to monitor the usage of the Snowflake environment by our users. However, if Snowsight can be improved, we can host our BI (business intelligence) environment also within Snowflake. In our case, to provide basic reports and dashboards, we started to use Tableau, Power BI, Looker, and Qliksense, depending on our customer preference.    

We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model. If Snowflake could guide us with some easy-to-use integration (similar to DBT integration), that would be great.

I've used the solution since 2020.

Stable

Scalable

Support can be enabled in the Snowflake UI.

Neutral

In the past, we used Google Cloud SQL. However, Snowflake offered cost optimization among the many other useful features. They also introduced app building on top of the data hosted. 

The initial setup is not difficult. Google Search will lead us to articles that can guide us on the setup of users, roles, warehouses, and access controls.

We did the initial setup on our own, and it was not difficult.

We constantly monitor the usage with grafana dashboards to keep the ROI growing and to assist/ alert users about any wastage.

Many interesting features are available only in the enterprise edition. Check out the differences when you are evaluating the product: https://docs.snowflake.com/en/...

We considered MySQL and Google Big Query. We're also happy with Google Big Query. 

Snowflake is growing with newer features and capabilities. But not much success with Stream lit app. Big query + app sheet is an alternative that we're considering.

Our company uses the solution for building a data platform, data warehouse, and data transformation.

The product is somewhat used for data analytics, but it is mostly for data engineering.

The tool is good for handling large datasets, and since the tool is fully managed by Snowflake, you can scale up the compute part.

I don't think that the AI tools in Snowflake are good. AI tools in Snowflake can be improved. Even if the AI tools in Snowflake are good, I feel that it would be expensive. The cost of the AI part does not justify what you get from the product.

The price of the product can be lowered.

I think Snowflake should integrate with some tools like ChatGPT.

I have been using Snowflake for a year.

The product is scalable and can be considered a good fit for small and medium businesses.

I haven't directly contacted the technical support team of the product.

I have used Azure Databricks and Azure Data Factory. My company decided to use Snowflake since we wanted to be able to get up and running fast without much configuration-related mess. Snowflake doesn't give you the options with the configuration part since, by default, it is available out of the box. In terms of machine learning, Azure Databricks has the upper hand over other products.

The product's deployment phase was quite okay.

The solution can be deployed in a few days or up to a week.

The product's price range falls between average to a bit expensive range. I think the tool is worth the money if you use it properly. It is difficult for me to speak about the number of users who use the product. My company pays around a couple of thousand dollars a month to 10,000 dollars or more.

I think the main benefit is that with the tool, you can easily get things going without problems since you don't need to configure all the parameters manually. If you buy the tool for a bigger computing purpose, the engineer can pay more attention to the tool, and I guess after that, you can do more with the solution. I would ask others not to think about the data warehouses, as Snowflake takes care of such areas.

The benefits from the use of the product can be realized in around 40 minutes. It is a good technology for getting up and running quickly.

Snowflake is integrated with Azure Data Platform and other ETL tools in our company's ecosystem.

The integration capabilities of the product are good and you get what you pay for when it comes to Snowflake.

I rate the tool a seven to eight out of ten.

The solution is primarily used for data warehousing. 

It's a good tool. It is quite easy to manage. 

There are a lot of features. 

If you accidentally delete something, you can time travel and retrieve it. 

Within half an hour or even 15 minutes, you can set up a new data warehouse, and you can clone a table or whatever you like. 

It's easy to provide access to clients if they need to.

The solution is stable. 

It can scale well.

There is good online documentation via the community, and you can learn the solution on your own. 

These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach. That's just a personal choice. I prefer the database views like you would get on an SQL Server or other databases. 

I've been using the solution for two and a half years or so. I haven't used it for too long. 

The solution is stable and reliable. There are no bugs or glitches, and it doesn't crash or freeze. I've never had an issue when you connect it to your infrastructure. I'd rate the stability nine out of ten. 

We have 250 or more users on the solution currently. They are predominantly IT specialists, including engineers and developers. It's for those on the application side of development. The solution is scalable. I'd rate the scalability nine out of ten.

I've never directly dealt with technical support. We do have a direct contact. There are other people who might have. There might have been a version issue at some point. However, it wasn't something I dealt with. I've only interacted with the Snowflake community pages. 

We are currently moving everything from Oracle to Snowflake. 

We've used a combination of other tools in the past. We've used Microsoft's Stack, for example. We were using a SQL database in the past. 

We're migrating from Oracle right now. We have two people that handle the maintenance of the solution. A company may need two to four engineers to manage maintenance 24/7.

It's not difficult to deploy. It's pretty straightforward. It took us only a couple of minutes in order to get everything up and running. 

We pay a licensing fee to use the solution. It's paid monthly. My understanding is that it is not that expensive. We might have a specific extra cost surrounding running it on a private cloud. I'd rate the cost as six out of ten. It's moderately priced compared to others on the market. That said, I don't directly manage the account and don't directly deal with pricing. We have a contract of three to five years. 

I'm an end-user. 

Everything is on the cloud, and therefore I'm always using the latest version of the solution. It updates itself regularly. 

It fulfills our needs, and it's easy to pick up by looking at some reference guides. I'm still getting used to the GUI. I might find it even easier to use if I go through more formal training. Right now, I've simply learned it on my own. Overall, I'd rate the solution eight out of ten.