Editing Amazon Redshift

[[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]]
* [[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 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 ==
* [[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
* [[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]]
* [[OLAP]] and [[BI]]
* [[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]]

* [[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 ==
* {{aws redshift}}
* {{Amazon Redshift}}
* {{DW}}
* {{OLAP}}
* {{BI}}

[[Category:AWS]]
[[Category:Data warehouse]]