You can parse and flatten explode JSON files with arrays in Wrangler. Because JSON files can be large and because
Wrangler supports up to 10 MB for sampling files, so if the JSON file must be stored is large, store it in Google Cloud Storage or BigQuery.
To parse JSON files with arrays, follow these steps:
In Wrangler, Wrangler source (GCS or BigQuery), read a select the 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 → you want to parse. Wrangler displays the JSON as a single row of String data type.
Click the down arrow to the left of the column and click Parse > JSON.
Select the required Depth and click Apply.
If the JSON has an Array, Wrangler displays Array data type above the column:
Find the Array column, click the down arrow, and click Explode > Array (by flattening).
This
...
explodes 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
...
Continue adding directives to transform the data before creating a data pipeline.