Refactor CI scripts and test fixes #386

Job	Run time
Discover Tests	3s
Run Parallel Tests (tests/functional/adapter/empty)	1m 33s
Run Parallel Tests (tests/component)	1m 14s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 41s
Run Parallel Tests (tests/unit)	1m 52s
Run Parallel Tests (tests/functional/adapter/relation)	1m 45s
Run Parallel Tests (tests/hooks)	2m 47s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 19s
Run Parallel Tests (tests/functional/adapter/constraints)	3m 54s
Run Parallel Tests (tests/simple_copy)	2m 41s
Run Parallel Tests (tests/functional/adapter/materialization)	6m 59s
Run Parallel Tests (tests/functional/adapter/utils)	2m 11s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 21s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	1m 46s
Run Parallel Tests (tests/caching)	1m 56s
Run Parallel Tests (tests/functional/adapter/basic)	3m 10s
Run Parallel Tests (tests/functional/adapter/grants)	1m 19s
Verify Expected Test Failures	9s
	43m 40s

Provide feedback