Creating an S3 sample file

In this section, we are going to create a simple S3 bucket that stores a CSV file. Let’s follow the instructions step by step:

1. Open the AWS S3 service.
2. Click the Create bucket button:

Figure 11.2 – Create bucket

3. Give a unique bucket name and click Create bucket at the end of the panel:

Figure 11.3 – Input bucket

The bucket is created:

Figure 11.4 – Bucket list

4. Create an addresses.csv file on your computer with the following content and upload it to the S3 bucket. Please save the file in the UTF-8 format; otherwise, there might be an issue in some Glue versions:

   id,location_id,address_1,city,state_province
   1,1,2600 Middlefield Road,Redwood City,CA
   2,2,24 Second Avenue,San Mateo,CA
   3,3,24 Second Avenue,San Mateo,CA
   4,4,24 Second Avenue,San Mateo,CA
   5,5,24 Second Avenue,San Mateo,CA
   6,6,800 Middle Avenue,Menlo Park...