January 17, 2025 — OWOX Reports. Improved Export for Nested Data from BigQuery to Google Sheets

changelog-2025-01-17-export-nested-fields-from-bigquery-to-google-sheets-opt.png

We're excited to announce a new feature in the “OWOX: Reports, Charts & Pivots” extension that streamlines working with complex, nested data structures from BigQuery. You can now export Repeated and Record fields — essential for hierarchical or structured data — into Google Sheets, eliminating previous challenges.

Improved Handling of Nested Data in Google Sheets

BigQuery often uses Repeated or Record fields to store nested data in a structured format. While this structure is perfect for database queries, exporting this data to Google Sheets (which uses a flat structure) has been difficult. Previously, running these reports in the OWOX BI Reports extension resulted in errors, even after a successful dry run.

Seamless Integration of Nested Data

With this update, the OWOX BI Reports extension now supports exporting Repeated and Record fields directly into Google Sheets. These fields are inserted in JSON format within individual cells, simplifying the visualization and processing of complex data.

Key Benefits

  • No More Errors: Confidently export nested data from BigQuery without interruptions or limitations.
  • Effortless JSON Handling: Use built-in functions to manipulate JSON-formatted data in Google Sheets easily. Transform data into a flat structure or a custom format as needed.

How it works

Create a new Data Mart, write an SQL query, and click the 'Save & Run' button. That's it.

Read step-by-step instructions of how to create Data Mart

 

Get Started with JSON in Google Sheets

Are you new to working with JSON data in Google Sheets? Our detailed guide will help you get the most out of it. Learn more here: How to Work with JSON in Google Sheets

 

We're committed to improving your data experience. If you have any questions or need help, our support team is always here for you — reach out to us at bi@owox.com.

Thank you for choosing OWOX BI.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.