Home » Snowflake

Bookmark · Report · More actions.. Lock comments · Pin thread

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

Post Comment

nVector07-Sep-20

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

ReplyMore..ReportDelete

vinaygupta-net-gmail-com08-Sep-20

Thanks for valuable suggestions.

ReplyMore..ReportDelete

weldend13-Mar-24

Take a look at https://roboquery.com/app/convert-Microsoft_SQL_Server-to-snowflake

ReplyMore..ReportDelete