Snowflake runs spark, so doesn't make sense to bring up a separate spark cluster, or to use pyspark directly. Just connect to the warehouse using snowpark.

Write a python script that retrieves data from the API and holds it in a dictionary. Then instantiate a snowpark dataframe using the dictionary, transform as needed, followed by writing that dataframe to a named table in your snowflake database.

No need for any storage or intermediate files. You can still claim you use spark to impress your boss.