# C4W4 Terraforms Crashing Assignment 5

**URL:** <https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453>\
**Category:** Data Modeling, Transformation, and Serving\
**Tags:** week-module-4, coursera-platform\
**Created:** [June 18, 2025, 6:51am UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453 "2025-06-18T06:51:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ANAND\_KASHYAP](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@ANAND\_KASHYAP](https://community.deeplearning.ai/u/ANAND_KASHYAP)\
**Post date:** [June 18, 2025, 6:51am UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453/1 "2025-06-18T06:51:25Z")

</div>

When i run:-

terraform apply -target=module.transform\_job

i log the following error:-

Error: creating Glue Catalog Database (de\_c4w4a2\_silver\_db): operation error Glue: CreateDatabase, https response error StatusCode: 400, RequestID: ea856439-6b56-43a7-958e-039d620d7187, AlreadyExistsException: Database already exists.

with module.transform\_job.aws\_glue\_catalog\_database.transform\_db,  
on modules/transform\_job/glue.tf line 1, in resource “aws\_glue\_catalog\_database” “transform\_db”:  
1: resource “aws\_glue\_catalog\_database” “transform\_db” {

But the problem is this database does not exist in the glue.

So I checked using the following:-

aws glue get-database --name de\_c4w4a2\_silver\_db

which yielded this error:-

and got an error:- An error occurred (AccessDeniedException) when calling the GetDatabase operation: Insufficient Lake Formation permission(s) on de\_c4w4a2\_silver\_db

I am unable to grant this database the required permission please help.

My coursera subscription will expire in 4 days I really don’t want to buy another subscription just to complete one last assignment considering the course is already 99% done.

---

<div class="post-metadata">

**Author:** ![benjamintabaresjr](https://sea1.discourse-cdn.com/dlai/user_avatar/community.deeplearning.ai/benjamintabaresjr/32/112069_2.png) [@benjamintabaresjr](https://community.deeplearning.ai/u/benjamintabaresjr)\
**Post date:** [June 18, 2025, 12:55pm UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453/2 "2025-06-18T12:55:57Z")

</div>

Hi,

Kindly request a lab refresh using this [form](https://forms.gle/S2gLNzQXZuMhBGwL6).

You’ll receive a notification once it’s completed. Thanks!

---

<div class="post-metadata">

**Author:** ![ANAND\_KASHYAP](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@ANAND\_KASHYAP](https://community.deeplearning.ai/u/ANAND_KASHYAP)\
**Post date:** [June 19, 2025, 4:45am UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453/4 "2025-06-19T04:45:19Z")

</div>

I applied for the refresh and my lab did get refreshed and all three terraform commands now work but terraform apply -target=module.transform\_job shows the following results:-

No changes. Your infrastructure matches the configuration.

Terraform has compared your real infrastructure against your configuration and found no differences, so no changes are needed.  
╷  
│ Warning: Resource targeting is in effect  
│  
│ You are creating a plan with the -target option, which means that the result of this plan may not represent all of the changes requested by  
│ the current configuration.  
│  
│ The -target option is not for routine use, and is provided only for exceptional situations such as recovering from errors or mistakes, or  
│ when Terraform specifically suggests to use it as part of an error message.  
╵  
╷  
│ Warning: Applied changes may be incomplete  
│  
│ The plan was created with the -target option in effect, so some changes requested in the configuration may have been ignored and the output  
│ values may not be fully updated. Run the following command to verify that no other changes are pending:  
│ terraform plan  
│  
│ Note that the -target option is not suitable for routine use, and is provided only for exceptional situations such as recovering from  
│ errors or mistakes, or when Terraform specifically suggests to use it as part of an error message.  
╵

Apply complete! Resources: 0 added, 0 changed, 0 destroyed.

Outputs:

glue\_api\_users\_extract\_job = “de-c4w4a2-api-users-extract-job”  
glue\_rds\_extract\_job = “de-c4w4a2-rds-extract-job”  
glue\_role\_arn = “arn:aws:iam::652364515135:role/de-c4w4a2-glue-role”  
glue\_sessions\_users\_extract\_job = “de-c4w4a2-api-sessions-extract-job”

When I run these three jobs from command line:-  
glue\_api\_users\_extract\_job  
glue\_sessions\_users\_extract\_job  
glue\_rds\_extract\_job

It shows the following error occurs:-

An error occurred (AccessDeniedException) when calling the StartJobRun operation: User: arn:aws:sts::652364515135:assumed-role/voclabs/user4161362=xjlfpinlzjvv is not authorized to perform: glue:StartJobRun on resource: arn:aws:glue:us-east-1:652364515135:job/glue\_rds\_extract\_job because no identity-based policy allows the glue:StartJobRun action

So I go to the console and open the glue menu and run the three ETL jobs from there and they successfully run but I could not find glue\_json\_transformation\_job and glue\_songs\_transformation\_job anywhere in the ETL menu and when I try to execute from command line it shows the following error:-

An error occurred (AccessDeniedException) when calling the StartJobRun operation: User: arn:aws:sts::652364515135:assumed-role/voclabs/user4161362=xjlfpinlzjvv is not authorized to perform: glue:StartJobRun on resource: arn:aws:glue:us-east-1:652364515135:job/glue\_json\_transformation\_job because no identity-based policy allows the glue:StartJobRun action

---

<div class="post-metadata">

**Author:** ![benjamintabaresjr](https://sea1.discourse-cdn.com/dlai/user_avatar/community.deeplearning.ai/benjamintabaresjr/32/112069_2.png) [@benjamintabaresjr](https://community.deeplearning.ai/u/benjamintabaresjr)\
**Post date:** [June 20, 2025, 2:06am UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453/5 "2025-06-20T02:06:35Z")

</div>

Hi @hawraa.salami,  
@ANAND_KASHYAP is encountering an authorization error following the recent lab refresh. When you have a moment, could you please take a look?  
Thanks so much!

---

<div class="post-metadata">

**Author:** ![ANAND\_KASHYAP](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@ANAND\_KASHYAP](https://community.deeplearning.ai/u/ANAND_KASHYAP)\
**Post date:** [June 20, 2025, 3:31pm UTC](https://community.deeplearning.ai/t/c4w4-terraforms-crashing-assignment-5/835453/6 "2025-06-20T15:31:34Z")

</div>

Thank you for your support, sir, but after another lab refresh, no errors were show, and I was successfully able to complete the assignment.
