Describe the bug

Running the "dbt seed" command returns "Can not create a Path from an empty string" error in Databricks

Steps To Reproduce

I had a simple seed working fine with dbt-databricks 1.9. The seed has 4 columns and 10 rows. Not all these columns are populated (some are nulls).

dbt_project:
seeds:
+tblproperties: {
'delta.feature.allowColumnDefaults': 'supported'
}
+schema: edm_cfg
+catalog: "stg{{ var('catalog_suffix', '_dummy') }}"
+full_refresh: true

Expected behavior

Seed to be loaded to catalog without specifying a location_root

Screenshots and log output

dbt seed --select business_division_group_binding --vars "{'catalog_suffix' : '_dev' , 'catalog_suffix_sources' : '' }"
10:32:45 Running with dbt=1.10.13
10:32:49 Registered adapter: databricks=1.10.13
10:32:51 Unable to do partial parsing because a project config has changed
10:32:51 Unable to do partial parsing because a project config has changed
10:33:24 [WARNING]: Found patch for macro "del_cdim_wl020_ext_spatialmaps_world_zipcodes_city_geo" which was not found
10:33:24 [WARNING][MissingArgumentsPropertyInGenericTestDeprecation]: Deprecated
functionality
Found top-level arguments to test dbt_utils.unique_combination_of_columns.
Arguments to generic tests should be nested under the arguments property.10:33:28 [WARNING]: Found patch for macro "add_etl_timestamp_to_seeds" which was not found 10:33:28 [WARNING]: Found patch for macro "generate_schema_name" which was not found 10:33:28 [WARNING]: Found patch for macro "crete_schema" which was not found 10:33:28 [WARNING]: Found patch for macro "oracle_standard_sha256" which was not found 10:33:30 Found 1295 models, 3 snapshots, 195 seeds, 785 data tests, 416 sources, 1124 macros 10:33:30 10:33:30 Concurrency: 50 threads (target='default') 10:33:30 10:33:35 1 of 1 START seed file stg_dev.edm_cfg.business_division_group_binding ......... [RUN] 10:33:35 [WARNING]: Use revamped materializations based on separating create and insert. This allows more performant column comments, as well as new column features. You may opt into the new behavior sooner by settingflags.use_materialization_v2toTrueindbt_project.yml`.
Visit https://docs.getdbt.com/reference/global-configs/behavior-changes for more information.
10:33:35 1 of 1 ERROR loading seed file edm_cfg.business_division_group_binding ......... [ERROR in 0.70s]
10:33:35
10:33:35 Finished running 1 seed in 0 hours 0 minutes and 5.22 seconds (5.22s).
10:33:36
10:33:36 Completed with 1 error, 0 partial successes, and 0 warnings:
10:33:36
10:33:36 Failure in seed business_division_group_binding (seeds\business_division_group_binding.csv)
10:33:36 Database Error in seed business_division_group_binding (seeds\business_division_group_binding.csv)
Can not create a Path from an empty string
10:33:36
10:33:36 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 NO-OP=0 TOTAL=1
10:33:36 [WARNING][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:

• MissingArgumentsPropertyInGenericTestDeprecation: 7 occurrences
  To see all deprecation instances instead of just the first occurrence of each,
  run command again with the --show-all-deprecations flag. You may also need to
  run with --no-partial-parse as some deprecations are only encountered during
  parsing.

System information

The output of dbt --version:

Core:
  - installed: 1.10.13
  - latest:    1.10.13 - Up to date!

Plugins:
  - databricks: 1.10.13 - Up to date!
  - spark:      1.9.3   - Up to date!

OS: Windows

The output of python --version:
Python 3.11.9

Additional context

it works fine with dbt-databricks 1.9