Matillion not consider as ERROR When Snowflake Stored Proc Failed

We mainly designed our pipeline using snowflake Stored Procedure. When the Stored procedure actually fails but matillion not consider that as Failure and it's pass through the next component.

 

Can someone experienced or resolved this problem would help much

 

Thanks in advance

Can you share an example for this to understand it better?

 

for one of my stored proc i was getting error over matillion.