O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required