[idea] snowflake insert_overwrite incremental materialization strategy support

[VersusFacit]

Which of these best describes you?

• dbt Community member
• Partner
• dbt Labs employee
• Other

What's your idea for new content?

The docs should specify we now support this. 🎉

But the key caveat should be noted that this is not actually a true incremental workflow. insert overwrite is closer to a truncate and "re-insert" command. This is a Snowflake quirk that they decided to redefine insert overwrite for their own system.

We may also mention that there is no partition logic in this application of insert overwrite. Up to the team.

Where would you recommend this content live on the docs.getdbt.com?

https://docs.getdbt.com/docs/build/incremental-strategy at a minimum.

Is there an adapter specific documentation area or do we just assume the user can figure it out?