CSV files in S3 contain addresses with commas.
Do not treat a comma inside a quoted address as a column delimiter.
Which response is most appropriate?
Match the Glue classifier and parser settings for delimiter, quote, escape, header, and schema rules.
Detailed explanation
This corrupts addresses and free-text values instead of interpreting CSV syntax.
This corrupts addresses and free-text values instead of interpreting CSV syntax.
Encryption protects stored data but does not change CSV parsing rules.
Encryption protects stored data but does not change CSV parsing rules.
IAM manages permissions and does not control a CSV parser.
IAM manages permissions and does not control a CSV parser.
Quoted delimiters are parsed as field content and the intended columns remain intact.
Quoted delimiters are parsed as field content and the intended columns remain intact.
Check official documentation
Compare the following points with the official documentation.
AWS GlueのCSV分類子、区切り文字、引用符、スキーマ検出の公式説明を確認する。
What to confirm
データ形式の解析設定と、暗号化・権限設定を区別できる。
Key points
- CSV
- Quote character
- Delimiter
- Glue classifier
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Format contract
The producer and ETL parser must agree on delimiters, quoting, escaping, headers, and types.
Reject path
Unparseable rows should be counted and isolated so their cause can be corrected.