# Issue When trying to use DBT on External Table Created from Json Data in AWS Glue Database

**URL:** <https://discourse.getdbt.com/t/issue-when-trying-to-use-dbt-on-external-table-created-from-json-data-in-aws-glue-database/16689>\
**Category:** Help\
**Tags:** incremental, dbt-core\
**Created:** [October 23, 2024, 7:16am UTC](https://discourse.getdbt.com/t/issue-when-trying-to-use-dbt-on-external-table-created-from-json-data-in-aws-glue-database/16689 "2024-10-23T07:16:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sajid8161](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/sajid8161/32/4777_2.png) [@sajid8161](https://discourse.getdbt.com/u/sajid8161)\
**Post date:** [October 23, 2024, 7:16am UTC](https://discourse.getdbt.com/t/issue-when-trying-to-use-dbt-on-external-table-created-from-json-data-in-aws-glue-database/16689/1 "2024-10-23T07:16:34Z")

</div>

## The problem I’m having

We have files in Raw Json format in s3. I used a crawler to generate a table in Glue Database. When trying to create a new table from the Json table dbt is throwing error that column does not exist. But the column can be found in the schema in Glue Table.

## Some example code or error messages

```auto
AnalysisException: Column 'metadata' does not exist. Did you mean one of the following? [spark_catalog.dbt_db.crawler_4127_indb_ahl_test_topic_flexi_indb_gonogo_test_gonogocustomerapplication.date, spark_catalog.dbt_db.crawler_4127_indb_ahl_test_topic_flexi_indb_gonogo_test_gonogocustomerapplication.hour];

```

The hour and date columns are partitions and it seems dbt is only recognising these two columns.

---

<div class="post-metadata">

**Author:** ![nehadarwin](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/nehadarwin/32/3992_2.png) [@nehadarwin](https://discourse.getdbt.com/u/nehadarwin)\
**Post date:** [December 22, 2024, 10:11am UTC](https://discourse.getdbt.com/t/issue-when-trying-to-use-dbt-on-external-table-created-from-json-data-in-aws-glue-database/16689/2 "2024-12-22T10:11:41Z")

</div>

Hello, were you able to resolve this ?