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 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则