The Secure Agent generates success and error files after you run a session. Success and error files are .csv files that contain row-level details. The Hosted Agent does not create success and error files after you run a session.
The Secure Agent generates a success file after you run a session. The success file contains an entry for each record that successfully writes into Amazon Redshift. Each entry contains the values that are written for all the fields of the record. Use this file to understand the data that the Secure Agent writes to the Amazon S3 bucket and then to the Amazon Redshift target.
The error file contains an entry for each data error. Each entry in the file contains the values for all fields of the record and the error message. Use the error file to understand why the Secure Agent does not write data to the Amazon Redshift target.
The Secure Agent does not overwrite success or error files. Access the error rows files and success rows files directly from the directories where they are generated.
You can manually delete the files that you no longer need.
Consider the following guidelines when you configure the session properties for success files:
By default, a success rows file is generated in the following directory: