Refactor: reenable root_path as config parameter #458

Job	Run time
Discover Tests	5s
Run Parallel Tests (tests/functional/adapter/basic)	3m 9s
Run Parallel Tests (tests/component)	1m 40s
Run Parallel Tests (tests/functional/adapter/empty)	2m 21s
Run Parallel Tests (tests/functional/adapter/grants)	1m 33s
Run Parallel Tests (tests/functional/adapter/materialization)	7m 7s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 33s
Run Parallel Tests (tests/functional/adapter/constraints)	3m 59s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	2m 10s
Run Parallel Tests (tests/caching)	2m 10s
Run Parallel Tests (tests/simple_copy)	2m 50s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 43s
Run Parallel Tests (tests/functional/adapter/sample_mode)	1m 51s
Run Parallel Tests (tests/functional/adapter/utils)	2m 28s
Run Parallel Tests (tests/unit)	2m 1s
Run Parallel Tests (tests/functional/adapter/relation)	2m 4s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 28s
Run Parallel Tests (tests/hooks)	3m 11s
Verify Expected Test Failures	8s
	49m 31s

Provide feedback