Snowflake Reviews

We use the solution to support our data infrastructure.

The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake. We can configure the size of our workloads because Snowflake gives us control over the use of resources and costs.

I have heard people having difficulty with the machine learning model, so there may be room for improvement.

The cost of the solution is high and has room for improvement.

I have been using the solution for over one month.

I give the scalability an eight out of ten.

The solution is expensive but worth the cost because the quality is there.

I give the solution an eight out of ten.

I advise people to do as much research as they can before utilizing the Snowflake.

Snowflake is a real-time and cloud-based complete ETL tool. You can receive the beta from various sources from Amazon. You can run your reports and do analysis in  Snowflake. Informatica and Tableau should have done this. Snowflake is a modern version of Informatica which is 100 percent in the cloud.

Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution.

Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety.

I have been using Snowflake for approximately eight months.

Snowflake is highly stable.

Snowflake is a cloud solution that provides great scalability. However, I am not sure if it is cost-effective.

We have approximately 30 engineers using this solution. We have plans to scale our usage in the future. This is going to be a futuristic solution.

We have not had any problems with the technical support.

The initial setup of Snowflake is straightforward. To set up the ETL pipeline, pull the data, and then generate the reports takes approximately two hours, end to end.

I did the implementation in-house. We have a three-member team that does the maintenance of Snowflake. However, the amount of people needed depends on the size of the pipeline.

Snowflake licensing is more flexible and it is cheaper than other solutions. I can use it for only 10 days for MVP, or three years, and for flexible models. I can scale up, or down, and the pricing is based on the volume and duration. There are many licensing permutation combinations available.

I rate Snowflake a nine out of ten.

I am a solutions architect for Snowflake.

The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful.

I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end-users. 

Improvement to the end-to-end process of loading data into Snowflake could be made as well.

The product is stable so far.

The product is scalable enough.

The initial setup is not complex.

I believe that pricing is reasonable for this solution.

Snowflake is easy for business users to implement, allowing them to start small and grow big.

I think people are still debating on whether they should still continue with S3 and add Snowflake or, whether they should take away S3 and completely rely on Snowflake.

I would rate this solution an eight out of ten.

We use Snowflake for data warehouse modeling and reports.

Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.

The documentation could improve. They should provide architecture information.

There could be better integration with tools other than the common databases used to receive data. There are other tools that have ETL tools within, such as Tableau. You are able to work with information prior to sending it to Tableau. This feature would be nice to have in a tool from Snowflake.

In a future release, they should make it easier to do reporting. A drag and drop type feature would be good. If not a drag and drop feature, there should be some other easier way to do it than it is now.

I have been using Snowflake for approximately six months.

The experience that we have had until now is that we can use the Snowflake very well from the videos on the web. The knowledge that our company already has regarding this solution has helped. We are producing some very sophisticated solutions. There is plenty of material on the web that you would be able to have lessons and learn.

We have worked a lot with Tableau previously.

We deploy the solution on-premises because we are developers, the customer is the one who has it on the Cloud. We helped them with the on-premises deployment and then we install the software and we deployed our solutions made on-premises. We complete any changes that need to be done in order to work in the customer's landscape.

The time of the deployment depends on the solution the customer requires. If it's a small solution, typically it will take approximately two weeks. A medium solution, that takes from two weeks to eight weeks.  However, it depends on what you are trying to accomplish with the solution. If you are trying to do a very complex data warehouse, it's not the tool that times the most time, it's the analysis and design that takes the most time for deployment. Once that you have the analysis, design, and you transport them to Snowflake this is not difficult.

In any BI solution, you have a lot of changes because of what you need to do with the end-users, there are a lot of changes to the end-user. This can also take up some time for the deployment for the first time. It can take two to six weeks for a medium-sized project.

On average a small project can take three people. That's in small BI projects, in some customers that we have the project takes a maximum of six weeks in order to have all the data fields. This is not for a whole data warehouse but for sales and customers. Those are all small to medium-sized projects, that require three people maximum for deployment. You might always want to have in addition, an analyst and the senior architect. 

Most of our team are technicians.

Snowflake has a lot of capabilities and performance. However, the tool is not a silver bullet and can do everything. If you designed what you need according to the tool, then everything is going to be okay.

This is true for any tool. Many people start the projects without validating what they are going to expect to have at the end, they receive a big surprise. They were thinking that the tool has this capability and it doesn't have it or perhaps it has the capability but the design you have does not work correctly.

If you see the percentage of projects in the different customers in many places, such as in Mexico, Florida, and Miami. Snowflake is a tool that is currently being used but has not been in the past. There is not a lot of history.

I rate Snowflake a six out of ten.

We have not used Snowflake long enough to better rate it. If we had a lot more formal education or had more information or reference manuals our experience would be better.

Snowflake is used in my organization for our data warehouse.

All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse. 

It has very nice features, such as snapshots, marketplace, and it is very easy to receive data-warehouse specifications.

There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful.

I have been using Snowflake for approximately three years.

The installation is very easy. What is needed is a good extract, transform, and load (ELT) tool and we used Matillion.

The price of the solution is reasonable.

My advice to those wanting to implement Snowflake is it is easy. However, the way to choose to implement your data in the warehouse matters. When we started to implement our data with Snowflake, we also switched to a metadata-driven approach, but the method depends on the people involved in the implementation. Overall, the implementation of Snowflake follows similar principles as any other data-warehouse implementation except many aspects are a lot easier and helpful. 

