Javed Chowdhary - PeerSpot reviewer
Lead Software Engineer - Data Cloud at Mastercard
Real User
Top 10
Serves as a cost-saving tool and offers good performance
Pros and Cons
  • "Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
  • "Snowflake's Snowpark is an area of concern where improvements are required."

What is our primary use case?

I use the tool for data warehousing, analytics, and machine learning.

What is most valuable?

The most valuable feature of the solution Stems from the fact that the tool offers a virtual warehouse along with multiple other features.

What needs improvement?

Snowflake's Snowpark is an area of concern where improvements are required. Snowflake's Snowpark is a pretty new concept. Snowflake's Snowpark should improve my adding new libraries and getting the codes deployed quickly.

For how long have I used the solution?

I have been using Snowflake Analytics for more than five years. I am an end user of the product. I am also a developer who builds platforms for others with the help of Snowflake Analytics. There is no version of the product in general, as it is a full-fledged product.

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

What do I think about the stability of the solution?

It is a stable solution. Stability-wise, I rate the solution a ten out of ten.

What do I think about the scalability of the solution?

The scalability of the product is pretty good. It is a highly scalable product. I rate the product's scalability a nine out of ten. Users can scale up or scale out the solution.

I use the solution daily in my company.

Presently, there aren't many uses of the solution in my company. In the future, I believe that the number of users of the product in my company will increase.

How are customer service and support?

My company is in contact with a technical person from Snowflake Analytics, who helps us. I rate the technical support a seven or eight out of ten.

How would you rate customer service and support?

Positive

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

I have experience with Oracle, Microsoft SQL Server, and AWS.

My company started to use Snowflake Analytics since we did not want to have an on-premises product. Snowflake Analytics was also cost-effective for our company.

How was the initial setup?

I rate the product's initial setup phase an eight or nine on a scale of one to ten, where one is a difficult process, and ten is an easy process. The setup process is straightforward.

The deployment requires users to have an account, and since it is a SaaS solution, Snowflake Analytics manages all the Infrastructures based on which the tool provides the user login details. The user creation is also pretty smooth with the product, so a user can start using it quickly.

The solution is deployed on the cloud services offered by AWS.

The solution can be deployed in a week, along with the licensing part.

For the deployment of the product, one architect from Snowflake, one person from AWS, and two admin developers, are required.

What about the implementation team?

For my current project, a third-party involvement was there in the installation phase of the product. Previously, I was involved in the product's installation process, which involved the licensing part and setting up of the environment.

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

I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price. There are some additional costs based on the number of users or data warehouses.

Which other solutions did I evaluate?

Against Snowflake Analytics, my company has an option called Databricks. For our company's primary use cases, we prefer Snowflake Analytics.

What other advice do I have?

Snowflake Analytics has supported our company's data warehousing and analytics part by helping us reduce our overall costs involved in such areas. The product also offers a better performance than the on-premises tools that are available.

Snowflake Analytics has improved our company's data-driven decision-making processes since the go-to-market timeline has been reduced with the use of the product. Earlier, the go-to-market timeline was such that my company used to take over a month to get new data for the end users. My company can get the data within a week or before, allowing users to use it for their analytics. The tool has reduced the go-to-market timeline.

The benefits from the product's scalability and performance features stem from the fact that it helps with the costs and reduced go-to-market timeline to get things up and ready for the end users, which is drastically much less than what the on-premises products offer.

The product's maintenance can be taken care of by two people.

The scalability of the product has impacted our company's data-driven decision-making since I have a lot of data with me currently. For initial loads, my company uses small warehouses, but after a while, it will be big warehouses. Based on the aforementioned details, my company makes data-driven decisions, like how much warehouse size we need or whether we need to scale up or scale out.

Snowflake Analytics is better than the other platforms that work on either a cloud or an on-premises version. Snowflake Analytics can improve in areas like scalability and in the way the queries are written.

Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company.

Others who plan to use the solution can benefit from it. I recommend others consider or try out a PoC phase or exploration process of the product to see whether the tool fits their use cases.

I rate the overall tool an eight out of ten.

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.
Flag as inappropriate
PeerSpot user
Luiz Cesar Gosi - PeerSpot reviewer
Senior Analytics Engineer at TalkDesk
Real User
Top 5Leaderboard
An easy-to-use solution that performs well and provides excellent integrations
Pros and Cons
  • "It's not necessary to use a physical server."
  • "The UI must be improved."

What is most valuable?

I like the integrations available in the product. We can send the data to our data warehouse if we want to transform it. I like the cloud solution. It's not necessary to use a physical server.

What needs improvement?

The UI must be improved. It would be pretty helpful to have some images showing what we are doing and how we use the tool.

For how long have I used the solution?

I have been using the solution for two years.

What do I think about the stability of the solution?

I rate the tool’s stability a nine out of ten. We don't have any problem with data orchestration or data transformation. It’s pretty good.

What do I think about the scalability of the solution?

I rate the tool’s scalability a nine out of ten. The tool is dedicated to the data team. Around 20 to 30 people use the product in our organization.

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

I have used Redshift and other data warehouses from Google. I used them to extract data in Oracle for 18 years while working in a telecom company. I prefer Snowflake over the others.

How was the initial setup?

The initial setup was a little bit hard. It was especially hard to create a connection with the product team. The product team generated the data, and we had to create some tasks before they were sent to Snowflake. It was difficult because everyone was pretty new to the solution and did not have the necessary knowledge then. The setup was not intuitive. By the end, we understood how to deploy it. The product is deployed on the cloud. The initial deployment took one or two weeks. Later, it takes two or three days to change or update things.

