Amazon Redshift Primary Use Case

LS
IoT Consultant at a computer software company with 1,001-5,000 employees

We use Redshift as a central data warehouse. This data can be consumed directly by AWS services or different applications where we can provision the data via Athena. If we want to create more business intelligence tools and analysis, we write some SageMaker notebooks for deploying machine learning models based on the data.

We have a wide variety of use cases, but we generally use it to have one place where we can store data. We also connect enterprise legacy systems such as SAP systems. I'm mostly connecting shop floor assets and the industrial machinery to store relevant data in one place and make it available. Via Athena, combined data can then be retrieved with easy SQL queries.

Usually, we use the newest version of the solution. If there are new updates available, we try to take them directly.

Our customers usually have a hybrid cloud or full cloud architecture with minimum on-premises data centers.

We have five to ten customer projects per year in our department in which we set up data lake houses using Redshift. Those companies have between 3,000 and 15,000 people. Not everybody has to use Redshift. Depending on the project and the size of the consulted company, there are 2,000 to 3,000 end users who need access to the stored data.

View full review »
BR
Senior Director Data Architecture at Managed Markets Insight & Technology, LLC

There are many use cases, as I've worked with Amazon Redshift at different companies. Initially, we used it as part of the AWS suite, which made it easy to get started. We were able to move data from MySQL and PostgreSQL into Amazon Redshift, and we even used it in a production environment. However, the scalability of Amazon Redshift was not enough for our needs, so we switched to Snowflake.

View full review »
Beverly R. Jamison - PeerSpot reviewer
IT Solutions Architect / Computer Scientist at Practical Semantics

I have used DBeaver to connect to SAP Amazon Redshift and my main use case is for SQL. I map data from a graph database into SQL.

View full review »
Buyer's Guide
Amazon Redshift
March 2024
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Tamás Srancsik - PeerSpot reviewer
Data Analyst Lead at Vectornator

Redshift is an AWS warehouse solution. We have structured datasets, and we don't load all the amplitude data into Redshift. We first do this via Hudl, a data integration solution partner, but then later, it's directly loaded by an interaction. Then we run DBT against Redshift. We have our data models in DBT, and we run data analytics threats against the data warehouse.

View full review »
MiodragMilojevic - PeerSpot reviewer
Senior Data Archirect at Telenor

I'm the head of Data Warehouse and Business Intelligence, and our company is an Amazon customer. Most of the company's data sources were on Amazon at the time the product was deployed so it was logical to use this database. The data warehouse is quite small, compressed it's maybe 160 GB. It's not like an autonomous data warehouse or Exadata, which was almost 40 terabytes. It's a simple method of achieving extraction and loading. There is no real incremental load on this. Of course in the future, with the company growing, this should be changed and we'll probably need some kind of incremental system instead of this approach.

View full review »
NJ
Sr BI and Data Engineer at Datacult

We use it for data warehousing. Currently, I'm setting up a data link with Redshift to fetch data from our data lake.

View full review »
SP
Senior Economics Analyst at a manufacturing company with 51-200 employees

The solution is used to handle unstructured data.

View full review »
Ansari Rehman - PeerSpot reviewer
Cloud Data Architect (AWS-Snowflake-Teradata-Oracle) at a consultancy with 10,001+ employees

We use Redshift Spectrum for creating temp tables during the Ignition process.

View full review »
Jayanta Datta - PeerSpot reviewer
Executive Director at Morgan Stanley

It is storing warehouse data for the organization. We commission data warehousing, storage of data, and reporting.

View full review »
Coby Jefferson Gardner - PeerSpot reviewer
Data Consultant at Align BI

We use Amazon Redshift for our data warehouse to store a lot of our data for a client.

View full review »
TT
Soullution Architech at a tech services company with 51-200 employees

I have used it for our reporting solution requirement. We gathered data from different processes and applications, like the high system process. Clients can review the data; we use it for connections and reports. Additionally, Redshift generates some configuration files without using an application.

View full review »
Syed Zakaulla - PeerSpot reviewer
Project Manager at Softway

We were using the solution for our data backup, but we wanted to optimize it, so we turned to AWS Glue. Amazon Redshift wasn't really great for us and wasn't working out.

View full review »
Mikalai Surta - PeerSpot reviewer
Head of Big Data Department at IBA Group

We use the solution for data storage of reports.

View full review »
Martin Gregor - PeerSpot reviewer
DWH, BI & Big Data consultant / developer /modeler - independent contractor at Freelancer

I use Amazon Redshift for the creation of SQL ETL procedures in a business system. Business people check this in a front-end application, and it helps them plan sales for the next year.

Redshift is being deployed on a Microsoft Azure server.

There are about six people working on this project and using the solution, but there are many similar projects running on Oracle and Redshift.

View full review »
MS
Service Manager & Solution Architect at a logistics company with 10,001+ employees

We stored all of the data in the S3 bucket and would like to have it stored in a data warehouse, which is why we chose this database. 

It would be very easy for us as an end-user, who would like to access the data, rather than draw it post-transformation and store it at a database level.

View full review »
MandarGarge - PeerSpot reviewer
V.P. Digital Transformation at e-Zest Solutions

If you want to create an enterprise data hub, that is where Redshift is used. Snowflake, Redshift, BigQuery, and Azure Synapse are enterprise data warehousing and cloud data technologies. Large enterprises have enterprise data. They have a lot of managed processes, business processes, customers, products, different assets, locations, equipment, etc. Then they have sales and marketing. There's a huge amount of data that is generated, and they will need a large warehouse or multiple data warehouses to create analytics out of that data.

