I have SQL SERVER DATA where ii need to migrate views only to Snowflake
is there any way to create the views in FME and migarte data SQL Views to snwflake
Question
SQL SERVER Views to Create Snowflake Views
+21- Supporter
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
INNER JOIN 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.