Try our new research platform with insights from 80,000+ expert users
SaurabhSingh4 - PeerSpot reviewer
Data Analyst at Wespath Benefits and Investments
Real User
Top 5Leaderboard
Intuitive solution that provides variety of tools for performing advanced analytics
Pros and Cons
  • "It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."
  • "Machine learning should be improved."

What is our primary use case?

We use it for our full application operational analytics, including building, storing, and analyzing the data. It provides us with detailed insight, making it easy to extract needed reports. Everything related to business intelligence, whether it's reporting or analytical modules, is stored on the Snowflake Analytics platform.

What is most valuable?

It's an intuitive platform that allows organizations to rapidly adapt, providing the ability to quickly analyze and make data-driven decisions. It ensures the optimization of the application development while maintaining the user-friendly nature of its UI.

What needs improvement?

Machine learning should be improved. Some of the solutions, such as Databricks, offer an option to directly write and integrate Python code on the spot, but Snowflake doesn't have that feature yet. Adding it would be useful, as it would facilitate building models.

For how long have I used the solution?

I have been working with Snowflake Analytics for a year.

Buyer's Guide
Snowflake Analytics
October 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is a stable platform.

What do I think about the scalability of the solution?

It offers good scalability.

How are customer service and support?

I am highly satisfied with their level of customer service and support. I would rate it nine out of ten.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was done seamlessly.

What about the implementation team?

There was no requirement for installation. They provided us with a link, giving us access to the cloud.

What's my experience with pricing, setup cost, and licensing?

It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price.

What other advice do I have?

Snowflake Analytics is a really good choice for organizations that are looking at a cloud analytics platform for reporting, data modeling, and advanced analytics without machine learning requirements.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
Real User
Provides great performance and flexibility
Pros and Cons
  • "Very good flexibility and it offers computation completely decoupled from the storage."
  • "If you have a lot of computations, it becomes very costly."

What is our primary use case?

Snowflake replaces enterprise data warehouses that have traditionally been on-premise and had to be managed by the enterprises themselves. We are a services company and we create these data platforms for our enterprise customers in a variety of industries including health care, education, travel and tourism. We create and build services around Snowflake and part of my job is to assess its suitability for our enterprise customers. We are partner of Snowflake. 

What is most valuable?

The solution is completely managed and that's fantastic. Its a true SaaS kind of Data platform. You can create analytical products as a SaaS offering, nothing needs to be installed and no licenses needed. The solution can run on AWS, Azure and on Google Cloud and you can choose the underlying cloud on which Snowflake creates your databases, uses different services, stores your accounts and stores your data. It offers high flexibility. It offers computation completely decoupled from the storage so you pay fees for computation cost only, and storage is very very cheap. For example, within the enterprise data warehouse, if the total compute time is two hours a day but the traditional setup has to be maintained and managed round the clock, and the data also has to be permanently stored, them moving to Snowflake would ensure that the enterprise pay much less for storage, and pay for only 2 hours of computation. Performance-wise also it's a good solution. 

What needs improvement?

In your data platform, if you have a lot of computations, Snowflake can becomes costlier with. There can be some complexity when designing your warehouses or enterprise data, but that is based on your requirements and not the underlying warehouse that you choose.

For how long have I used the solution?

I've been using this solution for about 4-5 years.

What do I think about the stability of the solution?

It's extremely stable because it's backed up, load-balanced and has the elasticity that the underlying cloud (AWS, Azure, GCP) provides. 

What do I think about the scalability of the solution?

The solution is scalable and has the concept of creating virtual resources, so as an example, I can buy 10 gigabytes of data capacity, then decide to process that data every day, Snowflake then takes care of creating multiple databases/storages, and scales by itself. I don't need any calculations of load or throughput worked out beforehand. For most other similar products, such as RedShift or Azure Synapse, you have to work out your average load and peak loads beforehand , and provision the warehouse and other services. In Snowflake, you don't need to do that, it auto-scales up and down.

How are customer service and support?

Customer service has and support are at par with any professional Data Platform service.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is straightforward. You buy an account, and add the number of accounts you need, and that's it. It takes about five minutes. 

What's my experience with pricing, setup cost, and licensing?

The solution can become expensive when you increase your computation. So one has to design the solution very carefully and optimally. Leverage it heavily for Storage, but for compute, make sure the resources (e.g. Virtual Warehouses, Snowpipe, Streams, Tasks etc.) as well as the transformations are used in the most optimum way. For example, during the design time, the technical team has to wisely think if your data marts can be Views or Tables (View consumes compute, but Tables consume Storage), how frequently your data marts need an update, whether you should write lesser but complex queries of more but simpler transformation queries and stored procedures and many other things. But its ease of use, decoupling of Compute from Storage, ability to share data, and highly managed behavior make it worth the money.

What other advice do I have?

I highly recommend Snowflake wherever possible. 

