Config unit tests for CI

[mikealfare]

resolves #10

Setup unit tests to run automatically against main

Checklist

• I have read the contributing guide and understand what's expected of me
• I have run this code in development and it appears to resolve the stated issue
• This PR includes tests, or tests are not required/relevant for this PR
• This PR has no interface changes (e.g. macros, cli, logs, json artifacts, config files, adapter interface, etc) or this PR has already received feedback and approval from Product or DX

[emmyoop]

This looks fine. Just a question on why you save the results.

We should find out if we need both the matrix for python version in the workflow and the python version tests defined in pyroject.toml. Not a blocker to getting tests running on your PRs though.

[mikealfare]

We should find out if we need both the matrix for python version in the workflow and the python version tests defined in pyroject.toml.

Agreed. My concern is that I don't know how to run integration tests in parallel using the hatch env matrix. They would run in parallel on the machine, but not as separate workflows in GHA. We're already running into memory issues for Redshift on Windows, so I want to split across machines. There might be a plugin for hatch that does this, I just haven't looked into it.