An API response contains nested data such as customer.address.city.
Make the city available as a flat column for Athena queries.
Which processing approach is most appropriate?
Use Glue or Spark to expand nested fields and define column names and data types.
Detailed explanation
Object Lock protects object retention and does not transform JSON structure.
Object Lock protects object retention and does not transform JSON structure.
A role can authorize a transformation, but it does not change the data structure.
A role can authorize a transformation, but it does not change the data structure.
Athena cannot query the city directly and must repeatedly parse an ambiguous string.
Athena cannot query the city directly and must repeatedly parse an ambiguous string.
The selected fields can be moved to top-level columns with explicit names and types for querying.
The selected fields can be moved to top-level columns with explicit names and types for querying.
Check official documentation
Compare the following points with the official documentation.
AWS GlueのJSON分類、DynamicFrameのネスト列、Sparkのstruct展開を確認する。
What to confirm
データ構造の変換と、アクセス権・オブジェクト保護を区別できる。
Key points
- JSON
- Nested field
- Flattening
- Athena
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Semi-structured data
Preserving or expanding nesting is a trade-off between query convenience and schema flexibility.
Type normalization
Explicit numeric, timestamp, and null rules prevent downstream type ambiguity.