I rate this solution 9 out of 10. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Snowflake Analytics
October 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
reviewer1554165 - PeerSpot reviewer
Data engineer manager at a tech vendor with 10,001+ employees
Real User
Multifeatured as it has sharing, cloning, time travel, and fail-safe attributes
Pros and Cons
  • "What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all."
  • "A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark. An additional feature I'd like to see in the next release of the solution is built-in analytics."

What is our primary use case?

We wanted a solution which is on cloud and gives us data warehousing and analytics capabilities, so these are our use cases for Snowflake Analytics.

How has it helped my organization?

Snowflake Analytics improved our organization because it was capable of doing what we needed. They are also coming up with more characteristics or more features, but at this point in time, what's currently available in the solution is very convenient for us to use. We've incorporated the features of Snowflake Analytics according to our business needs.

What is most valuable?

What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all.

What needs improvement?

A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark.

An additional feature I'd like to see in the next release of the solution is built-in analytics.

For how long have I used the solution?

I've been using Snowflake Analytics for more than two years, and I've used it within the last twelve months.

What do I think about the stability of the solution?

Snowflake Analytics is a stable solution.

What do I think about the scalability of the solution?

Snowflake Analytics is a completely scalable solution.

How are customer service and support?

The technical support for Snowflake Analytics is responsive, and on a scale of one to five, I'm rating support a four.

How was the initial setup?

The initial setup for Snowflake Analytics was easy. The deployment time for the solution was, on average, five to six hours, and it was dependent on the user history created for a particular sprint.

What was our ROI?

As of now, I have not seen ROI from Snowflake Analytics.

What's my experience with pricing, setup cost, and licensing?

I'm unable to give information about the licensing fees for Snowflake Analytics because it's the infrastructure team who takes care of licensing completely.

What other advice do I have?

I have experience with Snowflake Analytics, and I'm using its latest version. The solution is deployed on the public cloud, on AWS.

There are two users of the solution within the company, and we have two people, particularly IT analysts, in charge of the deployment and maintenance of Snowflake Analytics. There's a plan to increase usage of the solution within the company.

My advice to others looking into implementing Snowflake Analytics is that if you are looking for a stable solution with good features for upcoming business problems, you can go with cloud data warehouse technology such as this solution.

I would rate Snowflake Analytics eight out of ten. I'm not giving it a perfect score because there is always room for improvement, for example, built-in analytics and its Spark connector.

My company is a partner of the vendor and implements Snowflake Analytics.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
AnujJain - PeerSpot reviewer
AVP Data Engineering at Genpact - Headstrong
MSP
Good storage and optimization with helpful support
Pros and Cons
  • "The performance has been good."
  • "We haven't seen any areas that are lacking."

What is our primary use case?

The solution is a flexible data warehouse. It can be used for computing and storage. There's also the potential for automation. With Snowflake, you can use the same copy in multiple places.

Once your data is on Snowflake, you can have that data differential to reportings. You can start using the analytics on top of it as well.

What is most valuable?

The data integration is great. We don't have to do data pipeline creation or time travel testing. 

The storage is good.

It's got good optimization.

We really like the engineering and the data within Snowflake.

The performance has been good.

We like how we can have one copy that can be used in multiple places. 

What needs improvement?

We haven't seen any areas that are lacking. I can't recall coming across missing features. Over the last two to three years, we haven't had issues. 

For how long have I used the solution?

I've used the solution for almost three years now.

What do I think about the stability of the solution?

The solution is stable. A lot of it comes pre-configured and we haven't had any issues with it. There are no bugs or glitches and it doesn't crash or freeze.

What do I think about the scalability of the solution?

With Snowflake, you are using the cloud, storing data in a cloud. It's scalable for that reason. It's not a problem if you need to have more data or more space.

How are customer service and support?

Typically, the client will have their own support team. We don't really deal with the support side of things. 

My understanding is that their support is pretty good and clients are happy with their level of service. They work hard to resolve issues. 

How would you rate customer service and support?

Positive

How was the initial setup?

The deployments vary. We first need to understand what the deployment is, and how much data will be pulled. When it comes to implementation, sometimes clients do some revisions and that must be taken into account as well. 

You need some expertise. Setting up Snowflake, the installation, configuration, and everything, are all separate skills altogether. 

That said, it's not overly difficult. Most of it the things you're doing are automatic value configuring for the grid function.

What about the implementation team?

We are able to handle the initial setup for clients. We collaborate with Snowflake.

What was our ROI?

We haven't witnessed any ROI, however, it's not really a goal of the solution. 

What's my experience with pricing, setup cost, and licensing?

The cost of the solution depends on how much you are using it, and therefore, the pricing can vary from company to company.

What other advice do I have?

We are partners with Snowflake. 

In the last four or five years, Snowflake has actually blown up. Before that, it was quite low in terms of visibility and potential. We have now done multiple engagements on Snowflake.

Right now the snowflake is adding the multiple clients we using all editions.

We're using a variety of clouds, including AWS and Azure. 

