Amazon Redshift

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
Amazon Redshift
Initial releaseOctober 2012; 7 years ago (2012-10)
Operating systemCross-platform
Available inEnglish

Amazon Redshift is an Internet hosting service and data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. The name means to shift away from Oracle[1], red being an allusion to Oracle, whose corporate color is red and is informally referred to as "Big Red."[2] It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),[3] to handle large scale data sets and database migrations.[4] 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.

Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[5][6] An initial preview beta was released in November 2012[7] and a full release was made available on February 15, 2013. The service can handle connections from most other applications using ODBC and JDBC connections.[8] According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift has the largest Cloud data warehouse deployments, with more than 6,500 deployments.[citation needed] In 2018, Redshift was outperformed by Microsoft Azure in a benchmark test run by Gigaom.[9].

Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,[10] including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker (company), MicroStrategy, Pentaho,[11][12] 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.

See also[edit]


  1. ^ "Amazon Named Its Database Redshift For A Reason".
  2. ^ "Bye-bye, Big Red? Escaping Oracle's not that easy".
  3. ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved July 8, 2013.
  4. ^ "Improve data processing performance on AWS Redshift by 200%".
  5. ^ "Redshift and PostgreSQL". AWS. Amazon.
  6. ^ "Unsupported PostgreSQL features". AWS. Amazon.
  7. ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved July 8, 2013.
  8. ^ Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service".
  9. ^ McKnight, William (July 12, 2018). "Data Warehouse in the Cloud Benchmark". Retrieved May 23, 2019.
  10. ^ "Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
  11. ^ "APN - Amazon Redshift Partners - Pentaho". AWS. Amazon. Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
  12. ^ "Amazon Web Services". then transformed, refined, and immediately pushed into Amazon Redshift.