| Latest revision |
Your text |
| Line 1: |
Line 1: |
| − | [[wikipedia: Amazon Redshift]] ([[AWS timeline|Nov 2012]]) <ref>https://aws.amazon.com/about-aws/whats-new/2012/11/28/announcing-amazon-redshift/</ref> [[data warehouse]] product based on [[PostgreSQL]] | + | [[wikipedia: Amazon Redshift]] (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/ | | * [[Free trial]]: 2 months. https://aws.amazon.com/redshift/free-trial/ or 6 months https://aws.amazon.com/dms/free-dms/ |
| − | * [[TCP port]]: [[5439]] | + | * [[TCP port]]: 5439 |
| | * [[Alarms]]: HealthStatus, .../... | | * [[Alarms]]: HealthStatus, .../... |
| − | * [[Amazon Redshift pricing]]
| |
| − |
| |
| − | == Features ==
| |
| − | * Federated queries (2020) <ref>https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-redshift-announces-general-availability-for-federated-querying/</ref>
| |
| − | * [[Store procedures]] (May 2019) <ref>https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-redshift-now-supports-stored-procedures/</ref>
| |
| − | * Encryption <ref>https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-db-encryption.html</ref> ([[Hardware Security Module (HSM)]])
| |
| − | * Cluster of nodes
| |
| | | | |
| | == Related terms == | | == Related terms == |
| − | * [[GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>)
| + | * [[PostgreSQL]] |
| − | * <code>[[HAS_TABLE_PRIVILEGE]]</code>
| |
| − | * <code>[[HAS_SCHEMA_PRIVILEGE]]</code>
| |
| − | * <code>[[HAS_ASSUMEROLE_PRIVILEGE]]</code>
| |
| − | * <code>[[HAS_DATABASE_PRIVILEGE]]</code>
| |
| − | * [[Amazon Redshift metrics]]: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html
| |
| − | * [[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]], <code>[[psql]]</code> | |
| − | * [[Amazon Redshift query editor]]
| |
| | * [[Distributed database]] | | * [[Distributed database]] |
| − | * [[Data warehouse]]: [[SQL Workbench/J]]
| + | * [[Amazon databases]] |
| − | * Certified: [[MicroStrategy]] and [[Jaspersoft]]
| + | * [[AWS Database Migration Service]] |
| − | * [[Amazon Redshift ML]] (May 2021) | + | * [[SQL Workbench/J]] |
| − | * [[Matillion]], [[Tableau]],[[ParAccel]]
| + | * [[HSM]] |
| − | * [[OLAP]] and [[BI]]
| + | * [[AWS PrivateLink]] |
| − | * [[Database Schema]] | |
| − | | |
| − | * [[Amazon Redshift]] Advanced Query Accelerator (AQUA) ([[AWS timeline|Apr 2021]]) <ref>https://press.aboutamazon.com/news-releases/news-release-details/aws-announces-general-availability-aqua-amazon-redshift</ref> | |
| − | * [[Amazon Redshift workload management (WLM)]] ([[AWS timeline|Sep 2019]]) <ref>https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/</ref>
| |
| − | * [[Amazon Redshift Spectrum]] ([[AWS timeline|Apr 2017]]) <ref>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/</ref>
| |
| − | * [[Amazon Redshift Advisor]] | |
| − | * [[Redshift Managed Storage (RMS)]] ([[AWS timeline| Dec 2019]]) <ref>https://aws.amazon.com/about-aws/whats-new/2019/12/amazon-redshift-announces-ra3-nodes-managed-storage/</ref>) | |
| − | * [[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]]: (<code>[[HAS_TABLE_PRIVILEGE]]</code>)
| |
| − | * [[Amazon Redshift: show permissions]]: (<code>[[has_schema_privilege]]</code>)
| |
| − | * [[Amazon Redshift: grant read only provileges to user]]: <code>[[GRANT_USAGE]], [[GRANT_SELECT]]</code>
| |
| − | | |
| − | == News ==
| |
| − | * 04/2022 [[Amazon Redshift]] announces new enhancements for [[Audit Logging]] <ref>https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-redshift-enhancements-audit-logging/</ref>
| |
| − | * 04/2020 Amazon Redshift announces support for [[role-based access control]] (RBAC) <ref>https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-redshift-role-based-access-control/</ref>
| |
| | | | |
| | == See also == | | == See also == |
| | * {{aws redshift}} | | * {{aws redshift}} |
| − | * {{Amazon Redshift}}
| |
| | * {{DW}} | | * {{DW}} |
| − | * {{OLAP}} | + | * {{RDS}} |
| − | * {{BI}}
| + | |
| | | | |
| | [[Category:AWS]] | | [[Category:AWS]] |
| − | [[Category:Data warehouse]]
| |
