[ADAP-1076] [Feature] [Dynamic Tables] Add new parameter properties (REFRESH_MODE, INITIALIZE)

[sfc-gh-lkoh]

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

Describe the feature

New parameters have been added to dynamic tables, please add them so that users can add them to the config and use the parameters.
The parameters are REFRESH_MODE, INITIALIZE.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table

[Santhin]

For refresh_mode inside create macro it could be achieved with this:

{% macro snowflake__get_create_dynamic_table_as_sql(relation, sql) -%}

    create dynamic table {{ relation }}
        target_lag = '{{ config.get("target_lag") }}'
        warehouse = {{ config.get("snowflake_warehouse") }}
        refresh_mode = {{ config.get("refresh_mode", default='AUTO') }}
        as (
            {{ sql }}
        )
    ;

{%- endmacro %}

[matsavage]

Is there a timeline for this getting into main?