Loading Data into BigQuery | Query Nested Json Data with SQL

In this lab we will show you how to load nested json data into Google bigquery through the UI and write SQL to unnest the dataset as well.

[suvratrai]

Thanks for the helpful video.
Q1: .Can I check if I want to append new data to an existing table and there are new key's encountered on the JSON, would the system automatically alter the table schema or the append operation will fail?

Q2: The autodetect schema option is able to scan the whole file to decide the schema of the table or it only does that based on top few rows?

[kesavaram]

Thanks for sharing the information. Can please make a video that loading nested json into bigquery using python

[BasheeruddinMohammed-gfwt]

I need your help and I am getting issues in nested table, I need your help please