If a File Ingest upload returns a failure message instead of a success message, it’s usually caused by a formatting issue in the file. Check the following, depending on how you’re uploading.
When uploading to a new table
- Make sure your CSV is encoded as UTF-8.
- Make sure there are no blank columns in the file.
When inserting into an existing table
A failure here is almost always because the upload file has a different number of columns to the destination table. Make sure there are no stray values in extra columns — it can help to delete everything in all columns to the right of your dataset before uploading.
Tip: as a general precaution, back up an existing table before inserting into it, so you can revert if needed.
If this hasn’t resolved your issue, raise a ticket with Kleene Support for further assistance.