Load error reference

If any errors occur while loading data from a file, query the STL_LOAD_ERRORS table to identify the error and determine the possible explanation. The following table lists all error codes that might occur during data loads:

Load error codes

Error code	Description
1200	Unknown parse error. Contact support.
1201	Field delimiter was not found in the input file.
1202	Input data had more columns than were defined in the DDL.
1203	Input data had fewer columns than were defined in the DDL.
1204	Input data exceeded the acceptable range for the data type.
1205	Date format is not valid. See DATEFORMAT and TIMEFORMAT strings for valid formats.
1206	Timestamp format is not valid. See DATEFORMAT and TIMEFORMAT strings for valid formats.
1207	Data contained a value outside of the expected range of 0-9.
1208	FLOAT data type format error.
1209	DECIMAL data type format error.
1210	BOOLEAN data type format error.
1211	Input line contained no data.
1212	Load file was not found.
1213	A field specified as NOT NULL contained no data.
1214	Delimiter not found.
1215	CHAR field error.
1216	Input line is not valid.
1217	Identity column value is not valid.
1218	When using NULL AS '\0', a field containing a null terminator (NUL, or UTF-8 0000) contained more than one byte.
1219	UTF-8 hexadecimal contains an invalid digit.
1220	String contains invalid or unsupported UTF-8 code points.
1221	Encoding of the file is not the same as that specified in the COPY command.
1222	Integer value overflow error.
1223	Data type not valid.
1224	Input data not well formed JSON format or super data type.
8001	COPY with MANIFEST parameter requires full path of an Amazon S3 object.
9005	Invalid end key specified.