I have a very similar situation when we execute a stored procedure in snowflake but the result does not appears in Data factory. For me it happens in a Copy activity in a ForEach loop.
Did you find any solution?
Reasons:
Blacklisted phrase (1.5): any solution
RegEx Blacklisted phrase (3): Did you find any solution