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