Refactor: reenable root_path as config parameter #449

Job	Run time
Discover Tests	4s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	1m 45s
Run Parallel Tests (tests/caching)	1m 49s
Run Parallel Tests (tests/functional/adapter/constraints)	3m 48s
Run Parallel Tests (tests/functional/adapter/basic)	3m 10s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 24s
Run Parallel Tests (tests/component)	1m 25s
Run Parallel Tests (tests/functional/adapter/materialization)	7m 14s
Run Parallel Tests (tests/functional/adapter/sample_mode)	1m 51s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 44s
Run Parallel Tests (tests/functional/adapter/empty)	1m 46s
Run Parallel Tests (tests/functional/adapter/relation)	1m 49s
Run Parallel Tests (tests/functional/adapter/grants)	1m 27s
Run Parallel Tests (tests/simple_copy)	2m 51s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 35s
Run Parallel Tests (tests/hooks)	3m 11s
Run Parallel Tests (tests/functional/adapter/utils)	2m 20s
Run Parallel Tests (tests/unit)	1m 54s
Verify Expected Test Failures	7s
	47m 14s

Provide feedback