Refactor CI scripts and test fixes #381

Job	Run time
Discover Tests	3s
Run Parallel Tests (tests/component)	1m 25s
Run Parallel Tests (tests/functional/adapter/basic)	3m 22s
Run Parallel Tests (tests/functional/adapter/grants)	1m 24s
Run Parallel Tests (tests/functional/adapter/empty)	1m 44s
Run Parallel Tests (tests/functional/adapter/constraints)	3m 43s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	1m 45s
Run Parallel Tests (tests/caching)	1m 57s
Run Parallel Tests (tests/functional/adapter/materialization)	7m 8s
Run Parallel Tests (tests/hooks)	2m 49s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 38s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 28s
Run Parallel Tests (tests/functional/adapter/relation)	1m 56s
Run Parallel Tests (tests/functional/adapter/utils)	2m 18s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 38s
Run Parallel Tests (tests/unit)	1m 52s
Run Parallel Tests (tests/simple_copy)	2m 44s
Verify Expected Test Failures	5s
	44m 59s

Provide feedback