I am also facing the same issue with the new snowflake v2 connector. Did you find any solution. The frustrating part is that the lookup activity works 90% of the scheduled run. The error happens randomly and not able to reproduce the issue. We have around 40 pipelines and the lookup activity is widely used in all the pipelines. The previous snowflake connector was working without any such issues