It looks like it is possible now using sql stored procedures: https://www.snowflake.com/en/engineering-blog/sql-stored-procedures-async-execution/