C4W4 Part 1 | Struggling with Transformation Stage (4.2) – Glue Job Issues

I’ve been working on Part 1 of the Capstone project for the past three days but can’t get past the 4.2 Transformation Zone. Despite resetting the lab environment, I’m still unable to get Terraform to generate the transform Glue jobs.

Initially, the error said the metadata was missing, but now it’s complaining that the schemas already exist. I tried deleting the transform connections, but it prompts for a “connection name” and doesn’t proceed.

At first, I was able to run the transform Glue jobs, though they kept failing. After restarting the project, I haven’t been able to run them at all. The extraction jobs work fine every time—it’s only the transform jobs that are causing issues.

Screenshots attached for reference:

Any help would be greatly appreciated!

FINALLY! Finished Capstone Part 1. Moderator, please delete this post