I don't see how that can be the underlying issue because. 

1. the first step of the pipeline which reads from unity catalog and azure sql is just fine.

2. when I remove the enrichment logic from the second step of the and just pass the table input as its output also works just fine.

I have also seen this error masking the true error multiple times in the past.