Executing the Job

As shown above, Talend Studio executes the Job successfully and inserts eight rows 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 are displayed on the console as shown in below screenshot.

You can also check the SQL statement generated by retrieving the value of the Query variable of the tELTOutput component using a tWarn component, as shown in the following two figures.

For more information about how to retrieve data from Snowflake, see Writing data into and reading data from a Snowflake table.