Overview
Product Information on Amazon Redshift
What is Amazon Redshift?
Amazon Redshift Pricing
Overall experience with Amazon Redshift
“Redshift Facilitates Scalable Analytics but SQL Similarities Cause Query Challenges”
“RBAC Limitations Impact Effectiveness of Late Binding and Consumption Views”
About Company
Company Description
Amazon Web Services (AWS), established in 2006, is focused on providing essential infrastructure services to businesses globally in the form of cloud computing. The key advantage offered through cloud computing, particularly via AWS, is its capacity to shift fixed infrastructure expenses into flexible costs. Businesses have been able to forgo extensive planning and procurement of servers and other Information Technology (IT) resources, owing to AWS. AWS seeks to provide businesses with prompt and cost-effective access to resources using Amazon's expertise and economies of scale, as and when their business requires. Currently, AWS offers a robust, scalable, economic infrastructure platform on the cloud powering an extensive array of businesses worldwide. It operates across numerous industries with data center locations in various parts of the globe including U.S., Europe, Singapore, and Japan.
Company Details
Do You Manage Peer Insights at Amazon Web Services (AWS)?
Access Vendor Portal to update and manage your profile.
Key Insights
A Snapshot of What Matters - Based on Validated User Reviews
User Sentiment About Amazon Redshift
Reviewer Insights for: Amazon Redshift
Deciding Factors: Amazon Redshift Vs. Market Average
Performance of Amazon Redshift Across Market Features
Amazon Redshift Likes & Dislikes
Scalability as it has been able to scale with our busy period when we see increased traffic. Easy of use, the query language is a modified SQL which means our analysts can use it without too much bother. Documentation, the platform has plenty of robust documentation and a active user community.
ease of connection
1. Excellent query performance and scalability 2. Easy integration within the AWS ecosystem 3. Minimal maintenance thanks to managed infrastructure
The only real issue I have is that the SQL dialect it uses is too close to others, meaning I trip up frequently when writing queries and I usually have to write them twice.
rbac across late binding views adding sort keys to large existing tables recreating large tables to update dist keys
1. Query optimization can be complex for new users 2. Real-time analytics isn't as strong as batch processing 3. Managing costs during high query loads requires careful planning
Top Amazon Redshift Alternatives
Peer Discussions
Amazon Redshift Reviews and Ratings
- DATA ANALYST1B-10B USDManufacturingReview Source
Redshift Facilitates Scalable Analytics but SQL Similarities Cause Query Challenges
Redshift has been a great tool for the storage and serving of our Google Analytics data. It has allowed us to capture a lot of information as we see a lot of traffic and then send it down stream for further processing. - PRODUCT MANAGER<50M USDIT ServicesReview Source
Amazon Redshift Offers Reliable Analytics Performance Yet Faces Cost Management Challenges
Amazon Redshift delivers strong performance and reliability for large scale analytics. It integrates smoothly with other AWS tools like S3 and QuickSight, making data workflow efficient. Scaling is efortless, and performance tuning are powerful. The only minor challange is managing costs for unpredictable workloads. - Engineer10B+ USDTravel and HospitalityReview Source
RBAC Limitations Impact Effectiveness of Late Binding and Consumption Views
query vs loading creates issues and requires consumption views which do not work nicely with RBAC - VP1B-10B USDMediaReview Source
Flexible Storage Options and Cost Based on Actual Usage Highlighted
fast speed and reliability. zero down service. distribution - IT ASSOCIATE<50M USDBankingReview Source
Efficient Analytics and Scalability Meet Higher Costs and Performance Tuning Needs
Reliable, fast for analytics, and easy to scale, but can be costly and requires tuning for best performance.