IT Central Station is now PeerSpot: Here's why

Amazon Redshift Valuable Features

Thomas Dallemagne - PeerSpot reviewer
Cloud & Data - practice leader at Micropole Belgium

I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing. There are only three parameters that you need to understand, which are the distribution key, the sort key, and the compression method or encoding method. Once you understand these, you can tune the performance.

View full review »
MadhavanSrinivasan - PeerSpot reviewer
CEO at Screenit Labs Pvt Ltd

The feature that we find most useful is the ability to do analytics on the fly. It's the most important because it gives us the ability to provide solutions to multiple customers.

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

Overall, I'm satisfied with the solution so far, and, from an accounting perspective, it works well for my tasks and duties. 

The product is very stable. 

Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers. 

View full review »
Buyer's Guide
Amazon Redshift
July 2022
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
610,812 professionals have used our research since 2012.
AG
Engineering Manager/Solution architect at a computer software company with 201-500 employees

A feature I find most valuable in Amazon Redshift is that it's fast.

I also like that you can query the data lake using the Redshift spectrum.

You can build analytics on this solution, similar to QuickSight or Tableau, based on the Redshift Data API.

Amazon Redshift also has good integration and a good API. It's not hard to manage. It even has machine learning features.

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

We like that the solution is a scalable, column-store database. We are completely talking about an analytic database.

View full review »
Raghunandan Rajput - PeerSpot reviewer
Data Engineer at a tech services company with 51-200 employees

I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently.

View full review »
Eli Misael Manjarrez - PeerSpot reviewer
DBA at Kimetrics

Amazon Redshift is very fast. It has really good response times. It's very user-friendly.

View full review »
MJ
Senior Consultant at a tech services company with 1,001-5,000 employees

Amazon Redshift has a very user-friendly SQL editor and it's very easy to use the connectors. The product provides a lot of options to connect to different sources and the modeling capabilities are also good. As a fully managed data warehouse solution, the two important aspects are the connectors and how well we can use SQL for data modeling. In both cases, this is an efficient product.

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

Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there. 

View full review »
AishwaryaKumar - PeerSpot reviewer
Solution Architect at Capgemini

For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features.

They have enriched and elaborate documentation that is helpful.

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

The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast.

View full review »
AN
Manager at Protiviti

The most valuable feature is its scalability.

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

This service can merge and integrate well with all databases. 

View full review »
AmitKulkarni - PeerSpot reviewer
Consultant at kulki data management & consultants

Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features.

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