Invalid Date or Datetime Format (Amazon S3 Ingestion Issue)
- DarkLight
Invalid Date or Datetime Format (Amazon S3 Ingestion Issue)
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Issue
Some records fail to ingest date or datetime values into S3. Although the records may still be ingested, the date-related fields are skipped, leaving incomplete profile data.
Possible Cause
If the uploaded CSV file does not follow the expected date and datetime formats, the file will still be accepted, but S3 cannot ingest and parse those improperly formatted fields. As a result, those fields are ignored during ingestion.
Advanced Troubleshooting Steps
To rectify:
Validate the date and datetime formats in the CSV file based on the formats mentioned here.
Reupload the CSV file and run the ingestion process again.
Was this article helpful?