This is the error
module.transform_job.aws_glue_catalog_database.transform_db: Creating…
╷
│ Error: creating Glue Catalog Database (de_c4w4a1_silver_db): operation error Glue: CreateDatabase, https response error StatusCode: 400, RequestID: 50ecb1e4-62e5-427f-aae8-59af333d1da6, AlreadyExistsException: Database already exists.
│
│ with module.transform_job.aws_glue_catalog_database.transform_db,
│ on modules/transform_job/glue.tf line 2, in resource “aws_glue_catalog_database” “transform_db”:
│ 2: resource “aws_glue_catalog_database” “transform_db” {
Already checked or tried:
- AWS glue, no such database,
- run aws glue delete-database --name de_c4w4a1_silver_db
An error occurred (AccessDeniedException) when calling the DeleteDatabase operation: Insufficient Lake Formation permission(s): Required Drop on de_c4w4a1_silver_db
3) 3rd times doing the lab, checked every single steps multi-times already
4) Lake formation on AWS has no permission to view
Anyone has idea or hint to resolve this