## TL;DR

I have added target-snowflake (transferwise variant) and configured it correctly.

## Steps

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

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

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

4. There is no useful information given...

5. 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.

## When to use

You are seeing this: Issue meltano/meltano#7736 (closed, 18 comments): ### Meltano Version 2.19.0 Use this skill when you run into "meltano run with any tap and `target-snowflake` fails at the end of the run, even though it works when piped with".

## When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

## Versions

Versions mentioned in the source: 2.19.0, 3.10. If you are on something much newer or older, the details may have shifted.

## Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.
