Addition of Model Location Configuration

[idperez720]

Description:

Although SQLMesh provides an alternative to dbt with notable enhancements, it presently lacks a crucial functionality found in dbt: the capability to define model locations. To bridge this gap and offer users enhanced control over their data modeling workflows, I suggest integrating a feature similar to dbt's model location configuration. This improvement would empower users to precisely specify the locations of their models within Databricks, aligning with the streamlined approach established by dbt.

Benefits:
Enhanced flexibility: Users can define model locations according to their specific requirements.
Consistency with dbt: Aligning with dbt's configuration model allows for easier adoption by users familiar with dbt's practices.

DBT models location setup example (dbt_project.yml)

models:
  dbt_example:
    staging:
      schema: raw
      location_root: '/mnt/raw'
    mart:
      schema: primary
      location_root: '/mnt/primary'

Context: https://tobiko-data.slack.com/archives/C044BRE5W4S/p1712257465726229