SNOW-830895: Can I keep async queries running when closing session?

[hota911]

Hi,

I'd like to use AsyncJob to unload data to S3 asynchronously.
Our service may be killed any time and session can be closed.
It seems all queries are canceled when the session is closed

snowpark-java-scala/src/main/scala/com/snowflake/snowpark/Session.scala

Line 1197 in b5679a3

cancelAll()

Is there way to run async job and keep it even when session is closed?

Thank you

[sfc-gh-jfreeberg]

Hi @hota911 -- Yes when the .close() method is called, the jobs will be killed... so don't call the .close() method. The server won't kill the jobs if the client disconnects.

Let me know if you have any other questions!

CC @sfc-gh-bli