Hi I got the error here anyone know what is the problem 5 Presentation zone
5.2. where I have to run code to create an Iceberg Table based on a query using Athena and the curated_zone tables
Hello @T_BOY
I tried the lab a few days ago. 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.
and I think, It maybe because of section 4.3.3 I failed on deploy the glue jobs on glue_csv_transform_job but I try to rerun the code BTW it still failed anyway
Hello again @T_BOY
The job that is failing uses the script in de_c3w2a1_batch_transform.py. I suggest you check your completion of this file and make sure that you are doing everything correct. You have completed this file in step 4.1.1.