title: Snowflake Failed to cast variant value "{TIMESTAMP VALUE}" to TIMESTAMP_NTZ
body: <pre><code>copy into DB.CANONICAL.ETAIL_TABLE(MAKE, SERIAL_NUMBER, DEVICE_KEY, CONFIG_TYPE, CSF, MESSAGE_TIMESTAMP)
  from (select parse_json($1):header:make::Varchar(255),
      parse_json($1):header:serialNumber::Varchar(255),
      parse_json($1):header:deviceKey::Varchar(36),
      parse_json($1):header:configType::String, 
      parse_json($1), 
      parse_json($1):header:messageTimestamp::TIMESTAMP_NTZ(2)
  from @DB.CANONICAL.ETAIL_STAGE/firehose/)
  ON_ERROR = CONTINUE;
  </code></pre>
  <p>Above is the copy statement that I have made. But I keep getting the following error
  &quot;Failed to cast variant value &quot;2020-09-265T08:03:42.358Z&quot; to TIMESTAMP_NTZ&quot;</p>