Is this a new bug in dbt-snowflake?

• I believe this is a new bug in dbt-snowflake
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Snowflake CREATE ICEBERG TABLE DDL gives EXTERNAL_VOLUME as an optional parameter with the following reasoning:

If you don’t specify this parameter, the Iceberg table defaults to the external volume for the schema, database, or account. The schema takes precedence over the database, and the database takes precedence over the account.

However, at the moment, dbt-snowflake expects that external_volume is set at the model level into the configs.

https://github.com/dbt-labs/dbt-snowflake/blob/457c361a8453d7e4c09ce9033f872a651646fd6c/dbt/adapters/snowflake/relation.py#L209

Expected Behavior

If an external volume is set at account/database/schema level, dbt should ignore external volume field and just not pass this information to the statment.

Steps To Reproduce

1. Set external volume to database
2. Not pass this info to the model config
3. Run dbt.

Relevant log output

External volume 'NONE' does not exist or not authorized.

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

No response