Validating Input Data

To validate the data in the Amazon S3 input files or Amazon DynamoDB table before
you actually
load the data, use the NOLOAD option with the COPY command. Use NOLOAD with the same COPY commands and options
you would use to actually load the data. NOLOAD checks the integrity of all of the
data
without loading it into the database. The NOLOAD option displays any errors that would
occur if you had attempted to load the data.

For example, if you specified the incorrect Amazon S3 path for the input file, Amazon
Redshift
would display the following error: