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?
It is about IAM: The default S3 bucket to store the table data (not schema) does not allow me to write data. I created a new bucket and can write data into the table now.
Thanks a lot for pointing this out.