[ADAP-1050] [Bug] Alter materialized view test fails sporadically

[mikealfare]

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

https://github.com/dbt-labs/dbt-redshift/actions/runs/6311029519/job/17134205416#step:7:284

Expected Behavior

The test should either fail consistently or pass consistently.

Steps To Reproduce

This happens when running CI, e.g. https://github.com/dbt-labs/dbt-redshift/actions/runs/6311029519/job/17134205416#step:7:284.

Relevant log output

No response

Environment

• OS: any
• Python: 3.8+
• dbt-core: 1.6+
• dbt-redshift: 1.6+

Additional Context

Rerunning the workflow generally fixes the issue, suggesting it's either a race condition, rate limiting issue, or test order condition.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.