Amazon Redshift

wikipedia: Amazon Redshift (Nov 2012 - Feb 2013) data warehouse distributed database product using column-oriented DBMS an based on a fork from PostgreSQL 8 in 2005.

• https://aws.amazon.com/redshift/
• Free trial: 2 months. https://aws.amazon.com/redshift/free-trial/ or 6 months https://aws.amazon.com/dms/free-dms/
• TCP port: 5439
• Alarms: HealthStatus, .../...
• Amazon Redshift metrics (doc)
• AWS Database Migration Service (DMS), include parallel since Dec 2020
• Amazon Redshift pricing

• Size: ra3.16xlarge: 48 vCPU, 384 GiB, 8.00 GB/s

Features

• Federated queries (2020)
• Store procedures (May 2019)
• Encryption (Hardware Security Module (HSM))
• Cluster of nodes
• Amazon Redshift Managed Storage (RMS) (2019)
• Amazon Redshift workload management (WLM) (2019)
• Amazon Redshift Spectrum (2017)
• Amazon Redshift Advisor
• Amazon Redshift query editor
• Amazon Redshift Advanced Query Accelerator (AQUA)
• Amazon Redshift data sharing

Related terms

• GRANT: View GRANTs on Redshift (has_table_privilege)
• Amazon RedShift: HAS...
• Matillion, Tableau,ParAccel
• OLAP and Business Intelligence (BI)
• Redshift system tables and views
• Concurrency Scaling
• AmazonRedshiftAllCommandsFullAccess
• AWS Cloudwatch: /aws/redshift/
• Amazon Redshift parameter groups
• AWS Data

News

• 04/2022 Amazon Redshift announces new enhancements for Audit Logging
• May/2021 Amazon Redshift ML
• Oct/2021 AWS Data Exchange for Amazon Redshift
• 04/2020 Amazon Redshift announces support for role-based access control (RBAC)
• 2020 Amazon RedShift Automatic Table Optimization
• Amazon Redshift Advanced Query Accelerator (AQUA) (Apr 2021)
• Amazon Redshift workload management (WLM) (Sep 2019)

• Amazon Redshift Spectrum (Apr 2017)

• Redshift Managed Storage (RMS) ( Dec 2019) )

Activities

• Read https://aws.amazon.com/redshift/whats-new/?amazon-redshift-whats-new
• Read https://stackoverflow.com/questions/tagged/amazon-redshift?tab=Votes
• View GRANTs on Redshift: (HAS_TABLE_PRIVILEGE)
• Amazon Redshift: show permissions: (has_schema_privilege)
• Amazon Redshift: grant read only provileges to user: GRANT_USAGE, GRANT_SELECT
• Read Building Data Analytics Solutions Using Amazon Redshift
• Get started with Amazon Redshift Serverless data warehouses

See also

• aws redshift [ describe-clusters | describe-events | create-cluster ]
• Amazon Redshift, aws redshift, Amazon Redshift query editor, AQUA, WLM, Amazon Redshift Spectrum, metrics, VACUUM, Amazon RedShift Management Guide

https://aws.amazon.com/about-aws/whats-new/2012/11/28/announcing-amazon-redshift/

https://aws.amazon.com/about-aws/whats-new/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/

https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-redshift-announces-general-availability-for-federated-querying/

https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-redshift-now-supports-stored-procedures/

https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-db-encryption.html

https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-redshift-enhancements-audit-logging/

https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-redshift-role-based-access-control/

https://press.aboutamazon.com/news-releases/news-release-details/aws-announces-general-availability-aqua-amazon-redshift

https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/

https://aws.amazon.com/about-aws/whats-new/2017/04/introducing-amazon-redshift-spectrum-run-amazon-redshift-queries-directly-on-datasets-as-large-as-an-exabyte-in-amazon-s3/

https://aws.amazon.com/about-aws/whats-new/2019/12/amazon-redshift-announces-ra3-nodes-managed-storage/