Load troubleshooting

If you are anything like me and you read the part about splitting files and scrubbing the non-ASCII characters earlier in this chapter, you might say "what the heck, let's try it without all that" (as you probably should have). If you did, you may have already found this table all on your own. However, as with any load process, determining errors and diagnosing the cause is a critically important part of the process, so let's take a little bit of a detour into diagnosing load errors. The following are a few tables that you will be using:

  • STL_load_errors: This contains information about the particular error that was encountered during the load. This table will capture the actual column as well as the data that is causing the ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.