Add CI Pipelines

We should add support for running tests in CI/CD to improve the overall quality of contributions to the library.

We should support allowing *everyone* to run tests that do not connect to snowflake, and contributors to run test suites that connect to our test Snowflake instance.