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/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/2020/12/aws-database-migration-service-supports-parallel-apply-cdc-mode-using-redshift-target/
↑ 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/
↑ 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/
| (36 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* [[TCP port]]: [[5439]] | * [[TCP port]]: [[5439]] | ||
* [[Alarms]]: HealthStatus, .../... | * [[Alarms]]: HealthStatus, .../... | ||
| + | * [[Amazon Redshift pricing]] | ||
== Features == | == Features == | ||
* Federated queries (2020) <ref>https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-redshift-announces-general-availability-for-federated-querying/</ref> | * 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> | * [[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 == | == 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> | * [[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]] | + | * [[PostgreSQL]], <code>[[psql]]</code> |
| + | * [[Amazon Redshift query editor]] | ||
* [[Distributed database]] | * [[Distributed database]] | ||
* [[Data warehouse]]: [[SQL Workbench/J]] | * [[Data warehouse]]: [[SQL Workbench/J]] | ||
| − | |||
| − | |||
| − | |||
* Certified: [[MicroStrategy]] and [[Jaspersoft]] | * Certified: [[MicroStrategy]] and [[Jaspersoft]] | ||
* [[Amazon Redshift ML]] (May 2021) | * [[Amazon Redshift ML]] (May 2021) | ||
| − | * [[Matillion]], [[Tableau]] | + | * [[Matillion]], [[Tableau]],[[ParAccel]] |
* [[OLAP]] and [[BI]] | * [[OLAP]] and [[BI]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
* [[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 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]] (Dec 2020) | ||
| + | |||
| + | * [[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 | ||
| + | * [[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 == | ||
Latest revision as of 08:35, 12 May 2022
wikipedia: Amazon Redshift (Nov 2012) [1] 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[edit]
- Federated queries (2020) [2]
- Store procedures (May 2019) [3]
- Encryption [4] (Hardware Security Module (HSM))
- Cluster of nodes
Related terms[edit]
- GRANT: View GRANTs on Redshift (
has_table_privilege) HAS_TABLE_PRIVILEGEHAS_SCHEMA_PRIVILEGEHAS_ASSUMEROLE_PRIVILEGEHAS_DATABASE_PRIVILEGE- Amazon Redshift metrics: https://docs.aws.amazon.com/redshift/latest/mgmt/metrics-listing.html
- AWS Database Migration Service (DMS), include parallel since Dec 2020[5]
- PostgreSQL,
psql - 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) (Apr 2021) [6]
- Amazon Redshift workload management (WLM) (Sep 2019) [7]
- Amazon Redshift Spectrum (Apr 2017) [8]
- Amazon Redshift Advisor
- Redshift Managed Storage (RMS) ( Dec 2019) [9])
- Automatic Table Optimization (Dec 2020)
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
News[edit]
- 04/2022 Amazon Redshift announces new enhancements for Audit Logging [10]
- 04/2020 Amazon Redshift announces support for role-based access control (RBAC) [11]
See also[edit]
- Amazon Redshift:
aws redshift,aws redshift describe-clusters,aws redshift describe-events,aws redshift create-cluster - Amazon Redshift,
aws redshift, Amazon Redshift query editor, GRANT, AQUA,has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET - Data warehouse, ETL, ELT, CDC, Amazon Redshift, data build tool (dbt), Data Lake
- OLAP, OLTP, ClickHouse, Amazon Redshift
- Business Intelligence, Pentaho, AWS Redshift, QuickSight, Amazon Kinesis, Power BI, OLAP, OLTP, Looker, Jaspersoft, MicroStrategy, Metabase
Advertising:
