Migrating stored procedures from Teradata BTEQ to Snowflake

Question

I'm trying to migrate stored procedures and related queries from Teradata BTEQ to Snowflake schema. But as snowflake doesn't support stored procedure, is there any way to get this done ?

Answer 1

JavaScript Stored Procedures are supported as of May 2019.

Other resources for migration:

• Teradata to Snowflake Migration Guide
• Roboquery
• https://www.mobilize.net/snowflake (unfortunately converts to Python instead of JavaScript)

Answer 2

The Stored Procedures logic might be implemented through a combination of Python scripts (running from a client computer) and UDFs written in JavaScript or SQL within Snowflake.

Answer 3

Stored procedures are now supported in Snowflake (in Javascript) as below

https://docs.snowflake.net/manuals/sql-reference/stored-procedures.html