Where to get info about invalid lines in loading jobs

GSQL Loading
#1

Hi Tigergraph Team,

When debugging my loading job, I got not enough token and No ID Found error. I understand what they mean but still want to know which lines in my csv caused the error. Is there a way to change the logging level so that I can see those lines? Just like we could see the lines that failed the conditions when loading data.

Thanks

#2

@luyilun32661 This section of the documentation will walk through the different ways to debug loading jobs.

Not enough token refers to The number of lines with missing column(s)

Also when running a loading job you can specify an option to do a “dry run” which will process the data but not insert it. This way you can make sure your loading job is correctly processing the data prior to insertion. Running a Loading Job :: GSQL Language Reference