I don't know the details but it's not quite the same 'connect'

But I think you can simply have two venvs if you want - one with Connect and one with local pyspark. You probably do want to treat these as distinct environments; they are different environments. This is what virtual environments are there for IMHO.