I'm trying an insert else update logic as per the tutorial: Link
The jobs has a lookup on Redshift target and source is csv. When I run the job, it fetches rows from the target lookup. But it does not pick up any records from the source and also does not fail. Its gets hung at the same state as seen in the attached screenshot.
Can anyone please help?
I tried running the job after adding tlogrow after my dilimited input, and it too could not read any rows. So I guess you are correct. I'll check my job again and report back here.