Cloud Storage by Google is a data storage platform, which helps businesses of all sizes store data with multiple...
Software Advice offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links.
Learn more
About Amazon Redshift
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale.
Amazon Redshift pricing
Amazon Redshift does not have a free version and does not offer a free trial.
Starting Price:
Not provided by vendor
Free Version:
No
Free trial:
No
Alternatives to Amazon Redshift
Amazon Relational Database Service (RDS) is a cloud-based software that helps businesses leverage existing database...
Snowflake is a data cloud platform for technology professionals and businesses in various industries, including...
MySQL is a scalable database management system, which enables organizations to securely record, update and manage data...
Azure is a comprehensive computing platform, providing cloud infrastructure, products and services, developer tools,...
Featuring G-Suite and GCP, Google Cloud is a platform that provides a reliable and easy-to-use set of solutions that...
Amazon Redshift Reviews for UK Users
Feature rating
5 reviews of 14
View all reviews
Filippo
- Industry: Marketing & Advertising
- Company size: 51–200 Employees
- Used Weekly for 2+ years
-
Review Source
5
Reviewed on 12/10/2023
A must-have tool for data warehousing
Amazon Redshift helped us creating standard reports for advertising activities and proved to be a valuable data source for our visual dahsboards
Pros
Amazon Redshift allowed us to organize efficiently all our data, both for reporting and visualization purposes. You can use SQL syntax to query the tables and to extract all the info you need. It supports multiple datatypes with many data compression solutions to save disk space and money. The Amazon Redshift console (on the AWS dashboard) allows you to keep track of your db performances, from query execution time to disk space used, and displays also wise recommendation on how to manage properly your tables.
Cons
There is nothing I can complain about Amazon Redshift.
Verified Reviewer
- Industry: Logistics & Supply Chain
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
4
Reviewed on 11/04/2022
Reliable and easy to set up
Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business.
Pros
Redshift is a reliable cloud data warehouse that's easy to set up especially if your tech infra already runs on AWS.
Cons
Scaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it's still limited to just halving/doubling your current cluster. It's not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses.
Alternatives Considered
SnowflakeReasons for Choosing Amazon Redshift
Our datasets are getting larger and larger. We needed an OLAP database which was more appropriate for our reporting and analytics workloads.Reasons for Switching to Amazon Redshift
Redshift's pricing is straightforward and more predictable compared to other cloud data warehouses. Also, our existing tech infrastructure already runs on AWS so using Redshift gave us much better integration with our current tech stack.
Gordon
- Industry: Health, Wellness & Fitness
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
3
Reviewed on 25/03/2024
Amazon Redshift - Average product
In my Opinion AWS redshift is an average product, the syntax and methods you have to use if you are used to using SQL server you will find to be more long winded or searching for alternatives ways. Basic items like parameters in stored procedures after a lot more complex than required.
Pros
It is a good tool for combining multiple data sources into one place. It is not really useful to load data in a delta approach but to fully reload the data source.
Cons
Its ETL process always wants you to create objects as S3 objects which most of the time is fine but you then end up storing the data twice, once in the 3s and then again in Redshift unless you code to delete the S3 files after loading.
Verified Reviewer
- Industry: Telecommunications
- Company size: 5,001–10,000 Employees
- Used Daily for 1+ year
-
Review Source
4
Reviewed on 22/02/2023
Amazon Redshift - Perfect database to build enterprise data warehouses !
Overall the Redshift experience is great and it can be used build your data warehouses.
Pros
The Redshift provided various data connector to get data from different sources . The data distribution can be defined while creating a table , which helps the SQL query to minimize the i/o operations , which intern increases the speed of the reports .
Cons
The redshift data distribution in disk is difficult at times to decide when you are build large data warehouses . The rival product like snowflake make it easy for the users as all of the data distributions are being taken care internally.
Craig
- Industry: Marketing & Advertising
- Company size: 1,001–5,000 Employees
- Used Daily for 1+ year
-
Review Source
5
Reviewed on 30/05/2022
Solid, Reliable Option for Warehouse Storage
Redshift is the bedrock upon which our entire product lives. It stores the underlying data for our reporting, dashboards, etc.
Pros
Redshift is a great starting point for storing data if you're planning to build out a stack using other AWS products (EMR clusters, S3 for browsing, etc.). Redshift is reliable/dependable, we haven't faced uptime issues or anything like that. Easy to query against which is essential for us when pulling reports or performing QA. In previous work I've also been able to hook Redshift up directly to Tableau which has been huge in building ad-hoc reporting directly from our datastore.
Cons
Integrations aren't always as intuitive as with other tools, but this can be avoided with a solid internal knowledge base.
