[Feature] Enable materializing seeds as iceberg tables

[dbeatty10]

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

Describe the feature

Currently, seeds are only ever materialized as tables (not views, materialized views, dynamic tables, etc).

This feature request is that they can optionally be materialized with an Iceberg catalog in dbt_project.yml or a whatever.yml file.

Assuming you have a catalog defined like this:

catalogs.yml

catalogs:
  - name: catalog_horizon
    active_write_integration: snowflake_write_integration
    write_integrations:
      - name: snowflake_write_integration
        external_volume: dbt_external_volume
        table_format: iceberg
        catalog_type: built_in
        adapter_properties:
          change_tracking: 'True'

Then be able to do this:

dbt_project.yml

seeds:
  my_dbt_project_name:
    +catalog_name: catalog_horizon

Or this:

models/whatever.yml

seeds:
  - name: my_seed
    config:
      catalog_name: catalog_horizon

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response