Geolonia 住所データ https://geolonia.github.io/japanese-addresses/ のCSVファイルをBigQueryに登録するとカラム名取得に失敗するので、スキーマファイルを用意しよう委員会

geolonia_schema.json

[
  {
    "name": "prefecture_code",
    "type": "INTEGER",
    "mode": "NULLABLE",
    "description": "都道府県コード"
  },
  {
    "name": "prefecture_name",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "都道府県名"
  },
  {
    "name": "prefecture_name_kana",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "都道府県名カナ"
  },
  {
    "name": "prefecture_name_roman",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "都道府県名ローマ字"
  },
  {
    "name": "city_code",
    "type": "INTEGER",
    "mode": "NULLABLE",
    "description": "市区町村コード"
  },
  {
    "name": "city_name",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "市区町村名"
  },
  {
    "name": "city_name_kana",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "市区町村名カナ"
  },
  {
    "name": "city_name_roman",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "市区町村名ローマ字"
  },
  {
    "name": "town_code",
    "type": "INTEGER",
    "mode": "NULLABLE",
    "description": "大字町丁目コード"
  },
  {
    "name": "town_name",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "大字町丁目名"
  },
  {
    "name": "latitude",
    "type": "FLOAT",
    "mode": "NULLABLE",
    "description": "緯度（代表点）"
  },
  {
    "name": "longitude",
    "type": "FLOAT",
    "mode": "NULLABLE",
    "description": "経度（代表点）"
  }
]