Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Viewing job statistics

Viewing job statistics

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:
You can view the number of processed rows for the jobs:
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 view the details of error and success rows for the selected job:
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.

0 COMMENTS

We’d like to hear from you!