meltano run with any tap and `target-snowflake` fails at the end of the run, even though it works when piped with...

## The problem
Issue meltano/meltano#7736 (closed, 18 comments): ### Meltano Version

2.19.0

### Python Version

3.10

### Bug scope

CLI (options, error messages, logging, etc.)

### Operating System

MacOS 13.4 (22F66) Ventura

### Description

I have added `target-snowflake` (transferwise variant) and configured it correctly.
It works when invoked alone using `meltano invoke target-snowflake`.

Invoking a tap and piping into the target also works: `meltano invoke tap-slack | meltano invoke target-snowflake`

However, using `meltano run` results in a crash: `meltano run tap-slack target-snowflake`

[image]

There is no useful information given...

## What fixed it
If meltano run crashes at the end with the transferwise variant of target-snowflake while meltano invoke works fine, the culprit is the old pyarrow pin pulled in transitively via snowflake-connector-python; the reporter confirmed that was the problem. The maintainer's recommendation is to switch to the meltanolabs variant of target-snowflake, which is the default and better maintained.