Difference between revisions of "Amazon Redshift"

From wikieduonline
Jump to navigation Jump to search
 
(46 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 based on [[PostgreSQL]]
+
[[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]]
 
* [[Amazon Redshift pricing]]
 +
 +
* Size: [[ra3.16xlarge]]: 48 vCPU, 384 GiB,  8.00 GB/s
  
 
== Features ==
 
== Features ==
Line 10: Line 15:
 
* Encryption <ref>https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-db-encryption.html</ref> ([[Hardware Security Module (HSM)]])
 
* Encryption <ref>https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-db-encryption.html</ref> ([[Hardware Security Module (HSM)]])
 
* Cluster of nodes
 
* 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 ==
−
* [[GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>)
+
* [[Amazon Redshift: GRANT|GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>)
−
* <code>[[HAS_TABLE_PRIVILEGE]]</code>
+
* [[Amazon RedShift: HAS...]]
−
* <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]]
 
−
* [[Data warehouse]]: [[SQL Workbench/J]]
 
−
* Certified: [[MicroStrategy]] and [[Jaspersoft]]
 
−
* [[Amazon Redshift ML]] (May 2021)
 
 
* [[Matillion]], [[Tableau]],[[ParAccel]]
 
* [[Matillion]], [[Tableau]],[[ParAccel]]
−
* [[OLAP]] and [[BI]]
+
* [[OLAP]] and [[Business Intelligence (BI)]]
−
* [[Database Schema]]
+
* [[Redshift system tables and views]]
 +
* [[Concurrency Scaling]]
 +
* <code>[[AmazonRedshiftAllCommandsFullAccess]]</code>
 +
* [[AWS Cloudwatch: /aws/redshift/]]
 +
* [[Amazon Redshift parameter groups]]
 +
* [[AWS Data]]
  
−
* [[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>
+
== 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>
 +
* May/2021 [[Amazon Redshift ML]]
 +
* Oct/2021 [[AWS Data Exchange for Amazon Redshift]]
 +
* 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 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 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>)
 
* [[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 ==
 
== Activities ==
Line 47: Line 54:
 
* [[Amazon Redshift: show permissions]]: (<code>[[has_schema_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>
 
* [[Amazon Redshift: grant read only provileges to user]]: <code>[[GRANT_USAGE]], [[GRANT_SELECT]]</code>
−
 
+
* Read [[Building Data Analytics Solutions Using Amazon Redshift]]
−
== News ==
+
* [[Get started with Amazon Redshift Serverless data warehouses]]
−
* 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}}
 
* {{Amazon Redshift}}
−
* {{DW}}
 
−
* {{OLAP}}
 
−
* {{BI}}
 
  
 
[[Category:AWS]]
 
[[Category:AWS]]
 
[[Category:Data warehouse]]
 
[[Category:Data warehouse]]
 +
[[Category:Business Intelligence]]

Latest revision as of 16:58, 25 March 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.

Features[edit]

Related terms[edit]

News[edit]

Activities[edit]

See also[edit]

  • ↑ 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/
    • Retrieved from "https://www.wikieduonline.com/index.php?title=Amazon_Redshift&oldid=381050"

    Advertising: