cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Does spark utilise a temporary stage when writing to snowflake? How does that work?

mick042
New Contributor III

Folks , when I want to push data to snowflake I need to use a stage for files before copying data over. However, when I utilise the net.snowflake.spark.snowflake.Utils library and do a spark.write as in...

spark.read.format("csv")
  .option("header", "true")
  .load("/mydata.data")
  .write.format("snowflake")
  .options(options).mode("append").option("dbtable", "mytable").save()

I can write directly into snowflake without specifying a stage etc.

Just wondering how this works so I can preempt any security problems etc.

1 REPLY 1

mick042
New Contributor III

Yes it uses a temporary stage. should have just looked in snowflake history

image

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.