Amazon Redshift Valuable Features
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 »
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 »
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 »
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 »
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 »
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 »
Amazon Redshift is very fast. It has really good response times. It's very user-friendly.View full review »
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 »
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 »
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 »
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 »
Manager at Protiviti
The most valuable feature is its scalability.View full review »
Senior Solutions Architect at a retailer with 10,001+ employees
This service can merge and integrate well with all databases.View full review »
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 »