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/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/
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.
- 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/
- TCP port: 5439
- Alarms: HealthStatus, .../...
- Amazon Redshift metrics (doc)
- AWS Database Migration Service (DMS), include parallel since Dec 2020 [2]
- Amazon Redshift pricing
Features[edit]
- Federated queries (2020) [3]
- Store procedures (May 2019) [4]
- Encryption [5] (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[edit]
- GRANT: View GRANTs on Redshift (
has_table_privilege
) - Amazon RedShift: HAS...
- Matillion, Tableau,ParAccel
- OLAP and Business Intelligence (BI)
- Redshift system tables and views
- Concurrency Scaling
AmazonRedshiftAllCommandsFullAccess
- AWS Cloudwatch: /aws/redshift/
- Amazon Redshift parameter groups
News[edit]
- 04/2022 Amazon Redshift announces new enhancements for Audit Logging [6]
- Amazon Redshift ML (May 2021)
- 04/2020 Amazon Redshift announces support for role-based access control (RBAC) [7]
- 2020 Amazon RedShift Automatic Table Optimization
- Amazon Redshift Advanced Query Accelerator (AQUA) (Apr 2021) [8]
- Amazon Redshift workload management (WLM) (Sep 2019) [9]
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
- Read Building Data Analytics Solutions Using Amazon Redshift
- Get started with Amazon Redshift Serverless data warehouses
See also[edit]
aws redshift
[describe-clusters
|describe-events
|create-cluster ]
- Amazon Redshift,
aws redshift
, Amazon Redshift query editor, AQUA, WLM, Amazon Redshift Spectrum, metrics, VACUUM, Amazon RedShift Management Guide
Advertising: