Editing Amazon Redshift

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 3: Line 3:
 
* [[TCP port]]: [[5439]]
 
* [[TCP port]]: [[5439]]
 
* [[Alarms]]: HealthStatus, .../...
 
* [[Alarms]]: HealthStatus, .../...
* [[Amazon Redshift pricing]]
 
  
 
== Features ==
 
== Features ==
Line 9: Line 8:
 
* [[Store procedures]] (May 2019) <ref>https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-redshift-now-supports-stored-procedures/</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)]])
 
* 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>)
 
* [[GRANT]]: [[View GRANTs on Redshift]] (<code>[[has_table_privilege]]</code>)
* <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
 
* [[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>
 
* [[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>
Line 27: Line 21:
 
* [[Matillion]], [[Tableau]],[[ParAccel]]
 
* [[Matillion]], [[Tableau]],[[ParAccel]]
 
* [[OLAP]] and [[BI]]
 
* [[OLAP]] and [[BI]]
 +
* [[AQUA]] Advanced Query Accelerator
 
* [[Database Schema]]
 
* [[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 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)]]
* [[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]]
 
* [[Redshift system tables and views]]
* [[Concurrency Scaling]]
 
 
* [[SET]]
 
  
 
== Activities ==
 
== Activities ==
 
* Read https://aws.amazon.com/redshift/whats-new/?amazon-redshift-whats-new
 
* Read https://aws.amazon.com/redshift/whats-new/?amazon-redshift-whats-new
 
* Read https://stackoverflow.com/questions/tagged/amazon-redshift?tab=Votes
 
* 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 ==

Please note that all contributions to wikieduonline may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Wikieduonline:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)

Advertising: