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.

preguntada hace 4 años358 visualizaciones
1 Respuesta
0

Was able to resolve by adding the following permissions:

awsglueservicerole
iamuserchangepassword
awsglueconsolefullaccess

respondido hace 4 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas