Sample 1 shows example user data from the game. Suppose that the developers of a video game want to use a data warehouse like Amazon Redshift to run reports on player behavior based on data that is stored in JSON.
Let’s look at how Relationalize can help you with a sample use case. The transformed data maintains a list of the original keys from the nested JSON separated by periods.
Relationalize transforms the nested JSON into key-value pairs at the outermost level of the JSON document. May 2022: This post was reviewed and updated to include resources for orchestrating data and machine learning pipelines.ĪWS Glue has a transform called Relationalize that simplifies the extract, transform, load (ETL) process by converting nested JSON into columns that you can easily import into relational databases.
0 kommentar(er)
