AWS Glue – Querying Nested JSON with Relationalize Transform

Posted 4 CommentsPosted in AWS, AWS Glue

AWS Glue has transform Relationalize that can convert nested JSON into columns that you can then write to S3 or import into relational databases. As an example – Initial Schema: >>> df.printSchema() root |– Id: string (nullable = true) |– LastUpdated: long (nullable = true) |– LastUpdatedBy: string (nullable = true) |– Properties: struct (nullable […]