See the records of all system tables in one place without performing any additional query, and understand how your Amazon Redshift system behaves.
System Tables in DataRow contains information about how the system is functioning. You can view these tables without having to write any SQL.Go to Support
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 Table displays the record of all of the load errors on Amazon Redshift. List all errors and review their reasons with error descriptions.
STL_FILE_SCAN table returns the files that Amazon Redshift read while loading data via the COPY command. List all files and see the loading times of each in detail.
STL_S3_CLIENT_ERROR records errors encountered by a slice while loading a file from Amazon S3. List each error with their error reasons.