I rate Snowflake an eight out of ten.

We are using it for a migration from on-prem to cloud.

Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake. 

There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it.

It has been almost two years.

A great feature of Snowflake is that you can resize your warehouse according to your needs. Whenever we are expecting a huge amount of data, we can scale it up. It does that automatically as well, which is the best thing. We don't have to worry about that, and there is also no need for a database administrator. We do not need any DBA for this.

We have contacted them only for the basic setup. Most of the time, we were able to get the right solution at the right time. We got great support from them.

They're doing a pretty great job in providing all the information. They have a great community and great coverage, and there is a lot of information available over the internet.

Its setup was quite straightforward. I did not find any complexity with that.

I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production.

One of the concerns related to Snowflake is about longevity in terms of how long can we use Snowflake. It is a big question in the market. It is a new baby in the market, and we don't know for how long will it trend. It has some big competitors. Firebolt claims to be the number one in this area. They have much better features than Snowflake. I would not say that Snowflake is the best and in the right position at this point in time. Snowflake is good for the next year, but Firebolt is going to bring it down.

I would rate Snowflake an eight out of 10.

The solution is primarily used as a data warehouse.

The solution is very easy to use.

The product is very stable and flexible. The performance is good.

The product is quite scalable.

The solution needs to offer more functionality related to machine learning and artificial intelligence.

The solution needs more connectors.

I've been using the solution for close to two years.

The solution is very stable and extremely reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is very good.

The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.

We have about 100 people on the product currently.

Technical support overall has been good. They are helpful and responsive. We have no complaints. 

I have some experience with Teradata.

There is no installation process, as it is run as software as a service on the cloud.

For deployment, I would say two to five people would be enough. It depends on the size of the project and can have from one person to 20 people supporting it. It really depends on the implementation. The people would likely be admins, engineers, and managers.

The product requires the purchase of an annual license.

Before choosing this solution, we looked at SQL Server and Teradata.

We're customers and end-users.

We're using the latest version of the solution. I can't speak to the exact version number.

I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities.

I'd recommend the solution to other users and companies.

We are completely migrating to Snowflake, and we are in transition. It is primarily to combine all our data repositories into a single place. We have SAP BW and SAP HANA, and some of our business units have their own databases. We chose Snowflake to consolidate all of our data into a single place and then build enterprise data. We are then going to provide the data for our businesses in shared databases, on which they would do reporting. They will also have the ability to bring in their own data, which is currently not possible. They will also be able to do advanced analytics, machine learning, and AI in Snowflake, which is not fully possible on our current platforms. It will be used for all the operational reporting, such as sales, supply chain, appraising, and merchandising. We just started to do reporting related to sales and supply chain inventory.

We have its latest version. It is currently deployed on Amazon AWS, but we are moving to Google.

There are so many features that Snowflake offers to address the challenges that people have been facing in the traditional data warehouses for a long time. It allows us to have a single repository for all the data. Currently, we have data repositories all over the place, and we want to bring everyone onto one platform so that it can be utilized across the organization. Currently, we need database administrators and SAP administrators to manage multiple databases and platforms. With Snowflake, we don't need any admin, and there is zero maintenance. All we need is a platform architect who can just manage the Snowflake platform to create databases and security roles, and then you can share the data. By integrating everything into a single Snowflake platform, we have lowered the total cost of ownership quite a bit.

The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. 

Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities.

There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business.

They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. 

There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that.

I have been using this solution for two years.

It is all cloud. It is really stable. We haven't seen any problems.

We can scale up or down based on our needs. We don't have tons and tons of data, but based on the quality feedback from our vendors, it can handle large volumes and has the competency. With the dynamic scale-up feature, we are confident that it is going to meet all our requirements.

Currently, our number of users is very limited because we have just started the migration. We don't have many users on the platform. All of our focus is on Snowflake because we're moving to Snowflake, and its usage will increase in the future.

I do not directly interact with the support, but I believe our platform architect reached out, and he got a response.

We had SAP BW and SAP HANA as our main data platforms. We are slowly decommissioning SAP BW and SAP HANA and completely migrating to Snowflake. We wanted to have a single repository for all the data. The cost was also a factor.

It is straightforward. To expose the data in the cloud, we had to go through our info security and legal, so that's the part that took time. After that is done, the process for setting up the platform, getting signed up with the initial free credits, and signing up the licensing for the credits was straightforward.

We are working with a system integrator or vendor for this project. Our strategy is to work with an experienced vendor for the first project, and after that, we would be able to drive things forward.

Our experience with them is good. They're building the architecture of Snowflake. They have experience, and we have our own thoughts. We are working together and making sure that the architecture is for the long-term and not just for one project. Whenever we see that their focus is limited to the project, we are asking them questions to make sure that they are making the right decision.

In terms of maintenance, it doesn't require any maintenance, but you do require architects. We have three architects. One architect is responsible for the platform and takes care of creating security rules, grants, and users. We also have an integration architect who is responsible for data acquisition, ETL, and stuff like that. We have a data architect who is responsible for the overall data architecture in terms of what layers we need to establish and how do we model the data and publish that for consumption.

There is a separation of storage and compute, so you only pay for what you use. 

The key part is skill set because Snowflake is all SQL-driven data warehousing. Internally, we have some SAP BW development resources, and they need to learn and move on to understanding SQL-based coding and custom data warehousing concepts.

I would rate Snowflake a nine out of ten.