Upcoming fix for JSON timestamp extracts

[Jeremy Condit]

Hello BigQuery users,

Next Monday (2015-06-22), we will apply a bug fix for JSON extract jobs involving timestamps. Currently, null timestamp values appear in the output of a JSON extract job as "1970-01-01 00:00:00 UTC". After the fix is applied, null timestamp values will be omitted from the extract job's JSON output completely.

For example, if you have a record with a null timestamp whose JSON extract output current looks like this (reformatted onto multiple lines):

  {

    "string_field": "test string",

    "timestamp_field": "1970-01-01 00:00:00 UTC",

    "float_field": 42.0

  }

Then the new output will look like this:

  {

    "string_field": "test string",

    "float_field": 42.0

  }

If this change will cause problems for you, please contact Google Cloud Support or follow up via the BigQuery issue tracker:

https://code.google.com/p/google-bigquery/issues/detail?id=260

Thanks!

- The Google BigQuery team