Hi everyone ![]()
I’m using the dbt VS Code extension connected to Snowflake, and the “Live error detection” feature works fine for syntax issues like missing commas or invalid ref.
However, I have a question: it doesn’t seem to detect invalid column references inside CTEs or SELECT statements. For example, if I reference a column that doesn’t exist in a previous CTE, it doesn’t get flagged as an error.
According to the documentation, it should be able to detect “invalid / missing column names”, but in practice this doesn’t seem to work for me.
Is this a known limitation of the extension, or is there any additional configuration needed to enable this kind of semantic validation?
I’m using the dbt VS Code extension (not sure if version matters or if tools like SQLFluff are required for this).
I’m also attaching a screenshot from the refactoring course where the instructor does seem to have this functionality working, which makes me think I might be missing some configuration or setup.
Thanks in advance!
