smooth implementation and Quicker reports/dashboards
May 14, 2019
smooth implementation and Quicker reports/dashboards
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Amazon Redshift
We use it as our data warehouse for reporting purposes.
My company used it solely for reducing the performance overhead of running long SQL queries. The seamless implementation of Redshift allowed us to get the data ready to go for our customers to run the reports they need. It is currently used by a few customers, but we are trying to get each of our customers to use this rather than using the traditional OLTP database.
My company used it solely for reducing the performance overhead of running long SQL queries. The seamless implementation of Redshift allowed us to get the data ready to go for our customers to run the reports they need. It is currently used by a few customers, but we are trying to get each of our customers to use this rather than using the traditional OLTP database.
- Easy to work with
- Seamless implementation with matillion
- Massive data reads and inserts
- I didn't like the security aspect of this where it asks us to create views for each customer.
- It does not support row-level controls.
- Some SQL queries are faster on native SQL than here. But it could be the data conversions that is causing it.
- A client was unhappy and complained about slowness. Once we explained and showed them the new tool, they became very happy and stayed.
- A faster and easy approach to OLAP Schema allowed us to think out of the box.