Snowflake Primary Use Case

SR
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 »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant

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.

View full review »
Erik Jones - PeerSpot reviewer
Head of BI and Analytics at HyperScience

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.
Sreenivasan Ramanujam - PeerSpot reviewer
Director -Data Architecture and Engineering at Restoration Hardware

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 »
Luis Miguel Goez - PeerSpot reviewer
Senior Manager Information Technology Infrastructure at SURA

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
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
BI Consultant at a tech consulting company with 201-500 employees

The solution is primarily used for data warehousing. 

View full review »
Rahul Saxena - PeerSpot reviewer
Manager - Business Technology Solutions at a consultancy with 1,001-5,000 employees

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 »
Ankit  Shukla - PeerSpot reviewer
Data Engineer at YASH Technologies

Our primary use case for Snowflake is inputting data generated by AWS.

View full review »
Anthony Fiorino - PeerSpot reviewer
SVP, Head of Enterprise Data Mgmt & Data Intelligence at a financial services firm with 5,001-10,000 employees

We use the solution as a data warehouse for our financial services firm. 

View full review »
OP
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 »
Azhagarasan Annadorai - PeerSpot reviewer
Founder at Unknown.University

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
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 »
Stephen Ebrey - PeerSpot reviewer
Data Consultant at Omaze

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
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 »
Chris Hastie - PeerSpot reviewer
Data Lead at InterWorks

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
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
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.

View full review »
YM
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
IT Consultant at Independent Consultant

I mostly build or design data warehouse analytics solutions using Snowflake.

View full review »
RN
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
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 »
VipinGupta - PeerSpot reviewer
Sr Manager at Publicis Sapient

The primary use case is for building a database and data link.

View full review »
Iqbal Hossain Raju - PeerSpot reviewer
Junior Software Engineer at a healthcare company with 10,001+ employees

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
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
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.

View full review »
NP
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 »
Sushrit Moundekar - PeerSpot reviewer
Program Manager at InfoCepts

We use Snowflake as a database to store all the data we stream from the source system.

View full review »
AB
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 »
Vinoth Raj Prabhakaran - PeerSpot reviewer
Senior Data Architect at Tata Consultancy Services

Snowflake is used for data warehousing.

View full review »
Hussain Modu - PeerSpot reviewer
Technical Lead at Wipro Limited

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 »
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

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 »
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a tech vendor with 10,001+ employees

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 »
Sanjay Bheemasenarao - PeerSpot reviewer
Director - Data Engineering expert at Sankir Technologies

I use this solution to create a proof of concept. I also create training for companies on Snowflake.

View full review »
Biraja Mishra - PeerSpot reviewer
Senior Principal Consultant at Genpact - Headstrong

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 »
Antonio Gouveia - PeerSpot reviewer
Business Intelligence Analyst at Clarivate Analytics

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
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.

View full review »
DominicMackenzie - PeerSpot reviewer
Senior data architect at a financial services firm with 51-200 employees

I use it for data warehousing. I just design databases, put data in there, and get data out.

View full review »
AS
Associate Data Engineer at a outsourcing company with 201-500 employees

We use the product as a data warehouse.

View full review »
CD
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
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 »
it_user1251369 - PeerSpot reviewer
Principal IT Technologist- BI Platform Architect at Medtronic

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 »
Sunny Kumar - PeerSpot reviewer
Specialist Programmer at Infosys

I am using Snowflake for migrating data and table backups.

View full review »
SM
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
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
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
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 »
Adnan Shafiq - PeerSpot reviewer
Associate Vice President - Database Management (Principal Solutions Architect) at Northbay

I am using Snowflake for all our apps and data warehousing requirements.

View full review »
EK
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
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.

View full review »
HarishAjjarapu - PeerSpot reviewer
Associate Director at a tech services company with 10,001+ employees

I am a solutions architect for Snowflake.

View full review »
CR
Director Consultoria at tecnoscala consulting

We use Snowflake for data warehouse modeling and reports.

View full review »
ES
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
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
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.

View full review »
VG
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
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 »
Varun Garg - PeerSpot reviewer
Senior Vice President at Polestar Solutions & Services India Pvt Ltd

We primarily use the solution for the data warehouse.

View full review »
YM
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. 

View full review »
JH
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
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
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
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
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
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
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
Director - Data Analytics at Sunera Technologies

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

View full review »
KG
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 »
Rahul-Sahay - PeerSpot reviewer
Senior Solutions Architect at kipi.bi

We use Snowflake as a data migration platform.

View full review »
SM
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
Data Architect and ETL Manager at a manufacturing company with 10,001+ employees

We use Snowflake for data warehousing.

View full review »
YR
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
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
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
Senior Solutions Architect at NessPRO Italy

We use it for presentations to clients. 

View full review »
YK
Pre-sale Leader, Big Data Enterprise Solutions at Ness Technologies

The primary use case is big data warehouses.

View full review »
AH
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. 

View full review »
FG
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
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
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
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
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
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
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.

View full review »
OA
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
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.

View full review »
SS
Enterprise BDM and Solutions Speacialist at a tech services company with 10,001+ employees

The solution provides services to our customers.

View full review »
it_user1174809 - PeerSpot reviewer
Business Intelligence Consultant at a tech services company with 201-500 employees

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.