Load daily Parquet data in S3 into Amazon Redshift.
Avoid repeated row-by-row INSERT statements and load the analytical table efficiently.
Which SQL operation is most appropriate?
Use the Redshift COPY command to load files from S3 in parallel.
Detailed explanation
CloudFormation provisions infrastructure and does not load table data.
CloudFormation provisions infrastructure and does not load table data.
COPY loads files from S3 and other supported sources into a Redshift table in parallel.
COPY loads files from S3 and other supported sources into a Redshift table in parallel.
UNLOAD writes Redshift data to an external destination; it is the opposite direction.
UNLOAD writes Redshift data to an external destination; it is the opposite direction.
VACUUM reorganizes table storage but does not load S3 files.
VACUUM reorganizes table storage but does not load S3 files.
Check official documentation
Compare the following points with the official documentation.
Amazon Redshift COPYのS3、Parquet、IAMロールの公式説明を確認する。
What to confirm
COPYとUNLOADの方向・用途の違いを説明できる。
Key points
- Redshift COPY
- Parquet
- Bulk load
- S3
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Load direction
COPY moves data into Redshift; UNLOAD writes Redshift results to an external destination.
Load contract
Credentials, file format, manifests, and retry behavior determine a safe repeatable load.