Create versioned tables as a materialization based on new create or alter statement

[martikevin]

Hi guys

Snowflake now has GA for create or alter statement for tables this allows for a versioned_table dbt model materialization. Wouldnt that be a nice addition since it allows for schema evolution and for shared model development between roles with different access levels to data. I will probably implement that since our org needs shared model development and with the current table materialization only the owner can update a model since dbt runs "drop table" and "create table as" which only the owner of the table can run in snowflake.

Long story short I am looking for a method to generate table models with different developer roles locally. I think we could use create or alter table for that and create or alter table might be an interesting way of implementing it. Also gives us versioning over the table schema and its data as a by-product.

What do you think? And yes I am an idiot..