[CT-596] [Feature] Allow customization of seed materialization logic for table creation/insertion

[adamantike]

Is this your first time opening an issue?

• I have read the expectations for open source contributors

Describe the Feature

As described in dbt-labs/dbt-snowflake#112 (comment), plugins can't simply override the logic of seed materialization, regarding table creation/truncation/insertion, without copying the entire implementation.

To simplify that, we can move this following logic to a separate macro:

{{ create_table_sql }};
-- dbt seed --
{{ sql }}

Describe alternatives you've considered

No response

Who will this benefit?

This change will benefit dbt-snowflake, as explained in dbt-labs/dbt-snowflake#112 (comment), by avoiding the need of copying the entire seed materialization logic only to surround the table creation/insertion within a transaction.

Are you interested in contributing this feature?

No response

Anything else?

• [CT-368] Race conditions in dbt seed. dbt-snowflake#112 (comment)