[CT-211] [Bug] Fix typing issues discovered in pre-commit work

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

A series of type-hint related errors were uncovered when examining out mypy configuration as a part of the work to implement pre-commit.

Rather than attempt to fix all of those errors as part of the original ticket, this follow-on was created and all mypy errors were suppressed. Search the codebase for the JIRA ticket number `CT-211` to find all the ignores

### Expected Behavior

--

### Steps To Reproduce

--

### Relevant log output

```shell
--
```

### Environment

```markdown
- OS:
- Python:
- dbt:
```

### What database are you using dbt with?

_No response_

### Additional Context

--