How to fix the "Cannot output multiple independently repeated fields at the same time" error?

NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.

To query nested data (the fields with the RECORD data type), use the FLATTEN function.

Please read BigQuery reference guide for more information.