TimestampMapping

Timestamp specification to be supplied in an ingestion job specification.

Properties

inputField

String   required

The field to treat as the timestamp.

format

String   required

Possible values: iso, posixUtc, millisUtc, microUtc, nanoUtc, auto

The following timestamp formats are supported:

One of:

  • iso - An ISO 8601 or RFC 3339 timestamp. For example, 2021-12-15T14:00:23-8:00 or 2021-12-15 22:00:23Z.
  • posixUtc - Seconds since midnight of January 1, 1970 (the UNIX epoch) in UTC.
  • millisUtc - Milliseconds since midnight of January 1, 1970 (the UNIX epoch) in UTC.
  • microUtc - Microseconds since midnight of January 1, 1970 (the UNIX epoch) in UTC.
  • nanoUtc - Nanoseconds since midnight of January 1, 1970 (the UNIX epoch) in UTC.

As an example, the following values represent the timestamps formatted for each of the available options for December 15th, 2022, at 1:00:00pm UTC:

  • iso - 2021-12-15T13:00:00Z or 2021-12-15 13:00:00Z
  • posixUtc - 1639573200
  • millisUtc - 1639573200000
  • microUtc - 1639573200000000
  • nanoUtc - 1639573200000000000

missingValue

String

A default ISO-8601 timestamp value to use if inputField is absent in an input record.

Example: 2021-06-06T00:00:00.000Z

← JsonFormatSettingsRelease notes →