Refactor: reenable root_path as config parameter #459

Job	Run time
Discover Tests	5s
Run Parallel Tests (tests/functional/adapter/basic)	3m 12s
Run Parallel Tests (tests/component)	1m 39s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 25s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	1m 49s
Run Parallel Tests (tests/functional/adapter/empty)	1m 42s
Run Parallel Tests (tests/caching)	1m 57s
Run Parallel Tests (tests/functional/adapter/constraints)	4m 1s
Run Parallel Tests (tests/functional/adapter/sample_mode)	1m 32s
Run Parallel Tests (tests/functional/adapter/relation)	1m 59s
Run Parallel Tests (tests/functional/adapter/grants)	1m 28s
Run Parallel Tests (tests/functional/adapter/utils)	2m 30s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 48s
Run Parallel Tests (tests/unit)	2m 14s
Run Parallel Tests (tests/functional/adapter/materialization)	7m 9s
Run Parallel Tests (tests/hooks)	3m 0s
Run Parallel Tests (tests/simple_copy)	2m 56s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 20s
Verify Expected Test Failures	8s
	47m 54s

Provide feedback