[ADAP-973] [Bug] Materialized views show up as regular views in catalog queries

[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

Materialized views show up as regular views in catalog queries.

Expected Behavior

Materialized views should show up as materialized views in catalog queries.

Steps To Reproduce

1. Create a materialized view
2. Run docs generate
3. Notice the type for the materialized view is "VIEW"

See dbt-labs/dbt-core#8864 for more details.

Relevant log output

No response

Environment

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

Additional Context

No response