Verify data files before and after a load - Amazon Redshift

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.