AWS Redshift 学习笔记

最新推荐文章于 2025-10-15 18:08:08 发布

原创

最新推荐文章于 2025-10-15 18:08:08 发布 · 4.1k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#Amazon Redshift #Redshift #AWS #AWS 认证

Amazon Redshift是一种快速、强大且完全托管的PB级数据仓库服务。它支持从Amazon S3批量加载数据，提供高并发查询队列管理和多种数据分布策略。通过Workload Management可优化资源分配，同时支持数据压缩和加密保障数据安全。

Amazon Redshift is a fast, powerful, fully managed, petabyte-scale data warehouse service in the cloud. Amazon Redshift is a relational database designed for OLAP scenarios and optimized for high-performance analysis and reporting of very large datasets.

Clusters and Nodes

The key component of an Amazon Redshift data warehouse is a cluster.A cluster is composed of a leader node and one or more compute nodes.The client application interacts directly only with the leader node, and the compute nodes are transparent to external applications.

The Dense Compute node types support clusters up to 326TB using fast SSDs, while the Dense Storage nodes support clusters up to 2PB using large magnetic disks.

Each cluster contains one or more databases. User data for each table is distributed across the compute nodes.Your application or SQL client communicates with Amazon Redshift using standard JDBC or ODBC connections with the le