System Tables in DataRow contain information about how the system is functioning. You can view these tables without querying your database.
The following Amazon Redshift system tables views in DataRow can be helpful in troubleshooting data load issues:
- STL_LOAD_ERRORS to discover the errors that occurred during specific loads.
- STL_FILE_SCAN to view load times for specific files or to see if a specific file was even read.
- STL_S3CLIENT_ERROR to find details for errors encountered while transferring data from Amazon S3.