You can view statistics for each job to see the number of rows processed and the job state.
The job can have one of the following states:
•Success. The Secure Agent applied all rows of insert, update, and delete operations.
•Warning. The Secure Agent rejected one or more rows. The Rows Processed field in the My Jobs page reflects the total number of rows that the Secure Agent processed.
•Failed. The job did not complete because it encountered errors.
The following image shows the My Jobs page that shows the details of the state and the number of processed rows of a Snowflake Data Cloud 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 Data Cloud task:
You can 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 Data Cloud write operations:
Constraint violation
In insert, update, or delete operation scenarios where the Secure Agent rejects rows due to a constraint violation, a warning appears in the Job Properties page. You can download the session log to view the target statistics.
Can't find a match
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.
Non-unique match
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.
Success rows not updated
The number of success rows for the target object in the Job Properties page is not updated and remains the same as the number of incoming rows. For example, while writing 5 records to the target, if two records are rejected, the number of success rows still reflects as 5.
