You can choose to overwrite the existing target files.
Select the
Overwrite File(s) If Exists
option in the Amazon S3 V2 target advanced properties to overwrite the existing files. By default, the value of the
Overwrite File(s) If Exists
check box is true.
If you select the
Overwrite File(s) If Exists
option, the Secure Agent deletes the existing files with same file name as the file that you overwrite, and creates a new file with the same file name in the target directory.
The Secure Agent also deletes all files and folders that have the same prefix as the file names created at design time. This is applicable for Avro, ORC, and Parquet files.
If you do not select the
Overwrite File(s) If Exists
option, the Secure Agent does not delete the existing files in the target directory. The Secure Agent adds time stamp at the end of each target file name in the following format:
YYYYMMDD_HHMMSS_millisecond
. For example, the Secure Agent renames the target file name in the following format: