We use the solution extensively for reporting and analytics. We put data into it and publish reports. A report could be a dashboard. The data is used for data-driven insights and AI and MLOps. There are many use cases for the data that we procure on Snowflake.

Snowflake Data Cloud [Private Offer Only]
Carahsoft Technology Corp.External reviews
External reviews are not included in the AWS star rating for the product.
The product is fast and easy to use, but it is expensive compared to other products in the market
What is our primary use case?
How has it helped my organization?
The product has impacted collaboration across our teams. The correlation is quite easy. We use the solution because most of our life sciences and healthcare customers prefer it. Their preferences directly impact us as vendors and partners. We have to promote the same tools and technology they are familiar with.
What is most valuable?
The product is quite fast. There are several connectors in Snowflake that we could leverage for ingesting data. The data could be in zettabytes or petabytes. It is easily manageable.
What needs improvement?
The cost is a bit high. The storage cost and the extraction cost of data are high. The final invoicing cost will be higher if we do a rich data-oriented task on Snowflake.
For how long have I used the solution?
I have been using the solution for close to three years.
What do I think about the stability of the solution?
The tool is stable and very powerful.
What do I think about the scalability of the solution?
We have at least 1000 users in our organization. We will surely use the product in the future.
How was the initial setup?
The solution is cloud-based. There is no on-premise solution. It has its own cloud. The installation is quite easy.
What was our ROI?
The solution is worth the money. It is good to use. It has a lot of features which are not available in other products. However, users must explore other products to control their costs.
What's my experience with pricing, setup cost, and licensing?
Other products like Google Cloud, AWS, and Azure have competitive pricing. Snowflake costs 15 to 20% more than AWS and Microsoft Azure.
What other advice do I have?
People who want to buy the product must initially use the free trial version. It can be installed on a desktop. The user can do a lot of R&D. We have a good playground. We can play with the components and learn them easily. We can learn how each component talks to each other, how the performance is, and how to create tables. There are a ton of tasks we can do.
After ingesting the data, we can perform advanced analytics and make models. The end users can do many things on the tool. It is quite an easy tool. I will advise any new user to install a free version. They will be able to learn about the product and get good insights when they work on their pilot project. Overall, I rate the tool a seven out of ten.
A scalable and cost-effective solution that stores data streamed from the source system
What is our primary use case?
We use Snowflake as a database to store all the data we stream from the source system.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using Snowflake for a couple of years.
What do I think about the stability of the solution?
Snowflake is a stable solution.
What do I think about the scalability of the solution?
Around 400 users are using the solution in our organization.
Which solution did I use previously and why did I switch?
We previously used IBM Netezza. We switched to Snowflake in 2020 because it provided us control over its scalability and costing model.
How was the initial setup?
The solution’s initial setup is comparatively easier.
What was our ROI?
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.
What's my experience with pricing, setup cost, and licensing?
Snowflake is a cost-effective solution.
What other advice do I have?
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.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Stable product with good analytics features
What is our primary use case?
Snowflake is good for analytical purposes when you have a lot of historical or sales data that you need to release and use for different types of analysis, such as tracking sales and measuring the performance of your sales team and product.
What is most valuable?
The product's most important feature is unloading data to S3. It provides a single syntax query to analyze data directly from a database to an S3 bucket.
What needs improvement?
The product's performance could be improved.
For how long have I used the solution?
I have been using Snowflake for a couple of months. We are using the latest version.
What do I think about the stability of the solution?
The product is stable.
What do I think about the scalability of the solution?
We did not need to scale our Snowflake environment beyond what we needed. We have a fixed amount of traffic from a fixed number of clients. We know the load we need to handle, and based on that, our subscription is made.
What's my experience with pricing, setup cost, and licensing?
Snowflake is cost-effective. The pricing is better than Firebolt. Firebolt is better when there is idle time. If we run Snowflake all the time, the cost will be higher.
What other advice do I have?
We are working on two solutions for Snowflake, one for the cloud and one for on-premises. It has good documentation. If someone goes through it, they will quickly understand how it works. However, Firebolt's documentation is more comprehensive. If I need faster results, I'll prefer the Firebolt; if I need performance, I'll use Snowflake.
Overall, I rate it a nine out of ten.
It is very fast and the performance is great but has some technical quirks
What is our primary use case?
I use it for data warehousing. I just design databases, put data in there, and get data out.
What is most valuable?
Although I haven't used it much, it is very fast and the performance is great.
What needs improvement?
It has some technical quirks that whoever is using it needs to be aware of. It doesn't enforce typical relational database constraints. If you're not aware of that, you can really put some bad data in there.
For how long have I used the solution?
I've been using it for about three months.
What do I think about the stability of the solution?
I would give it a ten out of ten. I haven't seen it failover.
What do I think about the scalability of the solution?
I've never had any issues with it. It is being extensively used. We have between a hundred and a thousand users using Snowflake.
How are customer service and support?
I have not had any experience with customer support, but I've heard it's good.
What's my experience with pricing, setup cost, and licensing?
I've heard it's quite expensive.
What other advice do I have?
I would give Snowflake a seven out of ten.
Easy to manage with lots of features and good reliability
What is our primary use case?
The solution is primarily used for data warehousing.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I've been using the solution for two and a half years or so. I haven't used it for too long.
What do I think about the stability of the solution?
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.
What do I think about the scalability of the solution?
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.
How are customer service and support?
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.
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
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.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Has good stability and processes the data efficiently
What is our primary use case?
We use the solution for data storage and integration purposes.
What is most valuable?
The solution's most valuable feature is path application.
What needs improvement?
They should improve the performance of the solution's transaction application.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
We have 20-30 solution users in our organization.
How are customer service and support?
The solution's customer service is good.
How was the initial setup?
The solution's initial setup was very straightforward.
What's my experience with pricing, setup cost, and licensing?
The price for the solution's license depends on the use cases.
What other advice do I have?
I recommend the solution to others and rate it as a nine. It efficiently processes the data and gets reports as well.
Which deployment model are you using for this solution?
Good scalability and has a simple query process
What is our primary use case?
We use the solution to build the pipelines in stream sets, including data source, data warehouse, and destination endpoints.
What is most valuable?
The solution's most valuable features are storage, run time, scalability, and minimum query time compared to other vendors.
What needs improvement?
The solution's stability needs improvement.
For how long have I used the solution?
I have been using the solution for seven or eight months.
What do I think about the stability of the solution?
Recently, I encountered an issue with the solution's data warehouse. The resource monitor had exceeded its quota. I rate its stability as an eight.
What do I think about the scalability of the solution?
I rate the solution's scalability as a nine.
Which other solutions did I evaluate?
We use Hive and Hadoop as well. Snowflake is more stable and scalable.
What other advice do I have?
The solution is more straightforward to use than the other IDBMS tools. It has a simple query process. Its computing time is less as well. One can easily have access to it. I rate it as a nine.
Optimizes costs, works with various clouds, and great dashboards
What is our primary use case?
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.
How has it helped my organization?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I've used the solution since 2020.
What do I think about the stability of the solution?
Stable
What do I think about the scalability of the solution?
Scalable
How are customer service and support?
Support can be enabled in the Snowflake UI.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
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.
What about the implementation team?
We did the initial setup on our own, and it was not difficult.
What was our ROI?
We constantly monitor the usage with grafana dashboards to keep the ROI growing and to assist/ alert users about any wastage.
What's my experience with pricing, setup cost, and licensing?
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/...
Which other solutions did I evaluate?
We considered MySQL and Google Big Query. We're also happy with Google Big Query.
What other advice do I have?
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.