Amazon Redshift
Cloud-based data warehouse service
title: "Amazon Redshift" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["amazon-web-services", "data-warehousing-products", "cloud-databases", "postgresql", "internet-properties-established-in-2012"] description: "Cloud-based data warehouse service" topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/Amazon_Redshift" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0
::summary Cloud-based data warehouse service ::
::data[format=table title="Infobox software"]
| Field | Value |
|---|---|
| logo | Amazon-Redshift-Logo.svg |
| logo_size | 100px |
| name | Amazon Redshift |
| developer | Amazon.com |
| released | |
| operating system | Cross-platform |
| language | English |
| genre | wave |
| license | Proprietary |
| website | |
| :: |
| logo = Amazon-Redshift-Logo.svg | logo_size = 100px | name = Amazon Redshift | developer = Amazon.com | released = | operating system = Cross-platform | language = English | genre = wave | license = Proprietary | website =
Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian), to handle large scale data sets and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data sets stored by a column-oriented DBMS principle. Redshift allows up to 16 petabytes of data on a cluster. Redshift uses parallel processing and compression to decrease command execution time.
Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.{{cite web | work = AWS | url = http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html | title = Redshift and PostgreSQL | publisher = Amazon | access-date = July 26, 2015 | archive-date = November 15, 2019 | archive-url = https://web.archive.org/web/20191115085004/https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html | url-status = live
Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program, including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker, MicroStrategy, Pentaho, Qlik, SiSense, Tableau Software, and Yellowfin. Partner companies providing data integration tools include Informatica and SnapLogic. System integration and consulting partners include Accenture, Deloitte, Capgemini and DXC Technology.
The "Red" in Redshift's name alludes to Oracle, a competing computer technology company sometimes informally referred to as "Big Red" due to its red corporate color. Hence, customers choosing to move their databases from Oracle to Redshift would be "shifting" from "Red".
References
References
- (November 4, 2013). "Bye-bye, Big Red? Escaping Oracle's not that easy".
- "Amazon Redshift: ParAccel in, costly appliances out". ZDNet.
- "Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services".
- "System and architecture overview - Amazon Redshift".
- "Unsupported PostgreSQL features". Amazon.
- "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week.
- (2017-02-06). "AWS Partner Network". Amazon.
- "APN - Amazon Redshift Partners - Pentaho". Amazon.
- (January 2, 2018). "Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle".
::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::