Procedure
-
Press F6 to execute the Job.
As shown above, the Job is executed successfully and eight rows are inserted into the target table.
You can then create and run another Job to retrieve data from the target table by using the tSnowflakeInput component and the tLogRow component. You will find that the aggregated data will be displayed on the console as shown in below screenshot.
For more information about how to retrieve data from Snowflake, see the example Writing data into and reading data from a Snowflake table.