Validate transformed data

Validate transformed data

  1. Go to Athena console.

  2. Select Preview table to examine the data in yellow_tripdata table.

  3. On the Query editor page, run the following queries to examine the data.

    SELECT COUNT(*) "Count"
FROM   yellow_tripdata;

    SELECT DATE_TRUNC('month', pickup_datetime) "Period", 
    COUNT(*) "Total Records"
FROM   yellow_tripdata
GROUP BY DATE_TRUNC('month', pickup_datetime)
ORDER BY 1;