The problem I’m having
I’m trying to create some dbt models for tables in databricks with external location to: azurepath/prefix.table/data
The context of why I’m trying to do this
In my dbt_project.yml there is the location_root set dynamically to azurepath for handling the different workspaces. I saw that the external location path is build like this by dbt: location_root/alias/data.Basically instead of this behaviour I want in the CTAS to have for location the path created like location_root/prefix.alias/data (if it is relevant, the prefix is the same as the schema from dbt_project.yml)
I’m looking for a solution to build the path using hardcored prefix or by taking the string from schema
What I’ve already tried
I think I can change the alias but that will change the name of the table in databricks at the same time, name which I do not want to have changed. I’ve tried to explicitly set location_root in my model’s yml and searched the git repository for the macrod that creates the final path but I did not find it.