Importing JSON file into Google BigQuery table

1
votes

I am trying to import a JSON file into a Google BigQuery table using the BigQuery Web UI.

When I define the JSON schema it fails to import because some of the json field names contain dashes - the UI reports and error saying the field is invalid.

For example:

{
    "first-name": "Bob",
    "last-name": "Smith"
}

I have huge amounts of data already in this format, so renaming the field isn't really an option. Any ideas?

1
jsongoogle-bigquery

1 Answers

2
votes

BigQuery currently only supports field names in the following format: uppercase and/or lowercase letters (A-Z, a-z), digits (0-9) and underscores, (but not spaces or other characters).