Add `refresh_mode` and `initialize` for snowflake dynamic table configuration

[mikealfare]

What are you changing in this pull request and why?

We added two new configuration options for the dynamic table materialization in dbt-snowflake: refresh_mode and initialization. These options are specific to dbt-snowflake. They are available in dbt Cloud and will be introduced in 1.9 in dbt Core.

Checklist

• [x] Add versioning components, as described in Versioning Docs
• [ ] Add a note to the prerelease version Migration Guide
• [x] Review the Content style guide so my content adheres to these guidelines.
• [x] For docs versioning, review how to version a whole page and version a block of content.
• [x] Add a checklist item for anything that needs to happen before this PR is merged, such as "needs technical review" or "change base branch."

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
docs-getdbt-com	❌ Failed (Inspect)			Jun 26, 2024 7:49pm

[mikealfare]

This is failing, but I don't have Vercel access so I can't see why. I'm assuming it's either that I am throwing version blocks in the middle of yaml blocks and tables or that I'm adding a first version of 1.9.

[mikealfare]

These are small configuration changes that are specific to a single adapter. Is it worth noting in the migration guide? I notice that's an item in the checklist.