|Initial release||October 2012|
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, red being an allusion to Oracle, whose corporate color is red and is informally referred to as "Big Red." 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.
Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version. An initial preview beta was released in November 2012 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. 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. In 2018, Redshift was outperformed by Microsoft Azure in a benchmark test run by Gigaom..
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 (company), 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.
- "Amazon Named Its Database Redshift For A Reason". awsforbusiness.com.
- "Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com.
- "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved July 8, 2013.
- "Improve data processing performance on AWS Redshift by 200%". Ardentisys.com.
- "Redshift and PostgreSQL". AWS. Amazon.
- "Unsupported PostgreSQL features". AWS. Amazon.
- "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved July 8, 2013.
- Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk..
- McKnight, William (July 12, 2018). "Data Warehouse in the Cloud Benchmark". gigaom.com. Retrieved May 23, 2019.
- "Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
- "APN - Amazon Redshift Partners - Pentaho". AWS. Amazon.
Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
- "Amazon Web Services". Pentaho.com.
then transformed, refined, and immediately pushed into Amazon Redshift.