[Bug] Add test for 9682 in core against 1.8 and fix replace MV macros

[VersusFacit]

Is this a new bug in dbt-redshift?

• I believe this is a new bug in dbt-redshift
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

1. No test for this core fix.

2. Replace macros for materialized view generate SQL. Currently the create statement is missing from what is sent to Redshift which leads to query empy error.

Sample logs of test failure here

FAILED tests/functional/adapter/test_ephemeral.py::TestEphemeralMultiSnowflake::test_ephemeral_multi - assert "createorrepl...er='Female');" == 'createview"d...=\'Female\');'
FAILED tests/functional/adapter/dynamic_table_tests/test_dynamic_tables_basic.py::TestSnowflakeDynamicTableBasic::test_dynamic_table_replaces_table - AssertionError: dbt exit state did not match expected
FAILED tests/functional/adapter/dynamic_table_tests/test_dynamic_tables_basic.py::TestSnowflakeDynamicTableBasic::test_dynamic_table_replaces_view - AssertionError: dbt exit state did not match expected

Expected Behavior

Have a test for the internal variables!

Proper materialized view SQL generates and passes the tests.

Steps To Reproduce

To trigger the test failure, integrate the fix here into your branch, then watch integration tests fail. Open logger and you'll find the malformed query that jumps straight to backup without a create predicate.

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-redshift:

Additional Context

No response

[Fleid]

Hey @VersusFacit, moving this to unestimated, but should it be in progress in a sprint?

[mikealfare]

Re-opening for backports