dbt-labs / dbt-labs/dbt-adapters

[Bug] Column.from_description crashes on structured type columns

Open
#262 1 comment 0 reactions 0 assignees View on GitHub
type:bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.