Capstone Project part 1: get error on Pacific time mismatch

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

When creating a post, please add:

  • Module # must be added in the tags option of the post. (ex: Module-1) Programming Assignment: Assignment 4: Capstone Project Part 1 - ETL and Data Modeling

  • Link to the classroom item you are referring to: https://www.coursera.org/l earn/data-modeling-transformation-serving/programming/3Zavj/assignment-4-capstone-project-part-1-etl-and-data-modeling

  • Description
    Gettin the following error in Transformation jobs (same error in both jobs)

ValueError: time data ‘’ does not match format ‘%Y-%m-%d’

The S3 buckets for the API and RDS extracts in the landing zone have been created with the Aus date (2005-04-06), however the current Pacific time is 7:18 pm Saturday, 5 April 2025 Pacific Time (PT).

Is that the issue? Does it mean I have to complete the lab when thedate overlaps between the 2 timezones?

The comment in the transform .py scripts for the ingest_date says
# The date when data was ingested, formatted as your current date in Pacific Time (UTC -7) to match the server’s timezone

  •    "ingest_date",*

Also, the AWS resources expired in 2hrs (not 3hrs as stated on the assignment page)

2

I think I found the issue, did not replace the placeholder in the glue.tf file. But I will need to restart from scratch since the AWS session has expired