invalid identifier '"version"'
This appears to have started in the newest version of the package. The query that gets run is
SELECT max("version") FROM "_yoyo_version"
And I don't think that Snowflake likes the quotes around "version". The query runs properly for me once you remove the quotes.
Snowflake claims to support quoted identifiers, so I'm surprised this doesn't work. But I don't have access to a snowflake instance to test it myself. If you have access, would you be willing to put a patch together?