Snowflake Primary Use Case
SR
SreenivasanRamanujam
Director -Data Architecture and Engineering at Decision Minds
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.
View full review »We have day-in and day-out data coming from our various heterogeneous source systems. We read from that and we load data into our target tables, or rather data lake and data warehouse that is built into Snowflake. We can even translate and delete items. Apart from that, we use the tasks and schedule jobs within Snowflake. Once the data is generated into the final data material, we share it with the client for their review.
Snowflake is our centralized data warehouse. We bring all of our business critical information to Snowflake. It also powers all of our dashboard's reporting and analytical models.
View full review »Buyer's Guide
Snowflake
March 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,246 professionals have used our research since 2012.
The use cases are data warehousing, data pipelining, data engineering, reporting, and dashboarding. Instead of using Oracle or other systems, you can simply put Snowflake there. It works like a normal database. This way, you avoid consuming the system with extra data. So the experience so far is good.
View full review »We are currently using this product for data lake and data warehouse projects. Snowflake creates our repositories and enables the view from other tools like Docker and Power BI to create that data mesh. We use the data to create a process inside the warehouse. We are customers of Snowflake and I'm the senior manager of information technology infrastructure.
View full review »TB
reviewer817386
director of business operations at a logistics company with 51-200 employees
We use it as a traditional data warehousing application that we then set all of our reporting tools on top of.
View full review »PG
reviewer2184489
BI Consultant at a tech consulting company with 201-500 employees
The solution is primarily used for data warehousing.
View full review »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.
View full review »Our primary use case for Snowflake is inputting data generated by AWS.
View full review »We use the solution as a data warehouse for our financial services firm.
OP
OvidiuPirvu
Cloud Data Engineer at Expo Design Center
The solution is very good for building data warehouses. However, it has some limitations if we need it for more use cases.
View full review »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.
View full review »HB
Hemant Balijepalli
Senior Consultant at a consultancy with 10,001+ employees
Basically, if at all, we wanted to have an interface for data warehouses on the cloud which worked on Azure or AWS. Snowflake, provides a more intuitive, rapid user interface where people can connect and maintain warehouses and share data among the people in the companies easily. Its pricing model and the model have made maintaining virtual warehouses simpler.
View full review »We use this solution to ingest e-commerce advertising and web analytics data and completing an analysis. There are 60 people using this solution in our business.
View full review »BH
reviewer1663572
Manager IT BRM/FRM at a manufacturing company with 10,001+ employees
We're ingesting third-party data analytics into a database held within Snowflake. We have pre-production and production environments with integration to staging and production schemas.
View full review »The primary use case is data platforms, specifically data warehousing. It involves restoring and moving data within the platform to prepare it for analysis, routing activities, or serving as the backbone for applications.
Snowflake also advertises different workstreams, but my customers mostly use it as their core platform to ingest data and serve the onward goals of the wider company.
View full review »KR
reviewer2126586
Senior Software Engineer at a consultancy with 10,001+ employees
Our current plan and use case for this solution is to migrate the data from on-premises to the cloud. We are currently using on-prem monitor data and providing it on the cloud. We are using Snowflake so that once the data is in there, we are trying to create shares over it so that external systems can't consume it.
View full review »DA
reviewer2087382
Vice President, Data Architecture and Management at a financial services firm with 10,001+ employees
We're using it more for data warehousing and distribution.
Snowflake is a SaaS platform, so I'm using whatever is the latest version.
YM
Yaniv Meir
BI & BIG DATA Director at Malam-Team
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.
View full review »MF
Martin Frederick Flippance
IT Consultant at Independent Consultant
I mostly build or design data warehouse analytics solutions using Snowflake.
View full review »RN
reviewer1429782
Consultant at a financial services firm with 1,001-5,000 employees
We are also using Apigee we have various consumption patterns, data enrichment, and few shedding of the data, and everything goes into Snowflake. If it is multiple consumers, it goes into AMQ, Kafka, or multiple streams to consume. There are specific APIs that we offer after we send the data into the S3 bucket. We have Apigee APIs for consumption, and there are three to four different patterns. For example, we enrich the data, flatten it, and structure everything before the customers going to go into Snowflake.
There are going to be specific clients who need specific data from the overall data lake, those are going to be exposed as APIs. We have multiple customers needing the same data and for this, we move them into the streaming Kafka.
Apigee does not communicate directly with Snowflake. We have data registration, and everything is coming into something that is called the trusted bucket. The Apigee interface API is written off the S3 bucket. The S3 bucket data is moved into the Delta Lake, and where the data are stored from the Delta Lake, it sends it to Snowflake. We have Apigee going to Delta Lake and S3 bucket, but Apigee does not go to Snowflake, these are two areas where it goes to.
We have Kafka consuming directly off Delta Lake, and it sends data to Kafka through the AMQ. We have its setup, and we have interfaces that come directly to Snowflake to pull the data. It is then flattened and enriched, and it is used for many purposes, such as reporting.
View full review »MA
Data Sleek
Owner at a consultancy with 1-10 employees
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.
View full review »The primary use case is for building a database and data link.
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.
View full review »DT
DeepikaThukral
Data Engineer at Natwest
We use the solution to build the pipelines in stream sets, including data source, data warehouse, and destination endpoints.
View full review »VP
reviewer1553778
Solution Architect at a wholesaler/distributor with 10,001+ employees
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.
NP
Nanda Parayil
DBA Individual Contributor at Aristeia Capital
Snowflake is used for very large data, such as in the case where tables might contain 600 to 700 million records.
View full review »We use Snowflake as a database to store all the data we stream from the source system.
View full review »AB
reviewer1701372
Architect at a tech vendor with 10,001+ employees
In our organization, data is often spread out over multiple on-premise and cloud-based platforms. Snowflake is an agnostic platform, meaning it can be used regardless of which cloud provider we use and can serve as a single source for all of our data. Our use case then is to ensure that all data is located in one place, utilizing Snowflake as the platform.
View full review »Snowflake is used for data warehousing.
View full review »We're using Snowflake for Power BI Cloud. We had a cloud version of Snowflake, so we were connecting to the Snowflake database and importing required tables into our system, Power BI Desktop. From there, we linked those tables and created a semantic layer, an internal layer between the frontend and backend, and then we tuned the data. Then we used both the tables to tie into the dashboards that we developed. The dashboards show the sales information or marketing information.
It's a cloud solution.
View full review »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.
View full review »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.
View full review »I use this solution to create a proof of concept. I also create training for companies on Snowflake.
View full review »We are silver or gold partners. The main use case is that we are building a data lake. We are creating a couple of downstream applications as well that will be used by data scientists. So, we will have a single data lake that will be used across the organization by different business domain users. The data is multi-source. We have data from SAP, JDE, and some Excel files.
View full review »My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources. The ultimate goal is to provide reporting and analytics to all departments in the company.
View full review »MM
MaheshMysore
Manager at SSM VIT Global Solutions
My current client is migrating from an on-premise data warehouse to the cloud, and they need to consolidate the data lake. I'm using Snowflake to develop the data lake and build data bots for certain functionalities. I've also used Snowflake to aggregate and clean data for my client's analytics.
I use it for data warehousing. I just design databases, put data in there, and get data out.
View full review »AS
reviewer2108010
Associate Data Engineer at a outsourcing company with 201-500 employees
We use the product as a data warehouse.
View full review »CD
reviewer1219965
Data Architect at a tech services company with 201-500 employees
I have been working on Redshift, Snowflake, and AWS RDS Oracle. In the particular case of RDS Oracle, they were migrating from on-prem Solaris equipment to cloud-based RDS.
I would suggest Snowflake for anyone with the need for a reporting/business analytics view of their data that wants only wishes to maintain technical FTE's around processing the data into or out of a data repository but, doesn't want to go to extent of technical management of "AWS clusters" for the data repository.
View full review »AN
reviewer1600227
Senior Data Engineer at a financial services firm with 10,001+ employees
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.
View full review »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.
View full review »I am using Snowflake for migrating data and table backups.
View full review »SM
reviewer1550751
CEO at a computer software company with 51-200 employees
We have a data mart, and we are using it to share data with big enterprise customers with major security requirements.
View full review »VK
Veerendra Karnam
General Manager at itcinfotech
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.
View full review »ST
Satya RamaTamminidi
Principal Director at a tech vendor with 10,001+ employees
We use the solution to migrate data from old legacy ERP systems into Snowflake which reduces our work by 70 percent.
View full review »NA
Nadine Anderson
Marketing Communications Manager at a financial services firm with 1,001-5,000 employees
We use the solution to support our data infrastructure.
View full review »I am using Snowflake for all our apps and data warehousing requirements.
View full review »EK
reviewer1601793
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
The solution is primarily used as a data warehouse.
View full review »CP
reviewer1498041
Founder & CIO at a computer software company with 11-50 employees
We primarily use the solution to build some cost-effective solutions for a data warehouse, mostly for all non-transactional data.
I am a solutions architect for Snowflake.
View full review »CR
Cristobal Rodriguez
Director Consultoria at tecnoscala consulting
We use Snowflake for data warehouse modeling and reports.
View full review »ES
reviewer1482624
AVP Enterprise Architecture at a financial services firm with 501-1,000 employees
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.
View full review »DR
DivyaRaj
Sr. Software Developer at Tech Mahindra Limited
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.
View full review »JH
reviewer739716
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
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.
VG
Valai Gunapalan
Architect at Sony Corporation of America
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.
View full review »PC
reviewer1500672
Sr. Solution Architect at a insurance company with 1,001-5,000 employees
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.
View full review »We primarily use the solution for the data warehouse.
View full review »YM
Yash Mittal
Lead Data Engineer at a consultancy with 51-200 employees
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.
JH
reviewer739716
Vice President of Business Intelligence and Data Engineering at a comms service provider with 201-500 employees
Snowflake is used in my organization for our data warehouse.
View full review »AK
reviewer1613421
Senior Snowflake Data Architect @ COOP Financials NC at a tech services company with 1,001-5,000 employees
We use the solution for a data warehouse and we generating reports and dashboards.
View full review »SS
Suresh Swaminathan
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
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.
View full review »RK
reviewer2124444
Solutions Architect at a recruiting/HR firm with 1-10 employees
We use Snowflake as a data warehouse and analytics platform. I'm a solution architect and we are customers of Snowflake.
View full review »NK
NitinKumar
Director of Enginnering at Sigmoid
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.
View full review »ST
reviewer1400643
Solutions Architect-AI & ML at a tech services company with 10,001+ employees
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.
View full review »TT
reviewer2179353
Soullution Architech at a tech services company with 51-200 employees
We use the solution for data storage and integration purposes.
View full review »RV
RAHULVERMASIR
Director - Data Analytics at Sunera Technologies
We are using it for a migration from on-prem to cloud.
View full review »KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees
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.
View full review »We use Snowflake as a data migration platform.
View full review »SM
Subhrajit Mitra
Sr. Technical Architect - Business Intelligence / Data Warehouse at a computer software company with 1,001-5,000 employees
We use this solution for business intelligence. We have three persons in the team for developing the end product.
View full review »DE
reviewer1113963
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees
We use Snowflake for data warehousing.
View full review »YR
reviewer1077408
R&D Operations Manager at a manufacturing company with 1,001-5,000 employees
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.
View full review »AS
Anoop Anoop SLK
Enterprise architect at a computer software company with 201-500 employees
We use the solution for data warehouses and data modeling.
View full review »MR
Mauricio Ruiz Falcón
Senior Information Management Architect at Raken
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.
View full review »MA
Murugan Asokan
Senior Solutions Architect at NessPRO Italy
We use it for presentations to clients.
View full review »YK
Yuval Klein
Pre-sale Leader, Big Data Enterprise Solutions at Ness Technologies
The primary use case is big data warehouses.
View full review »AH
reviewer1401216
CEO, Senior Consultant at a tech services company with 1-10 employees
The solution is mainly used for analytics in data warehouses. We are independent consultants and customers of Snowflake.
FG
reviewer1225515
Lead Data Analyst at a wholesaler/distributor with 1,001-5,000 employees
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.
View full review »VY
Vikas Yadav
Chief Data Architect - Europe at a computer software company with 10,001+ employees
We are using it as a data lake. We are using it as a data warehouse and a data mart. It is basically the entire BI and analytics platform.
I am using its latest version.
View full review »AB
reviewer1467771
Technology & Innovation at a consultancy with 201-500 employees
We are a management consulting firm and do not use this product for ourselves. Rather, it is a service for our clients.
View full review »WM
reviewer1364460
Principal Consultant at a tech services company with 51-200 employees
We use the solution for data. We like that there are so many different formats and many structures for analysis.
View full review »DK
reviewer1175826
Data & Analytics Practitioner at a tech services company with 1,001-5,000 employees
We primarily use the solution for data warehousing.
View full review »MH
reviewer1037319
Data & Analytics Practitioner (BIDW, Big Data) at a computer software company with 10,001+ employees
We are using the Matillion as the ETL tool and Snowflake has storage and there is no data warehouse component for storage.
View full review »TB
Tom Bruce
Co-founder & Delivery Lead at a tech services company with 1-10 employees
I work for a company that are Snowflake partners and help clients implement solutions using Snowflake.
OA
reviewer1292229
Big Data & Cloud Manager at a tech services company with 1,001-5,000 employees
We are using it for optimizing costs and using financial data.
View full review »MS
reviewer1572522
ML Lead at a tech services company with 201-500 employees
It was used in my previous company for a massive data warehouse. It was used for events and actions from other data sources. We had its latest version.
SS
reviewer1499625
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees
The solution provides services to our customers.
View full review »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.
View full review »Buyer's Guide
Snowflake
March 2024
Learn what your peers think about Snowflake. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,246 professionals have used our research since 2012.