dbt-labs / dbt-labs/dbt

[BUG] No column level auto-complete in vscode

Open
#13,665 9 comments 2 reactions 0 assignees View on GitHub
area:vscode engine:v2 post-ga status:needs-repro status:triage type:bug
Dominant language
Rust
Stars
13.8k
Forks
2.6k
Avg merge
21h 31m
Merged PRs (30d)
56

Description

Issue was originally opened as FEAT. But, the vscode extension clearly describes column auto-completion as a supported feature. So I have updated the issue to BUG.

Image

**Is your feature request related to a particular component of the dbt Fusion Engine**
- [ ] CLI Features
- [ ] Adapter or Database Driver Features
- [ ] SQL Understanding Features
- [x] VS Code extension

**Describe the solution you'd like**

With dbt fusion, vscode "knows" the shape of objects (CTEs, tables, views...) that I'm referencing in my SELECT statement.

Yet, I still have to type out every column name myself. Vscode never tries to help with that.

No matter what I try, the suggestions are always SQL functions.

I actually thought (perhaps wrongly) that the official dbt extension already supports column-level autocomplete. But that doesn't seem to be the case.

Can support be added?

Toy example:

```sql
WITH foo AS (
SELECT column1 AS colour
FROM (VALUES ('a'))
)
SELECT
*
FROM foo
```

Mouseover `*` to prove that vscode knows the shape of `foo`:

Image

Start typing a column name, and observe no relevant autocomplete:

Image

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.