[Spike] Debug Redshift CI/CD failures

[McKnight-42]

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

currently having a series flaky test in ci/cd (not appearing locally)

Expected Behavior

nightly ci/cd tests should pass ideally

Steps To Reproduce

check alert-channel for previous runs of tests on various branches to track common cause and rerun

Relevant log output

No response

Environment

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

Additional Context

No response

[McKnight-42]

various failed run ci's examples:
1.5: https://github.com/dbt-labs/dbt-redshift/actions/runs/8679219933/job/23797500966
1.6: https://github.com/dbt-labs/dbt-redshift/actions/runs/8679403460/job/23798072300
1.7: https://github.com/dbt-labs/dbt-redshift/actions/runs/8679554844/job/23798492672