We added support for BigQuery's nested and repeated columns

June 23rd, 2022
Post Cover Image

We know it can be difficult to navigate RECORD columns in your BigQuery datasets, so we added additional features to ensure that you can properly explore this type of data within PopSQL. In the schema view, you will see both the main RECORD column like "addresses" in the pictured example and the nested attributes (e.g. "status", "address", "city", "state", "zip", "numberOfYears"). When you query the data, in the results view, you will see a summary of the number of items in the RECORD column, and then, you can expand to pull up a table of the records.

We are continuing to iterate on this feature and looking to bring it to other databases, so please write into support@popsql.com with your feedback!

Ready for a modern SQL editor?