We just raised a $30M Series A: Read our story
2018-11-11T00:06:00Z

What is your primary use case for Snowflake?

38

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
3737 Answers

author avatar
Top 10MSP

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

2021-08-11T15:04:39Z
author avatar
Top 20Real User

I use this solution for actively building out the cloud data warehouse and data platform for enterprise level customers as well as startups. Generally, our clients are looking for a data warehouse on the cloud to enable them to scale infinitely at a lower cost. I've worked for a finance analytical team building their data lake, the data platform on top of Snowflake, as well as for a telehealth team. It's basically about getting data from multiple sources and building out an entire data platform with data governance. We are customers of Snowflake.

2021-06-13T13:33:05Z
author avatar
Top 5LeaderboardReal User

We are using it as a Datalake and a DWH.

2021-05-03T14:09:35Z
author avatar
Top 20Real User

We have a data mart, and we are using it to share data with big enterprise customers with major security requirements.

2021-04-15T07:17:20Z
author avatar
Top 5LeaderboardReal User

It is used in my company as well as in my client's company. We are a system integrator, so naturally, we need to have the centers of excellence and competencies in Snowflake.

2021-04-09T16:28:22Z
author avatar
Top 5LeaderboardReal User

We have used Snowflake as a data warehouse solution in one of my projects and as a combination of data lake and DWH for another project. In the second project, we migrated from a SQL DB to Snowflake as the DB was becoming a bottleneck in terms of storage and also in speed of execution of the queries as the data was growing. We also have JSON, which is hard to store and process in a SQL database. This is something that is handled beautifully by Snowflake. In the first project, we used Snowflake as a simple DWH to store and process data. Also, as a BI reporting source.

2021-04-06T15:04:00Z
author avatar
Top 5LeaderboardReal User

We use the solution for data warehouses and data modeling.

2021-04-01T16:05:50Z
author avatar
Top 20Real User

We're running a POC to test scalability, performance, on-demand resource management, workload management, et cetera. The security aspect will also be important for us.

2021-03-02T18:05:02Z
author avatar
Top 20Real User

The solution provides services to our customers.

2021-02-25T21:50:48Z
author avatar
Top 20Real User

We primarily use the solution to build some cost-effective solutions for a data warehouse, mostly for all non-transactional data.

2021-02-23T05:38:53Z
author avatar
Top 10Real User

For Snowflake, we had four main use cases. The first use case was related to a data warehouse, and my banking client wanted to move his SQL Server database to Snowflake. All the source systems were also on Oracle and file-based systems, and the target data warehouse was SQL Server. From SQL Server, the client wanted to move to Snowflake. The second use case was related to a chat or messaging client. They were using EMR Hadoop as their data warehouse, but it was not performing, so we had to move the EMR Hadoop to Snowflake. The third use case was related to a ServiceNow compliance system, where ServiceNow was using SAP HANA for its reporting data warehouse, but it was too slow. It was not performing, and it was causing a lot of problems. We moved that ServiceNow compliance system from SAP HANA to Snowflake. The fourth use case was related to a huge SQL Server database for a banking client. We moved the entire SQL database to Snowflake.

2021-02-23T05:18:17Z
author avatar
Top 10Real User

We implement this solution for our customers. It is a cloud data warehouse. It is SaaS, and it can be run on Azure, AWS, or something else. We are using its latest version.

2021-02-15T18:58:49Z
author avatar
Top 5LeaderboardReal User

We are using it for our security products. We have a trial account, and we are using the trial database and practicing on top of it. We have the latest version of this solution.

2021-02-01T10:35:32Z
author avatar
Top 20Real User

It was only a workshop with training to know the tool. We were just testing the technology, and it was just a demo of the tool. We wanted is to connect switches with IoT and use Snowflake as an engine to process all the big data. It was on top of AWS, but our infrastructure is on top of the Google Cloud Platform. The intention was to see if we can process on the front-end that we have. We have a console that processes a big amount of data. Instead of using BigQuery, we used Snowflake to see if it is cheaper than using BigQuery, but Snowflake wasn't cost-effective. In the end, we didn't go for this solution. We just saw how it can be implemented, but we never bought anything.

2021-01-28T11:53:32Z
author avatar
Top 20Real User

I have used it in my previous company. It was just a SQL server data warehouse using reporting tools on top of it. It was an on-premise SQL server environment, and it was a typical data warehouse use case, but we wanted to do things faster and more cost-effectively. We used it to modernize our data warehouse. We didn't want to invest more in on-premise servers, and we were looking for a way to quickly get more data joined together.

2021-01-24T15:56:01Z
author avatar
Top 10Real User

We are a consulting company so our primary use depends on the niche that we are providing the services to and on which of the different versions they have. I think we are mainly using Snowflake Enterprise. In general, it is being used for integrating information. Snowflake is a database platform, it gives information to support analytic needs, such as advanced data analytics like machine learning. In some of those cases it is also used for descriptive analytics, for instance BI.

