Execute a Snowflake Stored Procedure Asynchronously

Matillion ETL
1

Is there a way to call a stored procedure in Snowflake asynchronously from Matillion?

currently, we are calling from either the SQL script ot the Jython Script.

 

But, in both the cases, the Matillion component waits for the command(stored procedure) to complete.

 

The Snowflake procedure is a time intensive one and hence the job keeps on running in Matillion.

 

we Only need to call the Stored procedure and thats it.

Is there any way to do this ?

2

Hi @pratikdatta459​

Snowflake itself has no concept of asynchronous execution. A guide on how to can be seen here: https://www.matillion.com/resources/blog/using-stored-procedures-with-matillion

Hope this helps,

Chika