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.

gefragt vor 4 Jahren358 Aufrufe
1 Antwort
0

Was able to resolve by adding the following permissions:

awsglueservicerole
iamuserchangepassword
awsglueconsolefullaccess

beantwortet vor 4 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen