Florian Eiden

This was added via https://github.com/dbt-labs/dbt-redshift/pull/781 Can be tested locally via [install from source](https://docs.getdbt.com/docs/core/source-install), should land in 1.9

We should explore if `INSERT [ OVERWRITE ] INTO ` could fix this! https://docs.snowflake.com/en/sql-reference/sql/insert#optional-parameters

I'm not against it, as long as it's an optional flag that default to `false`. Thanks for looking into it!

Good point @dbeatty10. We should have a clear heuristics to make those decisions... Anyway, here it looks like it's a `connections.py` thing, which makes it a local problem? So the...

Hey all! Thanks for "upvoting", please continue to do so. We are wrapping up all the internals work to support 1.8, plus a few more things to do for quality...

@MichelleArk does the behavior (and resolution via using `sql` instead of `compiled_code`) matches your expectations? If yes we should close this then.

Re-opening as we've reverted the PR solving it, the implementation was causing side effects.

Hi @manugarri, The topic is thornier than it looks. We will have a [deeper look shortly](https://github.com/dbt-labs/dbt-snowflake/issues/599) to find an alternative approach, but I'm not sure yet when we'll get to...

Nope, we had to lower the priority to get all of the materialized view implementations through the door. @dataders that could be a thing we try to put back on...