We try to tell organizations to consolidate all their data into a single unified data platform that has all the enterprise data rather than being processed by multiple warehouses. It's processed on one central data platform, which is cloud-based. In which case, we recommend one of these four. We either recommend Snowflake, Azure SynapseAWS Redshift, or Google BigQuery. It depends on what their early investment is and what kind of work they need to do.

Redshift is completely Managed on AWS cloud.

View full review »
AR
VP, Data and Insights at a tech company with 201-500 employees

We use this solution for production and customer data for one of the lines of the business, which is basically one of the warehouses. I oversee the whole architecture infrastructure.

View full review »
LourensWalters - PeerSpot reviewer
Senior Data Scientist at a tech services company with 51-200 employees

We mainly use the solution for marketing analytics.

View full review »
Kundan Amin - PeerSpot reviewer
Senior Consultant at Dynamic Elements AS

We use Microsoft Azure, but one of our clients is on AWS, so we did a POC for Amazon Redshift. Now, it's up to them to make the call on whether to continue with the solution based on pricing and their needs.

View full review »
RR
Data Engineer at a tech services company with 51-200 employees

Redshift is a managed service for data warehouses.

View full review »
PS
Business Analyst at Insphere Solutiona

We use Amazon Redshift as our data warehouse.

View full review »
HS
Consultant at ANWB

I'm a freelancer/consultant, so I use the solution across a wide variety of contexts. 

View full review »
AJ
Senior Solutions Architect at a retailer with 10,001+ employees

We are premium partners with Amazon. 

View full review »
AG
Engineering Manager/Solution architect at a computer software company with 201-500 employees

We use this solution for our enterprise data warehouse.

We use it for scaling our warehouse.

We also use it for analytics.

View full review »
AA
Financial Performance Manager at a retailer with 1,001-5,000 employees

Our data warehouse is Redshift now.

View full review »
MJ
Solutions Architect at a computer software company with 1,001-5,000 employees

Our primary use case of this product is as a data warehouse. We are partners with Amazon. 

View full review »
AA
Data Analyst at a tech vendor with 51-200 employees

We are using the latest version of Amazon Redshift, although I cannot state which one. It is actually updated automatically, which prevents us from tracking it.

We use Amazon Redshift as our data warehouse solution. We use it for collecting and analyzing our data. We store our data for analytics in the solution.

View full review »
MS
CEO at Screenit Labs Pvt Ltd

We are a solution provider and Amazon Redshift is one of the products that we implement for our clients. We are working with a few customers that have it implemented right now.

View full review »
MP
Data Scientist at a tech vendor with 51-200 employees

We use Amazon Redshift to store customer data. Basically, it's just to store our customer data so that we can use our own data.

View full review »
AN
Manager at Protiviti

We primarily use Amazon Redshift for prediction modeling and business reporting.

View full review »
TD
Cloud & Data - practice leader at Micropole Belgium

We are a service provider and we currently have five clients with active IT implementations that use Amazon Redshift. We also use it ourselves.

My clients primarily use this product for data analytics. They are mostly working with big data and using the machine learning functionality.

View full review »
MS
Chief Information Officer at Sensilab

We are using the private cloud model of this solution. Our primary use case is for a data warehouse for BI.

View full review »
SN
Chief Executive Officer at Ampcome

We are a digital transformation services company, and we are using Amazon Redshift for one of our clients. They are a logistics company that has transportation and other needs.

Their first requirement is for financial reporting, where we pull financial data from their many ERP systems and can provide a corporate-level view.

There is also an operations standpoint, where they are looking for operational insights. For this, we again pull different information from their ERPs, bring it into Redshift, and then model it in such a way that they will be able to see a consolidated view in terms of operational success across lines of business.

View full review »
AJ
Consultant at a tech services company with 51-200 employees

We are using Amazon Redshift services to query the data and to perform certain data science operations on that data, such as applying a machine learning algorithm or doing an analysis.

View full review »
it_user1256502 - PeerSpot reviewer
Senior System Engineer at a computer software company with 10,001+ employees

My primary use for Amazon Redshift is for analytical purposes.

View full review »
it_user869871 - PeerSpot reviewer
Principal Consultant at Inawisdom
  • Storing and querying data in near real time.
  • Loading millions of raw CSV records.
  • Running data comparisons and queries, then shutting it all down all within a few hours, once a week.
View full review »
it_user1135503 - PeerSpot reviewer
Business Analyst at a tech services company with 201-500 employees

We use Amazon S3 along with RedShift for storing our data. The data comes from various sources, including our client and third-parties. We get the data as an S3 file and then load it into RedShift using the ETL tools. RedShift will then act as the data source for Tableau, which is used for forecasting and other marketing activities.

View full review »
NW
BI Manager at jfrog

We use it to build a data warehouse and a centralized location for all of our data sources, allowing for in-depth analysis by using SQL queries.

View full review »
AD
Senior Software Engineer at a tech services company with 51-200 employees

The primary use case for this solution is related to statistical data.

View full review »
SV
Head of Analytics at a tech services company with 10,001+ employees

We primarily use the solution for analytics.

View full review »
Buyer's Guide
Amazon Redshift
March 2024
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.