dbt-labs / dbt-labs/dbt-adapters
[Bug] Column.from_description crashes on structured type columns
- Dominant language
- Python
- Stars
- 233
- Forks
- 362
- Avg merge
- 3d 22h
- Merged PRs (30d)
- 9
Description
### Is this a new bug?
- [X] I believe this is a new bug
- [X] 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
```shell
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
```markdown
- 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
Contributor guide
Assessment
This issue has not been assessed yet.