# Error: creating Glue Catalog Database (de\_c4w4a2\_transform\_db)

**URL:** <https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539>\
**Category:** Data Modeling, Transformation, and Serving\
**Tags:** week-module-4, coursera-platform\
**Created:** [November 4, 2024, 8:02pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539 "2024-11-04T20:02:54Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mafasa](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@Mafasa](https://community.deeplearning.ai/u/Mafasa)\
**Post date:** [November 4, 2024, 8:02pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/1 "2024-11-04T20:02:54Z")

</div>

Error: creating Glue Catalog Database (de\_c4w4a2\_transform\_db): operation error Glue: CreateDatabase, https response error StatusCode: 400, RequestID: 508aadb8-7c99-465c-b890-1e9b69900711, AlreadyExistsException: Database already exists.

When I move to run terraform. I get access denied but I am checked the policies and everything seemed to be configured correctly.

**Please help. Thanks in advance**

---

<div class="post-metadata">

**Author:** ![Amir\_Zare](https://sea1.discourse-cdn.com/dlai/user_avatar/community.deeplearning.ai/amir_zare/32/95275_2.png) [@Amir\_Zare](https://community.deeplearning.ai/u/Amir_Zare)\
**Post date:** [November 5, 2024, 7:09am UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/2 "2024-11-05T07:09:11Z")

</div>

Hello @Mafasa  
Can you please specify after which command you get the error `Error: creating Glue Catalog Database (de_c4w4a2_transform_db): ...`?  
There are two different transform jobs, one for the songs and one for the json. Please, provide screenshots from your issue if possible.

---

<div class="post-metadata">

**Author:** ![Mafasa](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@Mafasa](https://community.deeplearning.ai/u/Mafasa)\
**Post date:** [November 5, 2024, 9:31am UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/3 "2024-11-05T09:31:17Z")

</div>

When i run terraform on target transform json and I also check the script where I only needed to modify the ingestion date.

---

<div class="post-metadata">

**Author:** ![Mafasa](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@Mafasa](https://community.deeplearning.ai/u/Mafasa)\
**Post date:** [November 5, 2024, 9:32am UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/4 "2024-11-05T09:32:00Z")

</div>

If still unclear I will provide you with screenshots later on

---

<div class="post-metadata">

**Author:** ![Mafasa](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@Mafasa](https://community.deeplearning.ai/u/Mafasa)\
**Post date:** [November 5, 2024, 4:44pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/5 "2024-11-05T16:44:19Z")

</div>

Issue fixed. I ran terraform apply instead module by module

---

<div class="post-metadata">

**Author:** ![felipeyamate](https://avatars.discourse-cdn.com/v4/letter/f/bbe5ce/32.png) [@felipeyamate](https://community.deeplearning.ai/u/felipeyamate)\
**Post date:** [November 7, 2024, 1:01pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/6 "2024-11-07T13:01:49Z")

</div>

In my case the problem continues even when I apply the terraform apply instead module by module, @Amir_Zare

 ![image](https://global.discourse-cdn.com/dlai/original/3X/3/d/3db3659f841d656274fce5aa0d0e3e6f4576a6cf.png)

---

<div class="post-metadata">

**Author:** ![Mafasa](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@Mafasa](https://community.deeplearning.ai/u/Mafasa)\
**Post date:** [November 10, 2024, 1:02pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/7 "2024-11-10T13:02:08Z")

</div>

I think you need to do terraform apply -target instead terraform apply for all targets at one time

---

<div class="post-metadata">

**Author:** ![padsch](https://avatars.discourse-cdn.com/v4/letter/p/ecd19e/32.png) [@padsch](https://community.deeplearning.ai/u/padsch)\
**Post date:** [November 16, 2024, 3:14pm UTC](https://community.deeplearning.ai/t/error-creating-glue-catalog-database-de-c4w4a2-transform-db/718539/8 "2024-11-16T15:14:10Z")

</div>

had a similar issue when I have run “terraform apply” and it crashed the terminal  
so it seems like terraform already created that db, but the existence was not registered  
so I needed to go to “AWS GLUE” \> “Database Catalog” \> “Databases” and remove the db which was already there  
After deletion of that df, “terraform apply” worked fine then for me