Migrate to MeltanoLabs tap-snowflake

[pnadolny13]

Once MeltanoLabs/tap-snowflake#2 merges we should test out that new tap and migrate once were comfortable.

[pnadolny13]

This PR is failing CI because of MeltanoLabs/tap-snowflake#10. It makes it hard to toggle schema/database across environments. Currently the isolation between CI runs that we had arent working so a job is accidentally retrieving data from other CI runs.

I could duplicate and override the selection criteria in the CI environment config (all other envs are working because schema are 1-1 with an env) but I'm still blocked with injecting my CI_BRANCH variable into the selection criteria because of meltano/meltano#3171.

My options:

1. merge the new variant changes with the CI tests disabled
2. keep the pipelinewise variant and CI tests enabled until Limit Discoverable Tables MeltanoLabs/tap-snowflake#10 is complete

@tayloramurphy @kgpayne What do you think? I'm planning to go with option 2 to be safe and keep everything working as is until theres a way to filter more.

[tayloramurphy]

@pnadolny13 if it's not ready for primetime then let's wait until that issue is complete 👍