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

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

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