The scripts below can be used on both Amazon Redshift and Actian Matrix (Paraccel) for operations related to COPY commands.
Number of rows inserted by each succesful COPY command
Troubleshooting load errors
The following four tables can come in handy while troubleshooting load errors via the COPY command:
Some useful queries that make use of the above tables are:
1. Errors in unsuccessful COPY commands for the current day
2. Combine stl_load_error with stl_tbl_perm to get the table name