Facing the same problem I used the following:

sfOptions = {

"sfURL" : "<account>.snowflakecomputing.com",

"sfAccount" : "<account>",

"sfUser" : "<user>",

"sfPassword" : "***",

"sfDatabase" : "<database>",

"sfSchema" : "<schema>",

"sfWarehouse" : "<warehouse>",

"truncate_table" : "ON",

"usestagingtable" : "OFF",

}

https://community.snowflake.com/s/article/How-to-Load-Data-in-Spark-with-Overwrite-mode-without-Chan...