When creating a post, please add:
Hello @ConnorCSB
I tried the lab right now. This error pops up if we run the cells twice. The first time, the database is created successfully, and the second time it says database already exists. Are you getting this error on your first try on the cell?
If you get this on your first try, you can manually delete the tables from S3. Search for S3 in the AWS Console, open bucket de-c3w2a1-...-us-east-1-data-lake, go to each of the folders named athena_output and presentation_zone, and delete the folder named ratings in each of these two folders.
Hello @Amir_Zare ended up deleting all files and restarting the lab. Am now getting this error when running the glue job (de-c3w2a1-ratings-transformation-job) for section 4.3.3
All other glue jobs were successful.
Error: An error occurred while calling o197.create. The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 9PG4REG4YFFMN5PW, Extended Request ID: BXVBpvNxRo007BITMtqP9S6h2ak5Brcp/0hkI9KsqI0j3OIot06r0LB4rko9/7WGL2/ps8smx314yTYnEg8l+Gk8Wt8elknmAIBvc/b4tO4=)
@ConnorCSB some necessary files might have been deleted during the process. I suggest you refresh your lab and start fresh. You can request a lab refresh via this form.
@Amir_Zare Done! Will try again in a few days and update here if I do/don’t any errors. Thanks for your help.
Passed the assignment thanks again @Amir_Zare! On to week 3 of the module.
