Target statistics of processed rows in Snowflake write operations
When you run an insert, update, or delete operation, and the Secure Agent successfully applies all rows to the target and does not reject any rows, the state of the task in the My Jobs page reflects as Success. If the Secure Agent rejects even one row, the status reflects as Warning. In this case, the Rows Processed field in the My Jobs page reflects the total number of rows that the Secure Agent processed.
The following image shows the My Jobs page that shows the details of the state and the number of processed rows of a Snowflake job:
To view how many among the processed rows were a success and how many resulted in an error, select the specific instance name and view the Results section. You can view the number of success rows and error rows.
The following image shows the details of the Snowflake task:
You can also download the session log to get details of the number of output rows, affected rows, applied rows, and rejected rows.
You might also encounter the following scenarios of target statistics for Snowflake write operations:
•In insert, update, or delete operation scenarios where the Secure Agent rejects rows due to a constraint violation, the mapping fails. In this case, see the My Jobs page to view the total number of processed rows for that job and the session log for error messages.
•In update or delete operation scenarios where the Secure Agent does not find a match for some records, that number does not reflect in the My Jobs page and the session log.For example, if there are 5 input rows and the Secure Agent updates only 4 target rows, the status of the number of processed rows stills reflects as 5. This issue occurs when Snowflake does not return an error message for rejected rows.
•In update or delete operation scenarios where the Secure Agent updates or deletes more rows because of a non-unique match, that actual number of updated or deleted records does not reflect both in the My Jobs page and in the session log. For example, if there were 5 input records and the Secure Agent updated 10 target rows, the My Jobs page reflects only 5 processed rows.
