[Bug] Column.from_description crashes on structured type columns

[jelmerk]

Is this a new bug?

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

Current Behavior

Invoking Column.from_description for a column that is a structured type fails

Expected Behavior

It should return a Column

Steps To Reproduce

from dbt.adapters.base.column import Column
Column.from_description("AUTO_JOINED_ACCOUNTS", "ARRAY(NUMBER(19,0))")

Relevant log output

dbt_common.exceptions.base.DbtRuntimeError: Runtime Error
  Could not interpret data_type "ARRAY(NUMBER(19,0))": could not convert "NUMBER(19" to an integer

Environment

- OS: MacOs
- Python: 3.10.13
- dbt-adapters: dbt-snowflake 1.8.3

Additional Context

This is a big problem because methods like dbt_utils.get_filtered_columns_in_relation and adapter.get_columns_in_relation use this method and now cannot be used with tables with structured types

[colin-rogers-dbt]

Likely an issue with the regex:

dbt-adapters/dbt/adapters/base/column.py

Line 128 in b64d3a5

match = re.match(r"([^(]+)(\([^)]+\))?", raw_data_type)