generate-schema icon indicating copy to clipboard operation
generate-schema copied to clipboard

DATE inference for BigQuery is incorrect

Open sqlrob opened this issue 5 years ago • 0 comments

Given an object such as

{
  dateField: "2019-03-04 12:13:14"
}

A BigQuery schema is generated that considers that a DATE. If you then attempt to insert into the table with that same object, the insert fails because BigQuery doesn't parse the field as a date

sqlrob avatar Jun 06 '19 21:06 sqlrob