Save an aggregate query result from Redshift in S3 for Athena and another AWS account.
Write multiple files in parallel and use compressed Parquet format.
Which operation is most appropriate?
Use Redshift UNLOAD to write a SELECT result to S3 in parallel, with Parquet and compression.
Detailed explanation
UNLOAD writes a query result to S3 in parallel and supports Parquet and compression options.
UNLOAD writes a query result to S3 in parallel and supports Parquet and compression options.
COPY loads external files into Redshift and does not export a Redshift result.
COPY loads external files into Redshift and does not export a Redshift result.
ANALYZE updates optimizer statistics and does not write query results to S3.
ANALYZE updates optimizer statistics and does not write query results to S3.
DynamoDB Export writes a DynamoDB table to S3, not a Redshift SELECT result.
DynamoDB Export writes a DynamoDB table to S3, not a Redshift SELECT result.
Check official documentation
Compare the following points with the official documentation.
Amazon Redshift UNLOADのS3、Parquet、圧縮、暗号化の公式説明を確認する。
What to confirm
データロードとデータ書き出し、統計更新の違いを説明できる。
Key points
- Redshift UNLOAD
- S3 output
- Parquet
- Compression
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Export layout
File count, compression, format, and partitioning affect Athena and cross-account consumers.
Encryption
S3 policies, KMS keys, and execution roles protect exported data independently of its format.