smooth implementation and Quicker reports/dashboards
May 14, 2019

smooth implementation and Quicker reports/dashboards

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

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.
  • 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.
It is fast and simple to use. I use SQL, so for me it is even better to understand. My clients are happy, my boss is happy, I am happy.
[It's] very good for reports and dashboards and is easy to use and fast performance makes it a good choice. It excels in columnar architecture and aggregates. If you have many clients as we do, you need to have separate schemas for each of them. That is a good way but also there is too much clutter spread all over. That is the only drawback I see, end users can see data in the schema, there are no individual permissions allotted.