C3W2 Lab Setup Error despite reboots/ latest ver

Course Q&A Data Engineering Data Storage and Queries
1

After reboot,

I am not able to recover the lab.

With or Without
source scripts/setup.sh
Setup completed successfully. All environment variables and Terraform backend configurations have been set.

Error in this section which was working earlier
review_sample_df = read_data_sample(bucket_name=BUCKET_NAME, s3_file_key=‘staging/reviews_Toys_and_Games_sample.json.gz’)

OSError: unable to access bucket: ‘de-c3w2lab1-888678946zzz-us-east-1-data-lake’ key: ‘staging/reviews_Toys_and_Games_sample.json.gz’ version: None error: An error occurred (NoSuchBucket) when calling the GetObject operation: The specified bucket does not exist

LAB ID vlpsxgkptewd

2

It recovered now. But I am still facing this error (same as solution book)

de-c3w2lab1-metadata-etl-job
de-c3w2lab1-reviews-etl-job

SUCCEEDED

but
DATABASE_NAME #de-c3w2lab1-aws-reviews
BUCKET_NAME #de-c3w2lab1-888678946400-us-east-1-data-lake
:
:
sql = “SELECT * FROM toys_reviews LIMIT 5”

df = wr.athena.read_sql_query(sql, database=DATABASE_NAME, s3_output=f’s3://{BUCKET_NAME}/athena_output/')

QueryFailed: TABLE_NOT_FOUND: line 7:3: Table ‘awsdatacatalog.de-c3w2lab1-aws-reviews.toys_reviews’ does not exist. You may need to manually clean the data at location ‘s3://de-c3w2lab1-888678946400-us-east-1-data-lake/athena_output/tables/5fdb8c26-9e77-45dc-b7fb-68732f2f8620’ before retrying. Athena will not delete data in your account.

Admins/TAs: Please help.

3

Hello @eadgc5,

Could you check the de-c3w2lab1-crawler has finished without failing after 3 minutes it should find the tables. Then you could move to part 6 queries. You should be able to find them in the data lake bucket, hope it helps