Red Shifting

Posted : admin On 1/29/2022

Astronomers see red-shift in virtually all galaxies. It is a result of the space between the Earth and the galaxies expanding. This expansion stretches out the light waves during their journey to. 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.

Analyze all of your data with the fastest and most widely used cloud data warehouse

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.'

VP of Data Analytics, Equinox Fitness


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 »

Experience the next generation of Redshift with AQUA (Advanced Query Accelerator)

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.

Learn more about AQUA »

Join tens of thousands of Amazon Redshift customers

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.'

Director Business Partner, Pfizer Inc.

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

Press Release

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.

Press Release re:Invent session

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.

Learn more »

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.

Red Shifting Stars

Euclid uses Redshift for analytics.

Learn more »

Data as a service

Share data inside and outside your organization for secure and governed collaboration on live data with Redshift data sharing.

Learn more »

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).

Learn more »

Red Shifting Wavelength


What Does Redshift Mean

What's New