C4W4-Capstone Project Lab 1 - Terraform - Glue Catalog Database Creation Error

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

Hi, I am trying to complete lab and when I run the terraform for the serving zone it keeps crashing and showing me below error.

Error: creating Glue Catalog Database (de_c4w4a1_silver_db): operation error Glue: CreateDatabase, https response error StatusCode: 400, RequestID: 84a1b539-b2d4-4b22-822d-b97f780cf856, 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” {

2

I am facing the same issue, and after crashing terraform cannot run again because the infrastructure cannot be deleted.

3

Hello @knvsiddarth , @calvinwy,

Sorry for the inconvenience but the issue could be Insufficient Lake Formation Permissions. Could you try deleting this database with this command aws glue delete-database --name de_c4w4a1_silver_db and see if you get permissions error. The solution is to submit this form and choose Insufficient lake formation from the options. Note, it takes 2 business days to complete since its a manual process performed by the engineers. Thank you

4

Thank you @Georgios, I will try and proceed with the form if its doesn’t work.

5

I am still facing issue with the lab, I went ahead and submitted the form to reset the lab.

Thank you

1 Like