What you need to do is get the script which creates the view, then execute that on Snowflake
The sys.modules table contains the view script as text.
In a SQLCreator
SELECT o.name, m.definition
FROM sys.sql_modules m
INNERJOIN sys.objects o ON m.object_id = o.object_id
WHERE o.type = 'V'AND o.name = 'YourViewName'
That'll get you the current SQL Server view scripts.
Then, any syntax differences between SQL and Snowflake, changes in database name, table names, you *should* be able to swap in with Regex with a StringReplacer or two assuming it's not too different.
Add a Text File FeatureWriter to back up all scripts.
Then SQLExecutor to create the views on Snowflake.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.