Verify data files before and after a load - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Verify data files before and after a load

Before you load data from Amazon S3, first verify that your Amazon S3 bucket contains all the correct files, and only those files. For more information, see Verifying that the correct files are present in your bucket.

After the load operation is complete, query the STL_LOAD_COMMITS system table to verify that the expected files were loaded. For more information, see Verifying that the data loaded correctly.