Consider switch to Wise as default variant for target-snowflake

[MeltyBot]

Migrated from GitLab: https://gitlab.com/meltano/hub/-/issues/104

Originally created by @aaronsteers on 2021-07-12 22:40:39

---

I think we should consider switching the default variant of Snowflake to Transferwise. This avoids the extra troubleshooting required by the missing Postgres library components, especially for new users and non-postgres users.

Previously I was inclined to keep the Datamill one because it doesn't require S3 but as per the note in #103, the other fork now no longer requires S3 either. The remaining prep step to require a CSV file format pre-created would similarly be resolved if we can push a MR on this logged issue(transferwise/pipelinewise-target-snowflake#188) on the Pipelinewise repo.

@DouweM and @tayloramurphy - What do you think?

Note: This has come up as I'm attempting to streamline the labs for Academy, as Snowflake is the primary target we are planning to use for students.

[MeltyBot]

View 5 previous comments from the original issue on GitLab