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

Summary

In this tutorial, you uploaded data files to Amazon S3 and then used COPY commands to load the data from the files into Amazon Redshift tables.

You loaded data using the following formats:

  • Character-delimited

  • CSV

  • Fixed-width

You used the STL_LOAD_ERRORS system table to troubleshoot load errors, and then used the REGION, MANIFEST, MAXERROR, ACCEPTINVCHARS, DATEFORMAT, and NULL AS options to resolve the errors.

You applied the following best practices for loading data:

For more information about Amazon Redshift best practices, see the following links:

Next Step

For your next step, if you haven't done so already, we recommend taking Tutorial: Tuning Table Design.

On this page: