Amazon Redshift
wikipedia: Amazon Redshift (Nov 2012 - Feb 2013) [1] data warehouse distributed database product using column-oriented DBMS an based on a fork from PostgreSQL 8 in 2005.
- 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 [2]
- Amazon Redshift pricing
Features
- Federated queries (2020) [3]
- Store procedures (May 2019) [4]
- Encryption [5] (Hardware Security Module (HSM))
- Cluster of nodes
Related terms
- Amazon Redshift query editor
- GRANT: View GRANTs on Redshift (
has_table_privilege) - Amazon RedShift: HAS...
- Matillion, Tableau,ParAccel
- OLAP and Business Intelligence (BI)
- Amazon Redshift Advisor
News
- 04/2022 Amazon Redshift announces new enhancements for Audit Logging [6]
- Amazon Redshift ML (May 2021)
- 04/2020 Amazon Redshift announces support for role-based access control (RBAC) [7]
- 2020 Amazon RedShift Automatic Table Optimization
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
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 - Data warehouse, ETL, ELT, CDC, Amazon Redshift, Oracle Exadata, data build tool (dbt), Data Lake
- OLAP, OLTP, ClickHouse, Amazon Redshift
Advertising:
