Difference between revisions of "Amazon Redshift"
Jump to navigation
Jump to search
↑ 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/
| Line 10: | Line 10: | ||
== Related terms == | == Related terms == | ||
* [[AWS Database Migration Service (DMS)]], include parallel since Dec 2020<ref>https://aws.amazon.com/about-aws/whats-new/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/</ref> | * [[AWS Database Migration Service (DMS)]], include parallel since Dec 2020<ref>https://aws.amazon.com/about-aws/whats-new/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/</ref> | ||
| − | * [[PostgreSQL]] | + | * [[PostgreSQL]], <code>[[psql]]</code> |
* [[Distributed database]] | * [[Distributed database]] | ||
* [[Data warehouse]]: [[SQL Workbench/J]] | * [[Data warehouse]]: [[SQL Workbench/J]] | ||
| Line 21: | Line 21: | ||
* [[OLAP]] and [[BI]] | * [[OLAP]] and [[BI]] | ||
* [[ParAccel]] | * [[ParAccel]] | ||
| − | |||
* [[AQUA]] | * [[AQUA]] | ||
* Metrics: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html | * Metrics: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html | ||
Revision as of 08:26, 7 December 2021
wikipedia: Amazon Redshift (Nov 2012) [1] 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, .../...
Contents
Features
- Federated queries (2020) [2]
- Store procedures (May 2019) [3]
Related terms
- AWS Database Migration Service (DMS), include parallel since Dec 2020[4]
- 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
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
Advertising:
