Thanks @szymon_dybczak , it is a great idea.
I will give it a go but in my case the notebook and the modules live in completely different hierarchies so there will be some sort of relative path handling.
The sys.path.append is declared by Databricks to refelect on the executors also. It works fine with UDFs but not for custom source at least on dedicated mode.