csv - Redshift: COPY returns successful, but no data in table -

csv - Redshift: COPY returns successful, but no data in table -

i have table 20 columns want re-create redshift s3 bucket csv. run re-create command runs successfully, returns "0 lines loaded".

i've been stumped on while , i'd appreciate help. can share table schema , portion of csv, if necessary (though, i'd avoid if possible)

any thought why be?

it happened sometime me. console shows load process successful table not loaded.

can select * stl_load_errors , see if there rows corresponding load job. stl_load_errors keeps log load error detailed info exact error message , column giving error.

the job fails me due reasons delimiter problem, length of column etc.

csv amazon-web-services amazon-s3 copy amazon-redshift