I have set up snow pipe and it reads from S3 (JSON File) and for some reason it has paused suddenly, when I queried COPY_HISTORY table it has error saying "NULL result in a non-nullable column"
My JSon File :only the first Key-value pair is not nullable, rest can be null.
I have checked the entire JSON file, but couldnt find where it is null. Can some one tell me how to pin point the exact data where It is failng? Thanks
question from:https://stackoverflow.com/questions/65907140/snowpipe-paused-null-result-in-a-non-nullable-colum