[Feature] Snowflake Dynamic tables: Support for Adaptive refresh mode

### Is this your first time submitting a feature request?

- [x] I have read the [expectations for open source contributors](https://docs.getdbt.com/docs/contributing/oss-expectations)
- [x] I have searched the existing issues, and I could not find an existing issue for this feature
- [x] I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

### Which version of dbt is this feature for?

dbt v2.x (Core or Fusion)

### Describe the feature

Hey folks, in our [docs](https://docs.getdbt.com/reference/resource-configs/snowflake-configs?version=2#refresh-mode) we mention that:
Snowflake allows 3 options for refresh mode: AUTO, FULL, INCREMENTAL.

But there is actually a 4th refresh mode called ADAPTIVE. From [Snowflake docs](https://docs.snowflake.com/en/user-guide/dynamic-tables/refresh-modes):
Every dynamic table has a refresh mode that controls how its contents are refreshed. There are four Snowflake-managed modes: ADAPTIVE, FULL, INCREMENTAL, and AUTO.

This is a request to add support for the 4th refresh mode ADAPTIVE.

### Describe alternatives you've considered

N/A

### Who will this benefit?

Anyone who needs the ADAPTIVE refresh mode

### Are you interested in contributing this feature?

_No response_

### Anything else?

_No response_