Yes this is possible - dbt Labs provides a JSON Schema representation of dbt's YAML files. When this extension is installed in your VS Code environment, you can associate the schemas and get autocomplete and type checking.

Full installation instructions are in the above-linked GitHub repo's readme