how convert a iso8601_ns string to timestamp?

[1123183721]

.a="2024-06-05T08:40:02.015146042Z"
.timestamp=to_unix_timestamp(parse_timestamp!(.a, format: "%F T %T%.9f%z"), unit: "nanoseconds")

The log:
2024-06-06T02:41:02.502003Z ERROR transform{component_kind="transform" component_id=trans component_type=remap}: vector::internal_events::remap: Mapping failed with event. error="function call error for \"to_unix_timestamp\" at (66:151): function call error for \"parse_timestamp\" at (84:129): Invalid timestamp \"2024-06-05T08:40:02.015146042Z\": input contains invalid characters" error_type="conversion_failed" stage="processing" internal_log_rate_limit=true

[1123183721]

Just append a char ‘Z’, it's done.

.a="2024-06-05T08:40:02.015146042Z"
.timestamp=to_unix_timestamp(parse_timestamp!(.a, format: "%F T %T%.9f Z"), unit: "nanoseconds")