Difference between revisions of "Amazon Redshift"

From wikieduonline
Jump to navigation Jump to search
 
(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 Database Migration Service (DMS)]]
+
* [[Amazon Redshift: GRANT|GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>)
−
* [[PostgreSQL]]
+
* [[Amazon RedShift: HAS...]]
−
* [[Distributed database]]
+
* [[Matillion]], [[Tableau]],[[ParAccel]]
−
* [[Data warehouse]]: [[SQL Workbench/J]]
+
* [[OLAP]] and [[Business Intelligence (BI)]]
−
* [[HSM]]
+
* [[Redshift system tables and views]]
−
* [[AWS PrivateLink]]
+
* [[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}}
−
* {{DW}}
 
−
* {{RDS}}
 
−
 
  
 
[[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.

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=371815"

    Advertising: