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.

asked 3 years ago350 views
1 Answer
0

Was able to resolve by adding the following permissions:

awsglueservicerole
iamuserchangepassword
awsglueconsolefullaccess

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions