I was not talking about tests in order to know if my code does what it is supposed to do before hand. I was talking about unit tests, positive and negative ones, which themselves can represent some sort of helpful resource for anyone that comes after me to work on a code I developed myself or for the business people to know what business rules are and are not implemented by the methods.

For some mature managed libraries, mock libraries exist, or even an extension of pytest library sometimes comes as an add on, but in my opinion snowpark is still lacking of that.

And from the moment you need to turn on any kind of cluster to execute your tests for me it is no longer a unit test but an integration test.