Amazon Redshift
Analyze all of your data
No other data warehouse makes it as easy to gain new insights from all your data. With Redshift, you can query and combine exabytes of structured and semi-structured data across your data warehouse, operational database, and data lake using standard SQL. Redshift lets you easily save the results of your queries back to your S3 data lake using open formats, like Apache Parquet, so that you can do additional analytics from other analytics services like Amazon EMR, Amazon Athena, and Amazon SageMaker.
Learn more about taking the lake house approach by integrating with your Amazon S3 data lake »
"By leveraging Redshift's ability to query data directly in our Amazon S3 data lake, we have been able to easily integrate new data sources in hours, not days or weeks. This has not only reduced our time to insight, but helped us control our infrastructure costs."
UP TO 3X
BETTER PRICE PERFORMANCE
Amazon Redshift has up to 3x better price-performance than other enterprise cloud data warehouses, and the price-performance advantage improves as your data warehouse grows from gigabytes to exabytes.
Amazon Redshift’s architecture has been completely reinvented to take advantage of AWS designed-hardware and machine learning (ML) to deliver the best price performance at any scale. This includes using the AWS Nitro System to accelerate data compression and encryption, ML techniques to analyze queries, and graph optimization algorithms to automatically organize and store data for faster query results.
Learn more about the latest performance benchmarks »
AQUA is a new distributed and hardware accelerated cache that allows Redshift queries to run up to 10x faster than other enterprise cloud data warehouses by automatically boosting certain operations. AQUA accelerates scan, filtering, and aggregation operations today, and will accelerate more operations in the future.
Redshift powers analytical workloads for Fortune 500 companies, startups, and everything in between.
"Because of the performance and scale Redshift provides, we have increased our manufacturing efficiency and reduced the time needed to gather and prepare data for regulatory submissions by a factor of five."
Migrate your on-premises data warehouse to Amazon Redshift
Learn more about modernizing your data warehouse.
Jack in the Box migrated off of Oracle and Microsoft SQL Server to Amazon Relational Database Service (RDS) and Amazon Redshift
Equinox Fitness migrated its on-premises data warehouse to Amazon Redshift.
21st Century Fox migrated its IBM Netezza on-premises data warehouse to Amazon Redshift.
Use cases
Business intelligence
Redshift makes it simple and cost effective to run high performance queries on petabytes of semi-structured and structured data so that you can build powerful reports and dashboards using QuickSight or other business intelligence tools.
Intuit uses Redshift for business intelligence.
Operational analytics on events
Bring together structured data from your data warehouse and semi-structured data such as application logs from your S3 data lake to get real-time operational insights on your applications and systems.
Euclid uses Redshift for analytics.
Data as a service
Share data inside and outside your organization for secure and governed collaboration on live data with Redshift data sharing.
Predictive analytics
Use SQL to automatically create, train, and deploy Amazon SageMaker models on the data in your data warehouse with Redshift Machine Learning (preview).
