Recommended Setup for IDE Debugger?

[jcarpenter12]

Hi all,

I have done a fair bit of digging on this and can't seem to find a straight forward answer to this. If found a post from @dataders on the slack channel which gave some useful hints about when he was trying to set this up a few years ago here

Basically I want to add a breakpoint in the connections.py code in order to determine whether there is an issue with my configuration or whether there is potentially a bug in the package with an eye to fixing it if so (knowing my luck it's almost certainly the former).

The part I am finding tricky at the moment is how the dbt cli and the adapter interact and what command should be run in the startup script of the debugging configuration itself.

Basically I want to add a breakpoint to the code and then run dbt debug --connection, then have it break out for me so I can step through the code line by line. I have tried a number of different configurations for this but I am not having much success with setting this up.

My questions are:

What is the usual recommended workflow for dbt contributors? (I have read the CONTRIBUTING.MD, but it doesn't mention anything about using a debugger, I'm guessing because it's user dependent). I.e how do you like to work?

Does anyone have a recommend config file for something like .vscode/launch.json? If I am not going down the wrong path on this one

Many thanks for your time! I am trying to build my knowledge on this stuff, but please do shout if this is not the correct place for these questions, I won't be offended!