Getting Error while running code

AI Discussions
1

df_count_by_sentiment = wr.athena.read_sql_query(
sql=statement_count_by_sentiment,
database=database_name
)

print(df_count_by_sentiment)

QueryFailed: com.amazonaws.services.s3.model.AmazonS3Exception: The specified bucket does not exist (Service: Amazon S3; Status Code: 404; Error Code: NoSuchBucket; Request ID: SF26C04GJEQRZT5B; S3 Extended Request ID: 1N+d3Ezykzz3uhOw6ir9JeSrGPo8apkIe817UOHIaVJzd5y+C45AhLVtFXseFPH/7UKKVIJ7ens=; Proxy: null), S3 Extended Request ID: 1N+d3Ezykzz3uhOw6ir9JeSrGPo8apkIe817UOHIaVJzd5y+C45AhLVtFXseFPH/7UKKVIJ7ens= (Path: s3://aws-athena-query-results-424865397293-us-east-1/temp_table_7d6dc567f6b84f638000f7410a45c765). You may need to manually clean the data at location ‘s3://aws-athena-query-results-424865397293-us-east-1/tables/7fb6b40f-e781-4be6-a4f0-3350c2c14f7c’ before retrying. Athena will not delete data in your account.

2

Hi, Kripa.

You have posted this under General Discussion, not under a specific course. I’m pretty familiar with all the assignment in the DLS specialization and I don’t recognize any of the variable names you show, so pretty clearly it’s from some other course.

You’d have better luck getting an answer if you edit the title (use the little “edit pencil”) and move this to the appropriate Specialization and Course, so that the mentors for that course will be more likely to see it. Or you can just reply and say where you want it to go and I can move it for you.

3

Hi All,

This issue is from Analyze Datasets and Train ML Models using AutoML week1.

Pls move this to proper platform so that this issue can be fixed.

4

Sorry, but I am not familiar with the course you are referring to, so I do not recognize the name of that lecture. Please be more specific about the name of the Specialization and Course that this question is about.