@Jonathan Rosenberg I have checked, but a large reason why that won't work is. No one in my team including me is getting unity catalog permissions to do this.
Ifs All governed and managed by an external team.
Therefore I need to be able to export to a single path always, so that I can ask the other team to expose this table as external