Last updated on
Company health
Ratings
Amazon Redshift description
Amazon Redshift is a cloud-based data warehouse service designed to help businesses analyze large volumes of data. It offers a cost-effective solution for storing and querying data, with the ability to handle petabytes of information. Redshift integrates with existing business intelligence tools, allowing for seamless data analysis. Its speed and scalability make it suitable for companies of all sizes looking to gain insights from their data.
Who is Amazon Redshift best for
Amazon Redshift is a fast and scalable cloud data warehouse perfect for businesses needing in-depth data analysis. Users praise its ease of use and integration with AWS, but some find it pricey for smaller datasets. It’s ideal for medium to large companies in data-heavy industries like finance and retail.
-
Ideal for medium to large businesses.
-
Best fit for Finance, Software, Retail, and Manufacturing.
Amazon Redshift features
| Supported Redshift uses columnar storage, optimized for analytical queries. |
| Supported Redshift supports storage tiers based on access frequency using managed storage, which combines SSD and S3. |
| Supported Amazon Redshift supports SQL queries, including various client tools and SQL constructs. |
| Supported Amazon Redshift is a fully managed, cloud-based data warehousing service for large datasets. |
| Supported Redshift supports high-volume scaling with features like concurrency scaling and elastic resize. |
| Supported Redshift supports data partitioning using sort keys, distribution styles, and Redshift Spectrum. |
| Supported Amazon Redshift integrates with various business intelligence tools for data analysis and reporting. |
We evaluate the sentiment that users express about non-functional aspects of the software
Value and Pricing Transparency
Ease of Use
Reliability and Performance
Ease of Implementation
Scalability
Amazon Redshift reviews
We've summarised 407 Amazon Redshift reviews (Amazon Redshift Capterra reviews and Amazon Redshift G2 reviews) and summarised the main points below.
- Easy to use and setup
- Fast query performance
- Integrates well with other AWS services
- Cost-effective for large datasets
- Scalable for growing data needs
- High cost for small datasets or infrequent use
- Limited SQL support compared to other databases
- Complex setup for beginners
- Slow data loading for certain data formats
- Occasional performance issues with concurrent queries
Amazon Redshift pricing
The commentary is based on 72 reviews from Amazon Redshift Capterra reviews and Amazon Redshift G2 reviews.
Amazon Redshift pricing is generally considered cost-effective and scalable, especially for large datasets and enterprise users. However, some small businesses find the pricing structure challenging and potentially expensive for their needs if their usage is low. Several users mention the pay-as-you-go model as a benefit.
Users sentiment
See the Amazon Redshift pricing page.
Amazon Redshift alternatives
ClickHouseOpen-source, column-oriented database management system. Has more momentum and better suited to large enterprises.Read more
SnowflakeBetter for small businesses. Has broader industry applicability, serving manufacturing, real estate & construction, hospitality & tourism, transportation & logistics, media & entertainment, legal, non-profit & government, energy & utilities, professional services, agriculture, and automotive, aerospace & defense sectors. Growing faster than Amazon Redshift.Read more
FireboltA better fit for companies prioritizing speed and efficiency for large datasets. An Amazon Redshift competitor and alternative, it offers a more modern architecture designed for high concurrency.Read more
LookerBetter for business intelligence and creating interactive dashboards. Easier to use, especially for non-technical users. Stronger integration with Google products. A good Looker alternative for those focused on data visualization and reporting.Read more
Google Cloud BigQueryBetter for education, marketing, government, and non-profit organizations. Serverless architecture simplifies infrastructure management. Offers built-in machine learning capabilities and real-time analytics. Seamless Google Cloud Platform integration. Higher rated by users as a Redshift alternative. However, it has higher and less predictable costs. Beginners may face a steeper learning curve.Read more
Microsoft SQL ServerBetter for companies needing on-premise or hybrid deployments. Wider industry applicability including Manufacturing, Government, and Automotive. Stronger support for traditional SQL and T-SQL. Has less momentum based on employee growth.Read more
Amazon Redshift FAQ
What is Amazon Redshift and what does Amazon Redshift do?
Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse service. It enables businesses to analyze large datasets cost-effectively using standard SQL and business intelligence tools. Redshift's scalability and speed make it ideal for data-driven insights.
How does Amazon Redshift integrate with other tools?
Amazon Redshift seamlessly integrates with various business intelligence (BI) tools for comprehensive data analysis and reporting. It also integrates with other AWS services, enabling efficient data workflows. This interoperability empowers users to leverage existing tools and infrastructure.
What the main competitors of Amazon Redshift?
Top Amazon Redshift competitors include Snowflake, a flexible cloud data platform, Microsoft SQL Server, a versatile database system, and Firebolt, known for its speed in analyzing large datasets. Other alternatives include Tableau, Explo, and Teradata Vantage.
Is Amazon Redshift legit?
Yes, Amazon Redshift is a legitimate and widely used cloud data warehouse service. It's known for its fast query performance, scalability, and integration with other AWS services, making it a safe and reliable choice for data warehousing needs.
How much does Amazon Redshift cost?
Amazon Redshift pricing depends on the chosen plan. There is on-demand pricing, as well as various options for reserved instances and managed storage. Contact AWS sales for detailed pricing information.
Is Amazon Redshift customer service good?
Customer reviews on Amazon Redshift's support are mixed. Some praise the "exceptional support" and helpful team available 24/7, while others express frustration with the lack of free tech support and desire more documentation. Several users highlight the platform's ease of use and readily available online resources.
Reviewed by
Michal has worked at startups for many years and writes about topics relating to software selection and IT management. As a former consultant for Bain, a business advisory company, he also knows how to understand needs of any business and find solutions to its problems.
Tymon is a seasoned CTO who loves finding the perfect tools for any task. He recently headed up the tech department at Batmaid, a well-known Swiss company, where he managed about 60 software purchases, including CX, HR, Payroll, Marketing automation and various developer tools.