Do Yourself a Favor and Stay Away from BigQuery Schema Auto-detection

define_address_schema.py

import json

schema = [
 {
   "description": "Name of the house",
   "name": "name",
   "type": "STRING",
   "mode": "REQUIRED"
 },
 {
   "description": "Address of the house",
   "name": "address",
   "type": "RECORD",
   "mode": "REQUIRED",
   "fields": [
      {
        "description": "Primary address of the house",
        "name": "adress1",
        "type": "STRING",
        "mode": "REQUIRED"
      },
      {
        "description": "Secondary address of the house",
        "name": "address2",
        "type": "STRING",
        "mode": "NULLABLE"
      }
   ]
 }  
]

with open('address_schema.json', 'w') as _f:
  json.dump(schema, _f)