Currently, I am trying to migrate tables from SQL Server to Snowflake in Jitterbit Cloud Studio.

For that, I would like to build a Jitterbit process with operations like this:

[Operation 1: Select all table names from SQL Server] {for each table name, call Operation 2} -> [Operation 2: (Select the metadata of the table from SQL Server) -> (Generate create table SQL query for Snowflake) -> (Execute the create table SQL query)] -> [Operation 3: (Select all data from the SQL Server table) -> (Insert into the Snowflake table)]

I am now trying to build Operation 3 which needs to execute a dynamic query to select fields from the SQL Server table and then insert into the Snowflake table using dynamic SQL. I need to use dynamic SQL because the fields I will select and insert depend on the table I am processing.

Could someone please give me any pointers on how to make this workflow dynamic?