Amazon Redshift

wikipedia: Amazon Redshift (Nov 2012) data warehouse product.

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

Related terms

• AWS Database Migration Service (DMS), include parallel since Dec 2020
• PostgreSQL
• 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

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
• Amazon databases: AWS RDS, storage, aws rds, Amazon RDS Proxy, RDS FAQs, PostgreSQL, MySQL, SQL Server, AWS Outposts, Amazon Aurora, Amazon Aurora Serverless , Amazon DocumentDB, Amazon DynamoDB, Amazon Redshift, Amazon QLDB, Amazon RDS Performance Insights, DataFileRead, DMS, Amazon Neptune, Amazon MemoryDB for Redis, Amazon RDS query editor for Aurora Serverless, Amazon Redshift query editor, AWS RDS Snapshots, AWS RDS Instance Types, rds_superuser, Authentication, autoscaling

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://aws.amazon.com/about-aws/whats-new/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/