I'd rate the solution nine out of ten. While we've done many complex implementations, Snowflake always has a way of simplifying things. 

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Data Architect at Cognizio
Real User
Top 20
An user-friendly solution that allows you to scale up or down based on usage
Pros and Cons
  • "One advantage is that installation is unnecessary since it's cloud-based. You subscribe to a Snowflake instance, configure it, and start using it. It's very user-friendly and allows you to scale up or down based on usage."
  • "I don't see many drawbacks with Snowflake Analytics, but it's not as mature as other tools. It is evolving and needs to integrate various features, like data loading and analytics, better. These components are not fully connected, so the tool should become a more integrated application."

What is most valuable?

One advantage is that installation is unnecessary since it's cloud-based. You subscribe to a Snowflake instance, configure it, and start using it. It's very user-friendly and allows you to scale up or down based on usage.

What needs improvement?

I don't see many drawbacks with Snowflake Analytics, but it's not as mature as other tools. It is evolving and needs to integrate various features, like data loading and analytics, better. These components are not fully connected, so the tool should become a more integrated application.

The solution is costlier than Azure or other tools like Pentaho, which are cheaper but require more effort in ETL or ELT development and integrating all the tools.

What do I think about the scalability of the solution?

Snowflake Analytics integrates well with the data, keeping everything within the same network and premises, eliminating network latency, and ensuring fast performance. Scalability is a strong point, as the compute and storage layers are separate, allowing independent scaling. This elasticity means that as more users or developers work on it, Snowflake can handle any load by leveraging CPU and GPU capacity.

What other advice do I have?

I rate the overall solution an eight out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Dmitri Solodovnik - PeerSpot reviewer
Business Intelligence Team Lead at Oxagile
Real User
Top 10
A stable solution that has the ability to control and manage the cost of a project
Pros and Cons
  • "The most valuable feature of Snowflake Analytics is the ability to control and manage the cost."
  • "The solution’s scalability could be improved."

What is our primary use case?

We use Snowflake Analytics as the main data source for a project.

What is most valuable?

The most valuable feature of Snowflake Analytics is the ability to control and manage the cost.

What needs improvement?

The solution’s scalability could be improved.

For how long have I used the solution?

I have been using Snowflake Analytics for about two and a half years.

What do I think about the stability of the solution?

The solution's stability is pretty good. I rate Snowflake Analytics a nine out of ten for stability.

What do I think about the scalability of the solution?

Around 1,000 users use the solution in our organization.

I rate Snowflake Analytics a six out of ten for scalability because we faced some issues on big projects.

How are customer service and support?

The solution's technical support team responds on time, but some complicated issues take time to be resolved.

What's my experience with pricing, setup cost, and licensing?

Snowflake Analytics is not an expensive solution, and its pricing is average.

What other advice do I have?

Overall, I rate Snowflake Analytics an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Jyothirmai Gopereddy - PeerSpot reviewer
Azure Manager at Tredence Inc.
Real User
Great inbuilt infrastructure but no end-to-end execution of jobs
Pros and Cons
  • "Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake."
  • "End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization."

What is our primary use case?

I mainly use Snowflake Analytics for Power BI reports.

What is most valuable?

Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake.

What needs improvement?

End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization. Allowing sequential flow of orchestration would be an improvement. In the next release, Snowflake should include direct integration and communication between other cloud systems.

For how long have I used the solution?

I've been using Snowflake Analytics for over a week.

What do I think about the stability of the solution?

Snowflake Analytics is stable.

What do I think about the scalability of the solution?

Snowflake Analytics is scalable.

How was the initial setup?

The initial setup was straightforward, and I would rate the process as four out of five.

What's my experience with pricing, setup cost, and licensing?

Snowflake Analytics is a little more costly than Azure.

What other advice do I have?

Snowflake Analytics is more managed than other cloud offerings, which means I don't have to deal with anything happening in the backend. For those thinking of implementing Snowflake, I advise analyzing the cost, your volume of data, and the number of users. If you have a huge demand on these things, I would recommend choosing Snowflake. I rate Snowflake as seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer2236227 - PeerSpot reviewer
Manager | Data Science at a tech company with 201-500 employees
Real User
Top 20
Has a user-friendly authentication feature, but it could have an accessible toolbox
Pros and Cons
  • "It is quite a convenient tool."
  • "The platform could work easier for AI implementation compared to one of its competitors."

What is our primary use case?

We use Snowflake Analytics for data cataloging, data science, and managing sales development.

What is most valuable?

It is quite a convenient tool and has a user-friendly authentication feature.

What needs improvement?

The platform could work easier for AI implementation compared to Databricks.

For how long have I used the solution?

I have been using the platform for six months.

What do I think about the scalability of the solution?

We have ten Snowflake Analytics users in our organization.

Which solution did I use previously and why did I switch?

Compared to Snowflake, changing the data and gaining insights from the application development process while working with Databricks is simpler. It has a more user-friendly and accessible toolbox.

What other advice do I have?

I rate Snowflake Analytics a seven out of ten. It is a good and useful platform. I recommend it to others. We can automate data pipelines using it. I advise others to make sure it meets their business requirements.

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Snowflake Analytics Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 2024
Buyer's Guide
Download our free Snowflake Analytics Report and get advice and tips from experienced pros sharing their opinions.