2021-01-24T08:53:00Z
author avatar
Top 5Real User

We use this solution for business intelligence. We have three persons in the team for developing the end product.

2020-12-24T16:27:45Z
author avatar
Top 10MSP

We primarily use the solution for the data warehouse.

2020-12-18T10:47:37Z
author avatar
Top 20Real User

We are a management consulting firm and do not use this product for ourselves. Rather, it is a service for our clients.

2020-12-07T18:54:40Z
author avatar
Top 5Real User

We use it for presentations to clients.

2020-11-10T06:36:00Z
author avatar
Top 10Real User

I work for a company that are Snowflake partners and help clients implement solutions using Snowflake.

2020-11-09T14:15:42Z
author avatar
Top 10Real User

We have different data models established on Snowflake so our primary use case is to store data from different sources, such as Azure Data Factory, or Databricks. We use it to create the data coming from different sources, and then we store the data. In addition, we also have a reporting structure that we use. We are partners with Snowflake and I'm a lead data engineer.

2020-10-29T13:02:21Z
author avatar
Top 20Real User

We use Snowflake for data warehousing.

2020-10-07T07:04:36Z
author avatar
Top 5Real User

Snowflake is used for very large data, such as in the case where tables might contain 600 to 700 million records.

2020-10-06T06:57:48Z
author avatar
Top 10MSP

We work with multiple customers who were asking for this and other similar solutions. We've since had several team members certified in Snowflake and we have a certified team working with that solution and keeping up to date with developments. I'm the general manager of the company and we are implementers.

2020-10-04T06:40:21Z
author avatar
Top 20Real User

I work as a data scientist and our primary use of Snowflake is for machine learning. Recently, we were trying to extract data to determine the best configuration settings for one of our products.

2020-08-06T06:44:48Z
author avatar
Top 5Real User

We primarily use the solution in order to have the daily transactions of trades. It's to manipulate and find out the benchmark of every broker and institutional manager.

2020-07-26T08:19:11Z
author avatar
Top 20Consultant

We use the solution for data. We like that there are so many different formats and many structures for analysis.

2020-06-15T07:33:54Z
author avatar
Top 5Real User

The primary use case is big data warehouses.

2020-04-19T07:03:00Z
author avatar
Top 20Real User

We are a big data company. We have many thousands of devices deployed from our customer base. These devices upload data, on an hourly basis, to a central storage. Next, we run some ETF processes that crunch and process data, then we store that data in a structured way on Snowflake. Over the past six months, it has been more of a development project. I am using the latest version.

2020-01-15T08:03:00Z
author avatar
Top 20Real User

The primary use case for Snowflake is in our data warehouse project. We have a private DW and whoever has the credentials can access it. I am a data integration developer and we are using ETL tools to extract the data from different source systems and then load it in the data warehouse.

2020-01-09T06:15:00Z
author avatar
Top 10Real User

We use this product basically for developing an IoT (Internet of Things). Currently, we are sending data from our S3 (Simple Storage Service) storage. In the future, we are planning to directly stream data to Snowflake.

2019-12-30T06:00:00Z
author avatar
Top 5Real User

We needed a data warehouse and we made a decision on what is the right tool for us as a data warehousing tool by comparing products. We looked into Microsoft Azure, Red Shift and Snowflake. In the end, we decided on Snowflake because it looks more up to date, it seemed much better purposed as a data cloud solution. It was developed from scratch and dedicated to being used on the cloud and that was what we were looking for. It was not just an on-premises system which was then converted to use on the cloud. It was completely developed from scratch and purely focus on the cloud. Because it was programmed with that dedication, it has some significant advantages.

2019-12-12T07:48:00Z
author avatar
Top 10Real User

We primarily use the solution for data warehousing.

2019-10-21T17:16:00Z
author avatar
Top 20Consultant

We are an IT Analytic Consulting company and we work with many different products. We have Snowflake and a Snowflake account mainly for education purposes and our internal training. We connected it to different sources, mainly internal sources. Most of them are on-premises and some are on the cloud. The deployment model is public.

2019-10-06T16:38:00Z
author avatar
Real User

Our aim was to migrate everything from on-premise, so we just migrated as it is and then we had issues. Some use cases that were running on-premises were not installed. We just went through each case and then finalized the issues with some of the packages that were not working or some users that were not getting what they were expecting. We did deep analysis on each and every case and then looked for options in Snowflake and are now working with the team to move everything over to Snowflake.

2019-07-29T10:11:00Z
author avatar
Top 5LeaderboardUser

We use Snowflake for our data warehouse. Amazing product. Redshift cannot compete with a true elastic data warehouse where you can scale computing by just issuing a SQL query (increase computer power) and resizing it down or putting computing unit to sleep. Snowflake has many more features: When combined with Alooma, it's the best data integration system. No need for Talend and all these cumbersome tools.

2018-11-11T00:06:00Z
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
540,984 professionals have used our research since 2012.