Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Load JSON to BigQuery with varying schema

I have a requirement to load 5M Json files to be loaded to BigQuery.

This is a nested and repeated column in the JSON. I wrote a code which auto detect the schema and load the JSON, however when the next file is getting loaded the data are becoming NULL. Will BigQuery auto adjust for the schema changes in the inout Json file ?

thanks in advance for your help

4 0 138
0 REPLIES 0