For other uses of "redshift", see Redshift (disambiguation).
Amazon Redshift
Developer(s)
Amazon.com
Initial release
October 2012; 11 years ago (2012-10)
Operating system
Cross-platform
Available in
English
License
Proprietary
Website
aws.amazon.com/redshift/
Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.[1] It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),[2] to handle large scale data sets and database migrations.[3] 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[4] compared to Amazon RDS Aurora's maximum size of 128 tebibytes.[5]
Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[6][7] An initial preview beta was released in November 2012[8] 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.[9]
According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift has the largest number of Cloud data warehouse deployments, with more than 6,500 deployments.[10]
Redshift uses parallel-processing and compression to decrease command execution time.[11] This allows Redshift to perform operations on billions of rows at once.[12] This also makes Redshift useful for storing and analyzing large quantities of data from logs or live feeds through a source such as Amazon Kinesis Data Firehose.[12]
Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,[13] including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker, MicroStrategy, Pentaho,[14][15] 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".[16]
^"Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com. November 4, 2013. Archived from the original on January 15, 2020. Retrieved January 15, 2020.
^"Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Archived from the original on June 5, 2013. Retrieved July 8, 2013.
^"Improve data processing performance on AWS Redshift by 200%". Ardentisys.com. Archived from the original on November 15, 2019. Retrieved April 14, 2017.
^"Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Archived from the original on September 17, 2020. Retrieved September 20, 2020.
^"Quotas and constraints for Amazon Aurora". Archived from the original on August 27, 2021. Retrieved April 1, 2022. An Aurora cluster volume can grow to a maximum size of 128 tebibytes (TiB)
^"Redshift and PostgreSQL". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 26, 2015.
^"Unsupported PostgreSQL features". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 14, 2016.
^"Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Archived from the original on May 31, 2013. Retrieved July 8, 2013.
^Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk. Archived from the original on October 13, 2017. Retrieved February 2, 2014..
^Little, Cinny. "The Forrester Wave™: Cloud Data Warehouse Solutions, Q4 2018" (PDF). Forrester. Retrieved December 18, 2020.[permanent dead link]
^"System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Archived from the original on October 16, 2020. Retrieved October 1, 2020.
^ ab"4 Amazon Redshift Use Cases: Collect, store, analyze & share data". intermix.io. August 26, 2020. Archived from the original on October 31, 2020. Retrieved October 1, 2020.
^"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. Archived from the original on November 15, 2019. Retrieved February 6, 2017. Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
^"Amazon Web Services". Pentaho.com. Archived from the original on April 1, 2018. Retrieved February 6, 2017. then transformed, refined, and immediately pushed into Amazon Redshift.
^Krazit, Tom (January 2, 2018). "Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle". GeekWire. Archived from the original on March 9, 2022. Retrieved March 9, 2022.
AmazonRedshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology...
broadcasting. Amazon Kinesis can be easily integrated with other AWS services, such as AWS Lambda, Amazon S3, AmazonRedshift, and Amazon OpenSearch. This...
backs up all changes to Amazon S3. Amazon Aurora AmazonRedshiftAmazon DynamoDB Amazon Relational Database Service "Amazon Web Services calls MongoDB's...
Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon that provides on-demand cloud computing platforms and APIs to individuals, companies, and governments...
Amazon Prime (stylized as simply Prime) is a paid subscription service of Amazon which is available in various countries and gives users access to additional...
Amazon Prime Video, or simply Prime Video, is an American subscription video on-demand over-the-top streaming and rental service of Amazon offered both...
timeline of Amazon Web Services, which offers a suite of cloud computing services that make up an on-demand computing platform. List of Amazon products and...
data frameworks like Apache Hadoop, Spark, Presto, HBase, and Flink. AmazonRedshift fully manages petabyte-scale data warehouse to run complex queries...
customers with long-term contracts in its "Redshift" storage service launching in 2013. In March 2013 Amazon announced its Mobile Ads API for developers...
Amazon Clinic is an Amazon subsidiary that provides virtual healthcare services, not to be confused with the company's in-person healthcare subsidiary...
Amazon Freevee (stylized as freevee and fv), also shortened as Freevee, formerly known as IMDb Freedive and IMDb TV, and sometimes spelled FV, is an American...
Amazon Drive, formerly known as Amazon Cloud Drive, was a cloud storage application managed by Amazon. The service offered secure cloud storage, file...
support to ZFS · openzfs/ZFS@10b3c7f". GitHub. "Zstandard Encoding - AmazonRedshift". 20 April 2019. Larabel, Michael (12 March 2018). "Canonical Working...
Amazon MGM Studios, formerly Amazon Studios, is an American film and television production and distribution studio owned by Amazon launched in 2010. It...
Amazon Robotics, formerly Kiva Systems, is a Massachusetts-based company that manufactures mobile robotic fulfillment systems. It is a subsidiary company...
Amazon is an American multinational technology company which focuses on e-commerce, cloud computing, and digital streaming. It has been referred to as...
Amazon.com has been criticized with questions raised about the ethics of the company's business practices and policies. Amazon has faced allegations of...
database management systems provided by major vendors such as Teradata, AmazonRedshift, Microsoft Azure, Alibaba AnalyticDB and, in the past, IBM Netezza...
company switched its Yandex.Mail service from Oracle to Postgres. AmazonRedshift, part of AWS, a columnar online analytical processing (OLAP) system...
Amazon Music (previously Amazon MP3) is a music streaming platform and Digital music store operated by Amazon. As of January 2020, the service had 55...
Amazon S3 or Amazon Simple Storage Service is a service offered by Amazon Web Services (AWS) that provides object storage through a web service interface...
Amazon Kindle is a series of e-readers designed and marketed by Amazon. Amazon Kindle devices enable users to browse, buy, download, and read e-books,...