Amazon Redshift

wikipedia: Amazon Redshift (Nov 2012) data warehouse product based on PostgreSQL

• 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 pricing

Features

• Federated queries (2020)
• Store procedures (May 2019)
• Encryption (Hardware Security Module (HSM))
• Cluster of nodes

Related terms

• GRANT: View GRANTs on Redshift (has_table_privilege)
• HAS_TABLE_PRIVILEGE
• HAS_SCHEMA_PRIVILEGE
• HAS_ASSUMEROLE_PRIVILEGE
• HAS_DATABASE_PRIVILEGE
• Amazon Redshift metrics: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html
• AWS Database Migration Service (DMS), include parallel since Dec 2020
• PostgreSQL, psql
• Amazon Redshift query editor
• Distributed database
• Data warehouse: SQL Workbench/J
• Certified: MicroStrategy and Jaspersoft
• Amazon Redshift ML (May 2021)
• Matillion, Tableau,ParAccel
• OLAP and BI
• Database Schema

• Amazon Redshift Advanced Query Accelerator (AQUA) (Apr 2021)
• Amazon Redshift workload management (WLM) (Sep 2019)
• Amazon Redshift Spectrum (Apr 2017)
• Amazon Redshift Advisor
• Redshift Managed Storage (RMS) ( Dec 2019) )
• Automatic Table Optimization (Dec 2020)

• Redshift system tables and views
• Concurrency Scaling

• SET

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

News

• 04/2022 Amazon Redshift announces new enhancements for Audit Logging
• 04/2020 Amazon Redshift announces support for role-based access control (RBAC)

See also

• Amazon Redshift: aws redshift, aws redshift describe-clusters, aws redshift describe-events, aws redshift create-cluster
• Amazon Redshift, aws redshift, Amazon Redshift query editor, GRANT, AQUA, has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET
• Data warehouse, ETL, ELT, CDC, Amazon Redshift, data build tool (dbt), Data Lake
• OLAP, OLTP, ClickHouse, Amazon Redshift
• Business Intelligence, Pentaho, AWS Redshift, QuickSight, Amazon Kinesis, Power BI, OLAP, OLTP, Looker, Jaspersoft, MicroStrategy, Metabase

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

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/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/

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/

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/