1. Home
  2. Cloud Data Warehouse Software
  3. Amazon Redshift Reviews
  4. User Review of Amazon Redshift
Powerful Data Management Tool
November 09, 2021

Powerful Data Management Tool

Sameera Srivastava | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Amazon Redshift

Amazon Redshift is primarily used as a data management solution by Product Analytics Group. We currently have various sources of capturing data like Heap, Delighted, Salesforce and it is convenient to build an ETL from these sources to Redshift. This enables us to merge all these data sources into single view in a BI tool like Power BI
  • Ease of setting up ETL
  • Uploading data into Redshift via AWS
  • Querying is quick
  • Missing option to restrict duplicate records
  • Lacks complex data sets like udf
  • Does not offer UI based querying & visualisation option like Looker
  • Helped in achieving data consolidation that enables business to make data based decisions
  • Saved engineering cost with easy to set ETL processes
I am really amazed by the level of documentation done by AWS on most frequent topics. Rarely do I have to look up for an answer elsewhere. Also they offer 24X7 business support which is quick and easy to get.

Do you think Amazon Redshift delivers good value for the price?

Yes

Are you happy with Amazon Redshift's feature set?

Yes

Did Amazon Redshift live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Amazon Redshift go as expected?

Yes

Would you buy Amazon Redshift again?

Yes

It's a good tool with easy to write SQL with almost all features available.
Offers fastest database on cloud with low maintenance cost.
Loading of data in parallel via AWS is quite convenient.
Redshift is relatively cheaper tool but since the pricing is dynamic, there is always a risk of exceeding the cost. Since most of our team is using it as self serve and there is no continuous tracking by a dedicated team, it really needs time & effort on analyst's side to know how much it is going to cost.
It is well suited in scenarios where you have distributed data sources and would like to build an ETL pipeline with limited data engineering efforts. Operations time and cost is relatively low compared to other tools. Also it offers great connectivity with Heap with no technical know-how required. It is mostly self managed and reliable.