@omiaye - The Snowflake Insert snap is a transactional snap and will output one document for every document sent to it (assuming successful insert to the database). So if you have 700 records in, you get 700 records out. In your first example, this means the Snowflake execute will be called 700 times, so if it is a query that is returning 700 records, then you get the 700 * 700 documents out (49k).
In the second example, you are using the Tail snap, which by definition: ..."reads the specified number of documents from the end of the input stream." In other words, if you have 700 documents in and set the "Number of documents" in the Tail snap to 1 (default), it returns only the last record. This is a great way to wait for all upstream documents to be delivered before continuing to the next step... in your case, the Snowflake Execute snap.
Hope this helps!
