Can't parse '"2020-06-12T19:03:18+00:00"' as Timestamp

[jcheung0]

I need help understanding what timestamp format is supported by the connector that supports this format

I can parse the timestamp format if I run it through this through the snowflake worksheet but when I use the format inside the file_format it's still unable to parse it a little guidance would be great

SELECT TO_TIMESTAMP('2020-06-12T19:03:18+00:00', 'YYYY-MM-DD"T"HH24:MI:SS+"00:00"');

thank you

[Samira-El]

Hey, we don't really use any explicit format, but we have the parameter TIMESTAMP_INPUT_FORMAT set to AUTO at the account level.
https://docs.snowflake.com/en/sql-reference/parameters.html#timestamp-input-format