S3 access denied when inserting records into a new table created in Athena

Question

I created a simple table with one column in Athena:

CREATE EXTERNAL TABLE IF NOT EXISTS all_event_types(
  event_subtype string)
LOCATION 's3://table-data-location/'

Then insert records retrieved from another table:
insert into all_event_types (
		select distinct event_subtype
		from view_house_cs_conversions
	)
The view_house_cs_conversions has less than 20 unique values of event_subtype.

Athena reported the following error after running for more than a few minutes:

Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request ID: MZAFPHBZPHMCPMKG; S3 Extended Request ID: PrYu9ZWEFToxZxX8vcxrxXuq+cBkOUiJnWdgelfyfPmYOnpbyCpoC6UvvQFo+VTPdWPGjnjQ2+I=; Proxy: null).

What causes this?

Accepted Answer

Do either of these use cases fit your situation?  https://aws.amazon.com/premiumsupport/knowledge-center/access-denied-athena/

S3 access denied when inserting records into a new table created in Athena

Relevanter Inhalt