Refactor CI scripts and test fixes #389

Job	Run time
Discover Tests	4s
Run Parallel Tests (tests/component)	1m 28s
Run Parallel Tests (tests/functional/adapter/basic)	3m 6s
Run Parallel Tests (tests/caching)	1m 52s
Run Parallel Tests (tests/functional/adapter/empty)	1m 43s
Run Parallel Tests (tests/functional/adapter/materialization)	6m 57s
Run Parallel Tests (tests/functional/adapter/unit_testing)	4m 39s
Run Parallel Tests (tests/functional/adapter/constraints)	4m 3s
Run Parallel Tests (tests/functional/adapter/query_comment)	1m 44s
Run Parallel Tests (tests/functional/adapter/relation)	2m 4s
Run Parallel Tests (tests/functional/adapter/grants)	1m 23s
Run Parallel Tests (tests/functional/adapter/utils)	3m 11s
Run Parallel Tests (tests/unit)	1m 58s
Run Parallel Tests (tests/functional/adapter/dbt_clone)	1m 53s
Run Parallel Tests (tests/functional/adapter/dremio_specific)	4m 27s
Run Parallel Tests (tests/simple_copy)	2m 50s
Run Parallel Tests (tests/hooks)	3m 6s
Verify Expected Test Failures	4s
	46m 32s

Provide feedback