A partner sends CSV files over SFTP every night and the files should land in S3 before a Glue ETL starts.
Manage per-partner authentication and transfer without operating an SSH server for the processing platform.
Which design or service is most appropriate?
AWS Transfer Family provides a managed SFTP boundary connected to S3 so received files can enter the data lake and downstream workflows.
Detailed explanation
Athena queries data in storage; it does not accept SFTP connections.
Athena queries data in storage; it does not accept SFTP connections.
It provides the SFTP authentication and transfer interface and stores received files in S3 for downstream processing.
It provides the SFTP authentication and transfer interface and stores received files in S3 for downstream processing.
DynamoDB is a key-value database and does not terminate SFTP or transfer files.
DynamoDB is a key-value database and does not terminate SFTP or transfer files.
CloudWatch Logs stores log events and is not an SFTP receiving interface for partner files.
CloudWatch Logs stores log events and is not an SFTP receiving interface for partner files.
Check official documentation
Compare the following points with the official documentation.
AWS Transfer FamilyのSFTPサーバー、S3連携、認証方式、受信後のイベント連携を確認する。
What to confirm
ファイル転送の入口と、DynamoDB・Athena・CloudWatch Logsの役割の違いを説明できる。
Key points
- AWS Transfer Family
- SFTP
- S3
- File ingestion
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm the relevant DEA-C01 Skill and current AWS service documentation.
Foundation review
Boundary service
Translate an existing partner protocol into a managed AWS storage workflow.
Downstream trigger
Start validation or ETL after a complete object is written to the destination.