What is most valuable?
The most valuable features to us are: speed, DML, the fact that it is cloud-based, the management console, and Boto3.
Because we are dealing with a lot of data, speed is always important. Redshift is blistering fast when doing "deep" copies and inserts. Conceptually, my data-transformation pipelines are a series of proprietary "waves" that leverage Redshift's DML/"deep" copy/insert strengths. Doing all this in the cloud allows us to easily test alternatives. We create different sized Redshift clusters and orchestrate them by using the SDK (Python Boto3). We go beyond the traditional DWH to "infrastructure-as-software".
How has it helped my organization?
Redshift has helped to transform Makerbot into a data-driven company.
What needs improvement?
Integrating database security/access rights with AWS IAM would be great. I would also like to see more DML features that might aid in processing unstructured or log-file data. This would allow us to avoid having to use EMR/Hadoop.
For how long have I used the solution?
We’ve used Amazon Redshift for 3 years.
What was my experience with deployment of the solution?
We did not encounter any deployment issues.
What do I think about the stability of the solution?
We did not encounter any issues with stability.
What do I think about the scalability of the solution?
We did not encounter any issues with scalability.
How are customer service and technical support?
I think the customer services is adequate. Technical Support
The level of technical support is good.
Which solution did I use previously and why did I switch?
We tried prior solutions, but they had limited or no scalability/agility.
How was the initial setup?
The initial setup was straightforward.
What was our ROI?
It took less than a year for the product to pay for itself.
What's my experience with pricing, setup cost, and licensing?
Regarding pricing and licensing, I advise to start small and have your developers/DBA use table compression and partitioning from the start.
Which other solutions did I evaluate?
We have used different options over the last 20 years. We found AWS Redshift to be the leader in capability and provides an ecosystem of related services from AWS, many of which are free.
What other advice do I have?
My advice to other is to prototype, prototype, prototype! Everything depends on your data and what you need to do to it. No two projects are the same.