PutDatabaseRecord fields don't map database colums

Alexandros — Wed, 15 Jan 2020 21:21:39 GMT

Hi, im trying to upload a CSV to a RedShift database using GetFile->PutDatabaseRecord

i'm getting this error:

PutDatabaseRecord:

CSVReader (my file got headers, this way and not hardcoding the schema makes everything more easily scalable):

Null string: NULL

CSV:

A,B,C,D,E,F,G,H,I
2020-01-15,AX,COD245,NO,PASS,R,,,
2020-01-15,AX,COD235,YES,PASS,R,,,

Table with same fields names.

Any idea what i'm doing wrong? Is there any way to look for the query it's making, that will make this more easy to debug.

Thank you!

Re: PutDatabaseRecord fields don't map database colums

Alexandros — Wed, 15 Jan 2020 21:36:51 GMT

Solved, PutDatabaseRecord gives you mapping error if the table doesn't exists or if you don't have permissions, hours fighting against the columns names and it was a database problem.

question Re: PutDatabaseRecord fields don't map database colums in Support Questions

PutDatabaseRecord fields don't map database colums

Re: PutDatabaseRecord fields don't map database colums