[ADAP-972] [Bug] Materialized views show up as tables in catalog queries

[mikealfare]

Is this a new bug in dbt-bigquery?

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

Current Behavior

Materialized views show up as tables 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 that the type for the materialized view is "table"

For more details, refer to: dbt-labs/dbt-core#8864

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-bigquery:

Additional Context

No response