Please provide your query.
I did not write one out. I simply linked the dataset to my tableau workbook and then hit update now and then the posted errors showed up. Steps 1-4 is all that I did. I did not write a custom query (which is what i'll likely need to do either in a view on BigQuery and then reference that in tableau) or in tableau with its own custom sql query.
You should unmark my previous answer as correct!
I'm not really familiar with the BigQuery platform, but it does sound like you'll need a custom query on the Tableau side or the BigQuery side. In terms of getting help writing this, it's really hard to give you specific advice without access to that same dataset myself. I wouldn't know where to start in terms of advising you on query structure etc as I don't know what your schema sounds like.
You might also find some helpful information on this page with regards to nested data - Google BigQuery