Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The PARSE-AS-SIMPLEDATE directive parses strings with datetime values to the timestamp_micros data type, which is based on the Avro timestamp_micros type.

To convert timestamp_micros to date types, see Converting Timestamp types to Date.

If you are adding a Wrangler transformation to a pipeline with BigQuery sources or sinks and you want to write to a BigQuery datetime column, use PARSE-AS-DATETIME and not PARSE-AS-SIMPLEDATE.

...