Start a data warehouse today with Redshift!
June 16, 2019
Start a data warehouse today with Redshift!
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Amazon Redshift
Redshift is being used by engineering for our data warehouse or data lake, if you will. It's part of our ETL pipeline, where the data is used to form dashboards and analytical queries across all of our initially segregated data. So it is kind of a source of truth linking data across the company. These dashboards are accessible across other departments in the organization. The data is consumed by everyone, not just engineers.
- It's fast for data analytics across multiple columns.
- Essentially, it's good for big datasets.
- By using RedShift you're kind of married to using AWS's other services, e.g. Redash.
- You need your data in the cloud.
- No separate storage and computing.
- No structured data types.
- Doesn't scale easily.
- Very positive for what it has done, providing a way to aggregate data sources.
- It allows marketing to pull statistics across the consumer base that would not have been otherwise possible.
- It allows actual analytics across the company, in an easily accessible manner.
We are currently on Redshift, because it was out before Snowflake. However, Snowflake looks promising. It's the new shiny toy that gives options that Redshift does not provide for. The big thing is that storage and compute can be scaled separately, whereas you cannot do that in Redshift. That's a big one. If you have enough data, it's worth it and should be cheaper.