Add another data source

Add lookup table for Taxi Pickup Zone

  1. Return to the Visual tab
  2. Click on the Sources icon, choose Amazom S3
  3. In the Data source – S3 bucket node, the specify the following information:
  • Node properties tab, Name - Pickup Zone Lookup
  • Data source properties tab, Database – nyctaxi_db
  • Data source properties tab, Table – raw_taxi_zone_lookup

Glue Jobs

  1. Remember to Save your work.

Modify column names of Pickup Taxi Zone Lookup table

  1. Make sure the Amazon S3 - Pickup Zone Lookup node is selected.
  2. Click on the Transform icon, choose Change Schema.
  3. Specify the following information:

  • Node properties tab, Name - Change Schema - Pickup Zone Lookup

  • Transform tab, modify the target key

    • locationid to pu_location_id
    • borough to pu_borough
    • zone to pu_zone
    • service_zone to pu_service_zone

    Glue Jobs

    Glue Jobs

  1. Remember to Save your work.