You can parse and flatten JSON files with arrays in Wrangler. Because JSON files can be large and because Wrangler supports up to 10 MB for sampling files, the JSON file must be stored in Google Cloud Storage or BigQuery.
To parse JSON files with arrays, follow these steps:
In Wrangler, Wrangler source (GCS or BigQuery), read a JSON file to Wrangle.
Once navigated to Wrangler tab, open the dropdown on the column and choose Parse → JSON.
After Step 4, the fields in the JSON will form the column. Identify the column that has rows.
Open the drop-down from that specific column and select Explode → Array (by flattening).
This will explode the elements in the JSON array as individual data in the same column in Wrangler.
After step 7 further directives can be applied based on cleanup needed.