Snowflake only really offers SQL (with UDFs) to do data transforms. Spark offers SQL, but also code-based solutions (Python, Scala, Java) that can be used to scale things like ML pipelines and non-SQL transforms.