I supposed to receive only number in this field. When I try loading to redshift, I see error below. So decided to separate the non numeric records to correct them with above pipeline. It process but not values in final file. To answer your question, I am seeing data like below after union json preview.
Redshift bulk load error view message
Error loading document 5658362 : Column age : Error code 1207 : "Invalid digit, Value ‘/’, Pos 2, Type: Integer ";Error loading document 5658364 : Column age : Error code 1207 : "Invalid digit, Value ‘/’, Pos 2, Type: Integer ";Error loading document 5658366 : Column age : Error code 1207 : "Invalid digit, Value ‘/’, Pos 2, Type: Integer ";Error loading document 5658368 : Column age : Error code 1207 : "Invalid digit, Value ‘/’, Pos 2, Type: Integer ";Error loading document 5658370 : Column age : Error code 1207 : "Invalid digit, Value ‘/’, Pos 2, Type: Integer ";
