2018-09-04T14:04:00Z

What is your primary use case for Amazon Redshift?

Miriam Tover - PeerSpot reviewer
  • 0
  • 52
PeerSpot user
30

30 Answers

Mikalai Surta - PeerSpot reviewer
MSP
Top 5
2024-02-22T08:57:40Z
Feb 22, 2024

We use the solution for data storage of reports.

Search for a product comparison
Tamás Srancsik - PeerSpot reviewer
Real User
Top 10
2023-09-07T14:30:00Z
Sep 7, 2023

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.

BR
Real User
Top 5
2023-07-27T20:51:51Z
Jul 27, 2023

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.

TT
Real User
Top 5Leaderboard
2023-05-09T07:52:00Z
May 9, 2023

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.

MP
Real User
Top 20
2023-05-04T09:21:00Z
May 4, 2023

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.

NJ
Real User
Top 20
2023-04-12T11:56:03Z
Apr 12, 2023

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

Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Ansari Rehman - PeerSpot reviewer
Real User
Top 5
2023-03-13T06:12:00Z
Mar 13, 2023

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

LourensWalters - PeerSpot reviewer
Real User
Top 10
2023-03-09T22:01:00Z
Mar 9, 2023

We mainly use the solution for marketing analytics.

Syed Zakaulla - PeerSpot reviewer
Integrator
Top 5Leaderboard
2023-02-13T20:14:00Z
Feb 13, 2023

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.

LS
Consultant
Top 20
2022-12-13T14:45:00Z
Dec 13, 2022

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.

HS
Consultant
Top 20
2022-11-15T15:16:39Z
Nov 15, 2022

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

Jayanta Datta - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-07-03T14:37:00Z
Jul 3, 2022

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

MandarGarge - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-06-07T18:13:19Z
Jun 7, 2022

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 Synapse, AWS 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.

Kundan Amin - PeerSpot reviewer
Real User
Top 10
2022-05-19T11:05:00Z
May 19, 2022

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.

AN
MSP
Top 20
2022-04-25T09:35:15Z
Apr 25, 2022

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

AA
MSP
2021-12-27T19:44:47Z
Dec 27, 2021

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.

AJ
Real User
2021-08-07T10:41:15Z
Aug 7, 2021

We are premium partners with Amazon.

RR
Real User
2021-07-02T07:10:42Z
Jul 2, 2021

Redshift is a managed service for data warehouses.

MJ
Real User
Top 5Leaderboard
2021-05-12T13:09:47Z
May 12, 2021

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

MS
Real User
2020-10-21T04:34:06Z
Oct 21, 2020

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.

TD
Real User
2020-07-19T08:15:38Z
Jul 19, 2020

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.

SN
Real User
2020-06-21T08:08:07Z
Jun 21, 2020

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.

MS
Real User
2020-06-17T10:55:59Z
Jun 17, 2020

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.

it_user1135503 - PeerSpot reviewer
Real User
2020-01-22T12:44:00Z
Jan 22, 2020

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.

it_user1256502 - PeerSpot reviewer
Real User
2020-01-12T07:22:00Z
Jan 12, 2020

My primary use for Amazon Redshift is for analytical purposes.

MiodragMilojevic - PeerSpot reviewer
Real User
Top 5
2019-11-27T05:42:00Z
Nov 27, 2019

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.

AD
Real User
2019-11-07T10:35:00Z
Nov 7, 2019

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

SV
Real User
2019-10-13T07:07:00Z
Oct 13, 2019

We primarily use the solution for analytics.

MS
Real User
2019-07-31T05:52:00Z
Jul 31, 2019

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

NW
Real User
2018-09-04T14:04:00Z
Sep 4, 2018

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.

What is Amazon Redshift? Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations. Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of...
Download Amazon Redshift ReportRead more