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/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/
↑ 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/2022/04/amazon-redshift-enhancements-audit-logging/
↑ https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-redshift-role-based-access-control/
↑ https://press.aboutamazon.com/news-releases/news-release-details/aws-announces-general-availability-aqua-amazon-redshift
↑ https://aws.amazon.com/about-aws/whats-new/2019/09/amazon-redshift-announces-automatic-workload-management-and-query-priorities/
↑ 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/
↑ https://aws.amazon.com/about-aws/whats-new/2019/12/amazon-redshift-announces-ra3-nodes-managed-storage/
(99 intermediate revisions by the same user not shown) | |||
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. | + | [[wikipedia: Amazon Redshift]] ([[AWS timeline|Nov 2012]] - [[AWS timeline|Feb 2013]]) <ref>https://aws.amazon.com/about-aws/whats-new/2012/11/28/announcing-amazon-redshift/</ref> [[data warehouse]] [[distributed database]] product using [[column-oriented]] DBMS an based on a fork from [[PostgreSQL 8]] in 2005. |
+ | * https://aws.amazon.com/redshift/ | ||
* [[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 metrics]] ([https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html doc]) | ||
+ | * [[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> | ||
+ | * [[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 | ||
+ | * [[Amazon Redshift Managed Storage (RMS)]] (2019) | ||
+ | * [[Amazon Redshift workload management (WLM)]] (2019) | ||
+ | * [[Amazon Redshift Spectrum]] (2017) | ||
+ | * [[Amazon Redshift Advisor]] | ||
+ | * [[Amazon Redshift query editor]] | ||
+ | * [[Amazon Redshift Advanced Query Accelerator (AQUA)]] | ||
+ | * [[Amazon Redshift data sharing]] | ||
== Related terms == | == Related terms == | ||
− | * [[AWS | + | * [[Amazon Redshift: GRANT|GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>) |
− | * [[ | + | * [[Amazon RedShift: HAS...]] |
− | * [[ | + | * [[Matillion]], [[Tableau]],[[ParAccel]] |
− | * [[ | + | * [[OLAP]] and [[Business Intelligence (BI)]] |
− | * [[ | + | * [[Redshift system tables and views]] |
− | * [[ | + | * [[Concurrency Scaling]] |
+ | * <code>[[AmazonRedshiftAllCommandsFullAccess]]</code> | ||
+ | * [[AWS Cloudwatch: /aws/redshift/]] | ||
+ | * [[Amazon Redshift parameter groups]] | ||
+ | |||
+ | == 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> | ||
+ | * [[Amazon Redshift ML]] (May 2021) | ||
+ | * 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> | ||
+ | * 2020 [[Amazon RedShift Automatic Table Optimization]] | ||
+ | * [[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> | ||
+ | |||
+ | * [[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>) | ||
+ | |||
+ | == 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> | ||
+ | * Read [[Building Data Analytics Solutions Using Amazon Redshift]] | ||
+ | * [[Get started with Amazon Redshift Serverless data warehouses]] | ||
== See also == | == See also == | ||
* {{aws redshift}} | * {{aws redshift}} | ||
* {{Amazon Redshift}} | * {{Amazon Redshift}} | ||
− | |||
− | |||
− | |||
[[Category:AWS]] | [[Category:AWS]] | ||
[[Category:Data warehouse]] | [[Category:Data warehouse]] | ||
+ | [[Category:Business Intelligence]] |
Latest revision as of 10:37, 5 February 2025
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.
- https://aws.amazon.com/redshift/
- 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[edit]
- Federated queries (2020) [3]
- Store procedures (May 2019) [4]
- Encryption [5] (Hardware Security Module (HSM))
- Cluster of nodes
- Amazon Redshift Managed Storage (RMS) (2019)
- Amazon Redshift workload management (WLM) (2019)
- Amazon Redshift Spectrum (2017)
- Amazon Redshift Advisor
- Amazon Redshift query editor
- Amazon Redshift Advanced Query Accelerator (AQUA)
- Amazon Redshift data sharing
Related terms[edit]
- GRANT: View GRANTs on Redshift (
has_table_privilege
) - Amazon RedShift: HAS...
- Matillion, Tableau,ParAccel
- OLAP and Business Intelligence (BI)
- Redshift system tables and views
- Concurrency Scaling
AmazonRedshiftAllCommandsFullAccess
- AWS Cloudwatch: /aws/redshift/
- Amazon Redshift parameter groups
News[edit]
- 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
- Amazon Redshift Advanced Query Accelerator (AQUA) (Apr 2021) [8]
- Amazon Redshift workload management (WLM) (Sep 2019) [9]
Activities[edit]
- 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
- Read Building Data Analytics Solutions Using Amazon Redshift
- Get started with Amazon Redshift Serverless data warehouses
See also[edit]
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
Advertising: