Invalid Date or Datetime Format (Amazon S3 Ingestion Issue)
    • Dark
      Light

    Invalid Date or Datetime Format (Amazon S3 Ingestion Issue)

    • Dark
      Light

    Article summary

    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:

    1. Validate the date and datetime formats in the CSV file based on the formats mentioned here.

    2. Reupload the CSV file and run the ingestion process again.


    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence