There isn't a direct way to kill Snowflake queries using the Spark connector.

you can retrieve the last query ID in Spark to manage it outside Spark, later you can kill that with CALL SYSTEM$CANCEL_QUERY('<query_id>');