07 Sep 20 · vinaygupta-net-gmail-com · #Snowflake ·   Bookmark   ×

How to migrate MS SQL Existing Stored Procedure on Snowflake cloud ?

How to migrate MS SQL Existing Stored Procedure on Snowflake cloud ?

I have number of complex Stored Procedure for reporting purpose, So I am wondering does snowflake support MS SQL Stored Procedure that we have. Any one can have Idea for the same ? as per my understanding it's doesn't return ResultSet at this moment.

vinaygupta-net-gmail-com

posted on 07 Sep 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




  • Snowflake supports Javascript based procedures. So your MS-SQL procedures will not work as it is. You need to manually convert them to Javascript syntax detailed on their website
  • And yes, if you are returning result sets, you may want to follow a hybrid approach - where you write the results to a table and then issue a separate select query outside of the stored procedure

vinaygupta-net-gmail-com

Thanks for valuable suggestions.


Community Software by Hittly