[ADAP-971] [Bug] Dynamic tables do not show up as a type in catalog queries

[mikealfare]

Is this a new bug in dbt-snowflake?

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

Current Behavior

The catalog queries return a null for the relation type on dynamic tables.

Expected Behavior

The catalog queries should return "dynamic_table" for the relation type on dynamic tables.

Steps To Reproduce

1. In dbt Cloud, create a dynamic table
2. Run docs generate
3. Notice that the type is empty

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

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

No response