[BUG] sys.path and os.getcwd() are inconsistent between Databricks VS-Code Extension and a deployed bundle

[arne-123]

In your docs: https://docs.databricks.com/en/files/cwd-dbr-14.html it says:

'CWD returns the directory containing the notebook or script being run.
When run locally with databricks-connection, os.getcwd() returns the path of the project not the file being run.

Furthermore, the root dir is not added to sys.path when running the job in a bundle but added when run locally.

This happens in ./packages/databricks-vscode/resources/python/dbconnect-bootstrap.py (Line 68)

sys.path.insert(0, root_dir)

Here the root dir is added to sys.path, creating the inconsistent behavior.