What about the implementation team?

We implemented the product in-house.

What other advice do I have?

Using the product is more about our perception and technical skills in data modeling and querying. If we use it well, the tool runs well more than 90% of the time. It’s easy to use the solution because it has everything that we need. It performs well. People who want to use the solution must create a demo account and try using it. We must optimize our SQL queries. It is helpful to understand the volume of our data before writing codes. Overall, I rate the tool a ten out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Snowflake Analytics
April 2024
Learn what your peers think about Snowflake Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
771,170 professionals have used our research since 2012.
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions
Real User
Top 5Leaderboard
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
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
Top 10
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
Vice President --Analytics & Digital Transformation at Polestar Solutions & Services India Pvt Ltd
MSP
Top 5Leaderboard
Comes with a simple learning curve, making it easy to understand and learn for users
Pros and Cons
  • "Scalability-wise, I rate the solution a ten out of ten."
  • "The product's cost is an area of concern where improvements are required."

What is our primary use case?

I use the solution in my company for the real estate and housing industry. The tool is also used in the CPG industry.

How has it helped my organization?

The benefits that my company has experienced from the use of the product stem from the fact that it is easy to maintain the platform. The most important part about the product is that it is designed with the help of SQL, so users need not have a specific skill set to run the product. Any person with knowledge of SQL can easily use the product.

What is most valuable?

The most significant feature of the product that has an impact on data analytics stems from the fact that the tool offers functionalities to help users with data warehousing and AI features. The features of the product are available in such a way that there is a separation in the nature of the computation and storage part the tool offers, making the overall tool very fast. The product is easy to use since it uses SQL or structured query language. Most of the people or technicians in the market are comfortable with SQL or structured query language, making it a tool that is easy to use and understand since it is easy to learn about the solution. Developers or programmers with knowledge of SQL can easily move to Snowflake Analytics, as the product comes with a simple learning curve.

What needs improvement?

The tool needs to introduce a desktop client so that users can handle the design part, as it is one area where the product lacks and needs to improve. Instead of having to visit the product's web portal, the tool should be installed on a desktop client through which users can indulge in the development process on their local systems.

The product's cost is an area of concern where improvements are required. One part of the cost is attached to the product, and the other part is attached to the solution provider. There should be more transparency provided to users, stating which costs are attached to the product and the prices managed by the solution provider.

For how long have I used the solution?

I have experience with Snowflake Analytics for five years. My company has implemented the product for some of our clients.

What do I think about the stability of the solution?

Stability-wise, I rate the solution a nine out of ten.

A lot of features are offered under different tools from Snowflake Analytics. Recently, the product has started to use Python language, along with other languages like SQL. Users need to rely on and use the cloud to carry on with the development phase attached to the solution.

What do I think about the scalability of the solution?

Snowflake Analytics offers the same amount of scalability as the other solutions in the market because it is a tool that is available on the cloud. Scalability-wise, I rate the solution a ten out of ten.

My company deals with around six to seven customers of the product.

I would say that around 100 people use the tool.

How are customer service and support?

There is a different team in my company that connects with the solution's technical support.

How was the initial setup?

The product's initial setup phase is easy in the areas of development and implementation.

The product's deployment phase needs users to follow the standard procedures used under the CI/CD deployment process. You can design it with the help of the CI/CD deployment process. The deployment process is simple.

The solution is deployed on the cloud.

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

The product's licensing cost varies depending on the models and different structures offered by the solution. I feel that the cost of the product is fine. I rate the product's licensing cost a five or six on a scale of one to ten, where one is low price, and ten is high price.

What other advice do I have?

The product is useful in areas like data warehouse and data analytics since such functionalities of the tool are widely used by my company's clients.

Considering the ease of use that the product provides to support my company's teams' daily operations, I would say that the tool offers help in the area of projects and support.

The product handles data security and compliance areas by providing high security as the tool offers container services, making it highly secure for users during data sharing. The users can have permission authority, without which others cannot see the data that is highly secured within the container.

I recommend the product to those who plan to use it.

The product is easy to scale out. The solution is available on the cloud, and its basic development nature falls under the SQL side, which is something that makes it favorable for development teams across the world. It is easy to learn about the product and start working on it, meaning it has a simple learning curve.

I rate the overall tool a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
Flag as inappropriate
PeerSpot user
Development manager at Amdocs
Real User
Top 10
Highly-recommended, efficient and affordable solution for data processing
Pros and Cons
  • "One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten."
  • "The solution’s interface is good but it could be improved."

What is most valuable?

One of the valuable features is the solution’s time travel capability. The loading process exhibits characteristics of low coding for similar loads. Unlike before, where extensive scripting was necessary, Snowflake Analytics simplifies tasks such as file exposure through SQL, a familiar and flexible language for all. Even common commands like the copy command become more straightforward, making coding in this solution more accessible and efficient.


What needs improvement?

The solution’s interface is good but it could be improved.


For how long have I used the solution?

I have worked with the solution for almost three years.

What do I think about the stability of the solution?

The solution is highly stable.


What do I think about the scalability of the solution?

The solution is highly scalable. We cater to enterprise businesses. I rate it a perfect ten.


How was the initial setup?

The initial setup is straightforward, and the deployment process is quick and efficient.


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

The solution's pricing is affordable.


What other advice do I have?

I recommend the solution. Overall, I rate it a perfect ten.


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: Implementer
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.
Flag as inappropriate
PeerSpot user