# DBT tests don't work on an iceberg table on Glue

**URL:** <https://discourse.getdbt.com/t/dbt-tests-dont-work-on-an-iceberg-table-on-glue/19646>\
**Category:** Help\
**Tags:** dbt-core\
**Created:** [June 12, 2025, 10:10am UTC](https://discourse.getdbt.com/t/dbt-tests-dont-work-on-an-iceberg-table-on-glue/19646 "2025-06-12T10:10:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![khalid.nazi](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/khalid.nazi/32/5761_2.png) [@khalid.nazi](https://discourse.getdbt.com/u/khalid.nazi)\
**Post date:** [June 12, 2025, 10:10am UTC](https://discourse.getdbt.com/t/dbt-tests-dont-work-on-an-iceberg-table-on-glue/19646/1 "2025-06-12T10:10:04Z")

</div>

## The problem I’m having is the data tests fails while running on an iceberg table on AWS Glue

## What I’ve already tried is changing the target schema to glue\_catalog.my\_schema\_name this made the test work but not a valid solution as dbt creates two schemas one with glue\_catalog. and the other without it.

## Some example code or error messages

When the test runs it compiles to this sql:

```auto
  select c1
  from (select * from my_schema.my_ice_table) dbt_subquery
  where c1 is null

```

I know that to access any iceberg table in glue you have to have the prefix glue\_catalog

```auto
 AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table my_ice_table. StorageDescriptor#InputFormat cannot be null for table: my_ice_table

```

---

<div class="post-metadata">

**Author:** ![Ziven](https://avatars.discourse-cdn.com/v4/letter/z/85e7bf/32.png) [@Ziven](https://discourse.getdbt.com/u/Ziven)\
**Post date:** [August 5, 2025, 10:20am UTC](https://discourse.getdbt.com/t/dbt-tests-dont-work-on-an-iceberg-table-on-glue/19646/2 "2025-08-05T10:20:53Z")

</div>

I have this promblem too, did you solve it?
