Trouble with Timestamps/DateTimes in Snowflake Source

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an issue with timestamps/datetimes in a Snowflake source when using the Snowflake connector v0.3.3. The field in Snowflake is TIMESTAMP_NTZ(9) with the value 2024-05-22 02:26:35, but Airbyte lists it as datetime in the source schema. The error message indicates a parsing issue with the timestamp format.


Question

Having trouble with timestamps/datetimes in a snowflake source.
• snowflake connector v0.3.3
• snowflake the field is TIMESTAMP_NTZ(9) with the value 2024-05-22 02:26:35.
• Airbyte lists it as datetime in the source schema.
• "CREATED_AT":{"format":"date-time","airbyte_type":"timestamp_without_timezone","type":"string"}
• Airbyte parses to 2024-05-22T02:26:35
source > ERROR i.a.c.i.b.AirbyteExceptionHandler(uncaughtException):64 Something went wrong in the connector. See the logs for more details. java.time.format.DateTimeParseException: Text '2024-05-22 02:26:35' could not be parsed: Unable to obtain OffsetDateTime from TemporalAccessor: {},ISO resolved to 2024-05-22T02:26:35 of type java.time.format.Parsed
This doesn’t happen with all fields with this datatype and format in snowflake.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["timestamps-datetimes", "snowflake-connector", "datetime", "airbyte-schema", "parsing-issue", "java-time-format"]