Amazon Redshift

{{Short description|Cloud-based data warehouse service}}

{{other uses of|redshift|Redshift (disambiguation)}}

{{Infobox software

| logo = Amazon-Redshift-Logo.svg

| logo_size = 100px

| name = Amazon Redshift

| developer = Amazon.com

| released = {{Release date and age|2012|10}}

| operating system = Cross-platform

| language = English

| genre = wave

| license = Proprietary

| website = {{URL|https://aws.amazon.com/redshift/}}

}}

{{Use mdy dates|date=July 2015}}

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.{{cite web|url=https://www.infoworld.com/article/2612856/bye-bye--big-red--escaping-oracle-s-not-that-easy.html|title=Bye-bye, Big Red? Escaping Oracle's not that easy|website=infoworld.com|date=November 4, 2013|access-date=January 15, 2020|archive-date=January 15, 2020|archive-url=https://web.archive.org/web/20200115181052/https://www.infoworld.com/article/2612856/bye-bye--big-red--escaping-oracle-s-not-that-easy.html|url-status=live}} It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),{{cite web|title= Amazon Redshift: ParAccel in, costly appliances out|url= https://www.zdnet.com/article/amazon-redshift-paraccel-in-costly-appliances-out/|work= ZDNet|access-date= July 8, 2013|archive-date= June 5, 2013|archive-url= https://web.archive.org/web/20130605000041/http://www.zdnet.com/amazon-redshift-paraccel-in-costly-appliances-out-7000008111/|url-status= live}} 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.{{Cite web|title=Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services|url=https://aws.amazon.com/redshift/faqs/|access-date=2020-09-20|website=Amazon Web Services, Inc.|language=en-US|archive-date=September 17, 2020|archive-url=https://web.archive.org/web/20200917082646/https://aws.amazon.com/redshift/faqs/|url-status=live}} Redshift uses parallel processing and compression to decrease command execution time.{{Cite web|title=System and architecture overview - Amazon Redshift|url=https://docs.aws.amazon.com/redshift/latest/dg/c_redshift_system_overview.html|access-date=2020-10-01|website=docs.aws.amazon.com|archive-date=October 16, 2020|archive-url=https://web.archive.org/web/20201016002650/https://docs.aws.amazon.com/redshift/latest/dg/c_redshift_system_overview.html|url-status=live}}

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

}}{{cite web|url=http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html|title=Unsupported PostgreSQL features|work=AWS|publisher=Amazon|access-date=July 14, 2016|archive-date=November 15, 2019|archive-url=https://web.archive.org/web/20191115084956/https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html|url-status=live}} An initial preview beta was released in November 2012{{cite web|title=Amazon Debuts Low-Cost, Big Data Warehousing|url=https://www.informationweek.com/software/information-management/amazon-debuts-low-cost-big-data-warehous/240142712|work=Information Week|access-date=July 8, 2013|archive-date=May 31, 2013|archive-url=https://web.archive.org/web/20130531074545/http://www.informationweek.com/software/information-management/amazon-debuts-low-cost-big-data-warehous/240142712|url-status=live}} and a full release was made available on February 15, 2013.

Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,{{Citation | contribution-url = http://aws.amazon.com/redshift/partners/ | publisher = Amazon | title = AWS Partner Network | contribution = Amazon Redshift Partners|date=2017-02-06 |archive-url= https://web.archive.org/web/20170206101133/https://aws.amazon.com/redshift/partners/ | archive-date=2017-02-06}}. including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker, MicroStrategy, Pentaho,{{cite web|url=https://aws.amazon.com/redshift/partners-detail/pentaho/|title=APN - Amazon Redshift Partners - Pentaho|quote="Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift."|publisher=Amazon|work=AWS|access-date=February 6, 2017|archive-date=November 15, 2019|archive-url=https://web.archive.org/web/20191115084949/https://aws.amazon.com/redshift/partners-detail/pentaho/|url-status=live}} 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".{{cite web |last1=Krazit |first1=Tom |title=Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle |url=https://www.geekwire.com/2018/amazon-web-services-reportedly-named-cloud-database-redshift-order-tweak-oracle/ |website=GeekWire |date=January 2, 2018 |access-date=9 March 2022 |archive-date=March 9, 2022 |archive-url=https://web.archive.org/web/20220309051912/https://www.geekwire.com/2018/amazon-web-services-reportedly-named-cloud-database-redshift-order-tweak-oracle/ |url-status=live }}