Connecting to S3

In the previous chapter, we covered the tools and installed the EMS SQL Manager product that you will need to access the database. As we are now getting ready to load data, you need to have a way to get the data from your local environment into the database. Shortly, I will explain why insert into will pose problems. We will be using the copy command to move data into the database, which will be reading from S3. As with most things we have discussed to this point with regard to third-party products, you again have options; particularly as you are now going to connect to Amazon S3, which has been around for a while. If you don't want to use the Amazon S3 managing service, the other two solutions that I have found, which are both ...

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.