Attemting to create new database and receiving DDLtask error

0

Hi all,

Noobie AWS user here so bear with me please.

I've attempted googling to find a solution to the error to no avail so I turn to these forum in hopes someone can let me know what Im doing wrong. Below is the error I encounter when trying to create a simple new test database in Athena.

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:User: arn:aws:iam::745583637545:user/personalemail@personalemail.com is not authorized to perform: glue:CreateDatabase on resource: arn:aws:glue:us-east-2:745583637545:catalog (Service: AmazonDataCatalog; Status Code: 400; Error Code: AccessDeniedException; Request ID: 0d26df0f-7b5c-4ad2-9aa3-2637898a03d2; Proxy: null))

This query ran against the "" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 7f556a05-76ef-4245-bc43-e8a4220c7b4d.

已提問 4 年前檢視次數 358 次
1 個回答
0

Was able to resolve by adding the following permissions:

awsglueservicerole
iamuserchangepassword
awsglueconsolefullaccess

已回答 4 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南