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, .../...

Features

• Federated queries (2020)
• Store procedures (May 2019)
• Encryption (HSM)

Related terms

• AWS Database Migration Service (DMS), include parallel since Dec 2020
• PostgreSQL, psql
• Distributed database
• Data warehouse: SQL Workbench/J
• Hardware Security Module (HSM)
• AWS PrivateLink
• Amazon Redshift query editor
• Certified: MicroStrategy and Jaspersoft
• Amazon Redshift ML (May 2021)
• Matillion, Tableau
• OLAP and BI
• ParAccel
• AQUA
• Metrics: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html
• Database Schema

Activities

• Read https://aws.amazon.com/redshift/whats-new/?amazon-redshift-whats-new

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/