Error when query on database in glue catalog

Question

Tried in CLI and console mode, when I clicked on a database in dsta catalog, getting below error

AccessDeniedException: Please migrate your catalog to enable access to this database

This Athena catalog was working before fine, not sure what changed internally. Any suggestions would be highly appreciated

Accepted Answer

Hello,

This error generally occurs when an existing Athena data catalog has not yet been migrated to a new Glue Data Catalog which you might verify through Cloudtrail if anyone within your org performed the changes.

Further, performing the following AWS CLI command on the account that housing the database, the issue can be resolved, [import the catalog](https://docs.aws.amazon.com/cli/latest/reference/glue/import-catalog-to-glue.html)

```
aws glue import-catalog-to-glue --catalog-id  --region us-east-1
```

[To check the status](https://docs.aws.amazon.com/cli/latest/reference/glue/get-catalog-import-status.html),

```
aws glue get-catalog-import-status --catalog-id  --region us-east-1
```

Error when query on database in glue catalog

相关内容