title: Unnesting Multiple Nested Fields Deep in BigQuery
body: <p>I am trying to use Standard SQL Dialect in BigQuery to unnest the changelog.histories.items repeated record (outlined in green) to access the rows in the nested items table (outlined in blue). The parent Record "changelog" (outlined in Red) is not a repeated record and therefore I am having issues figuring out what to unnest. </p>
  
  <p>Queries that attempt to unnest changelog.histories or changelog.histories.items result in the below error. </p>
  
  <pre><code>SELECT changelog.histories.items.to
  FROM jirasparta_database.jira_issues, 
       unnest(changelog.histories) 
  </code></pre>
  
  <p><em>Error: Cannot access field items on a value with type ARRAY, ...>, items ARRAYto STRING, field STRING, fieldtype STRING, ...>>, ...>> at [1:28]</em></p>
  
  <p><img src="https://i.stack.imgur.com/Ys7UN.png" alt="Image of Table Schema with color coding"></p>