[Feature] Add support for iceberg table format in table and incremental materialization

[borjavb]

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-bigquery functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Bigquery has announced support for native Iceberg Tables

dbt-bigquery should support materialising a model as a native iceberg table.

Describe alternatives you've considered

No response

Who will this benefit?

dbt users who want their models available as parquet files in storage they control
dbt users who want an easy way to interoperate with non-dbt systems that use the iceberg table format
dbt users who want direct access and control over the underlying storage of their data

Are you interested in contributing this feature?

yes

Anything else?

No response

[robathija]

Looking forward to this getting merged as we plan to do use the newly released bigquery iceberg tables