Hi @Vivaan Shresth ,
Thanks for reaching Microsoft Q&A Platform.
Regarding SSRS stored procedures migration to Snowflake, you may post the question in Snowflake community to be answered by Community Experts at Snowflake forum
However, as per the question you have mentioned stored procedure migration from MS SQL stored procedures to SNOWFLAKE Data source, I could find few articles which might be helpful:
how-to-migrate-mysql-data-to-snowflake-without-using-any-thirdparty-tool
a-guide-to-migrate-ssrs-source-to-snowflake-e51b62165c5a