Export Redshift history to an S3 data lake by date.
Enable Athena partition pruning and use Parquet compression.
Which configuration is most appropriate?
Use Redshift UNLOAD with PARTITION BY, Parquet, and compression options.
Detailed explanation
UNLOAD writes query results into date partitions in an analytics-friendly format.
UNLOAD writes query results into date partitions in an analytics-friendly format.
COPY loads files from S3 into Redshift; its direction is the reverse.
COPY loads files from S3 into Redshift; its direction is the reverse.
DynamoDB Export operates on DynamoDB tables, not Redshift query results.
DynamoDB Export operates on DynamoDB tables, not Redshift query results.
Versioning keeps object generations and does not create partitioned Parquet output.
Versioning keeps object generations and does not create partitioned Parquet output.
Check official documentation
Compare the following points with the official documentation.
Amazon Redshift UNLOAD PARTITION BY、Parquet、圧縮の公式説明を確認する。
What to confirm
COPYとUNLOAD、S3版管理・DynamoDB Exportの方向と用途を区別できる。
Key points
- UNLOAD
- PARTITION BY
- Parquet
- Compression
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Partition pruning
A date predicate can avoid reading unrelated S3 partitions.
Format choice
Columnar compression improves scan efficiency when downstream queries select subsets of columns.