Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Verify Data Files Before and After a Load

When you load data from Amazon S3, first upload your files to your Amazon S3 bucket, then verify that the 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 Was Loaded Correctly.