[Feature] Refresh mode for dynamic tables

[matsavage]

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

When working with dynamic tables, there is no option to specify the "refresh mode" for the table on creation, which is something we would like to do with our models.

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

This is useful to us, as some of our tables are not automatically "INCREMENTAL" refresh and fall-back to "FULL", and we would like to override this

Describe alternatives you've considered

Looked at a pre-hook to generate a table, but this is very unsatisfactory

Who will this benefit?

Users of Dynamic tables in Snowflake

Are you interested in contributing this feature?

No response

Anything else?

I don't think this is a huge piece of functionality to add, but it feels like there is a lot of overhead wrt complexity of the project and getting an environment set up to test.

[matsavage]

I have added a (draft) PR with the bulk of the changes, but access to a non-work, non-locked down instance of snowflake to test against will be a hinderance from here.

[jtcohen6]

Hey @matsavage - thanks for the issue! I think we've already got some work in flight to address this:

• Add refresh_mode and initialize as dynamic table options #1081

As a continuation of this past issue / community PR:

• [ADAP-1076] [Feature] [Dynamic Tables] Add new parameter properties (REFRESH_MODE, INITIALIZE) #868
• feature: Update Dynamic table parameters on materialization #893

If you want to give that branch a try, before we merge & release:

pip install git+https://github.com/dbt-labs/dbt-snowflake.git@dynamic-table-parameters

[jtcohen6]

I'm going to close this issue, as I believe it's a duplicate with the ones linked above, but please let me know if you disagree!

[matsavage]

Thanks, this looks like it does it!