Error in Snowflake - Select Snap

Hello,

I have a parent and child pipeline where the parent pipeline sends some venue details to child pipeline. Based on the venue details, the child pipeline calls a REST GET to acquire data from vendor and loads into Snowflake table using Snowflake BULK LOAD Snap.

one of the child pipelines failed with the below mentioned error “Exception caught in HTTP_EXECUTE_THREAD, aborting HTTP request”. Normally this pipeline would take 15 to 20 secs to complete, but it took 16 mins and failed with the below error.

Any help to figure out the cause of error would be highly appreciated.

Thanks
Sravan

Hi @sravankunadi,

Do you have an error view enabled for your pipeline execute? I don’t recall exactly what error did I receive but I did get one so I enabled the error view and wrote those errors to a flat file.

image

You can try this approach and then based on the errors, we can brainstorm of a way to resolve it.