Like many others, I’m developing in VS Code, mainly python, and (like many others) I’m used to having autocomplete when coding.
I’m using postgres as the backend, and there is no autocompletion of tables and columns as far as I can tell. Can that really be true? I guess you need a connection to the backend, but that should be possible with the information available to dbt. I can see that there are VSCode extensions for standard postgres that allow for autocomplete, but they on the other hand do not work well with Jinja.
Any advice on a good IDE setup?