[Feature] Iceberg drop columns

[vitstransky]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-spark functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Hello,

Iceberg version 2 supports dropping columns as documented https://iceberg.apache.org/docs/1.7.0/spark-ddl/#alter-table-drop-column. However, when I drop a column in my source data and try to run dbt, I encounter the following error: "Iceberg does not support dropping columns from tables," as implemented https://github.com/dbt-labs/dbt-spark/blob/0ccce2fdc7f2d6341e3b8fd7630eea516c427b65/dbt/include/spark/macros/adapters.sql#L404-L413.

Is it possible to implement this feature, or is there any blocker preventing it?

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

Yes, I do

Anything else?

No response