use create or replace table in Snowflake table materialization

[drewbanin]

Feature

Feature description

dbt should use the create or replace table syntax in its Snowflake table materialization.

Presently, dbt's Snowflake table materialization runs by:

1. creating a table with a tmp suffix
2. renaming the old table out of the way
3. renaming the new table into place

Since Snowflake's transactions aren't serializable, a query issued against Snowflake between steps 2 and 3 will result in an error.

Instead, dbt should use create or replace table for tables (as it currently does for views) to atomically replace a table.

Who will this benefit?

Snowflake users who run dbt frequently

[bastienboutonnet]

working snowflake adaptor for this. discussed with @drewbanin will be submitting PR soon 🎉

[drewbanin]

Fixed in #1409