Insight
When uploading JSON data to a BigQuery table with autodetect enabled, I encountered an issue where the field "a" could not be converted to an integer.
Upon further investigation and modification of the JSON data, changing values in the "a" field to strings resulted in successful data loading without any errors.
It is puzzling why BigQuery inferred the field "a" as a string in one scenario but attempted to convert it to an integer in another.
Request
I believe that BigQuery assigns a type to a field only when it encounters relevant data, yet the automatic conversion inconsistencies may lead to potential problems.
If anyone can confirm my assumptions and suggest ways to prevent such errors while relying on autodetect for dynamic data inputs, it would be greatly appreciated.