DBT models on iceberg snowflake table fails

Help
1

We integrated snowflake with iceberg tables (using AWS glue catalog).

i can run any query in snowflake, but somehow when i run them on dbt to build a model the query fails. it happens when i use the MAP column type.

i get this error

  002040 (42601): SQL compilation error:
  Unsupported data type 'map(VARCHAR(16777216), VARCHAR(16777216))'.
  compiled Code at target/run/dbt_snowflake_1/models/L1_iceberg/L1__client_events_iceberg.sql

i tried to update my dbt version and my dbt-snowflake version:
Core:

  • installed: 1.7.10
  • latest: 1.7.10 - Up to date!

Plugins:

  • snowflake: 1.7.2 - Up to date!

but still getting the same error.

  1. Any ideas why it actually fails? because snowflake successfully run those queries.
  2. how do i fix this issue?

Thanks

2

I’m also seeing this issue with an ARRAY data type. Even if I try to add a data test to a different field on the same table (for example a text field), it will error and say:

  002040 (42601): SQL compilation error:
  Unsupported data type 'ARRAY(VARCHAR(16777216))'.

Using dbt v1.8.8 and dbt-snowflake v1.8.4. Querying from an Iceberg table in Snowflake.