Meltano

target-csv blows up with  nested Objects, and CRLF. Is that the experience everyone else has?

by blows up I mean the File becomes unusable

I remember seeing similar on target-athena, which was based on target-csv. Do you mind opening an issue and/or an MR (if you have a fix)?

The root cause should be somewhere here: <https://github.com/MeltanoLabs/target-csv/blob/main/target_csv/sinks.py#L48-L56|target-csv/sinks.py>

I suspect the issue may be with the quote escaping, driven by `doublequote` and `escapechar` as described here: <https://docs.python.org/3/library/csv.html#csv.Dialect.doublequote>

<https://github.com/MeltanoLabs/target-csv/issues/1> covers it I think

WIP, but this is close: <https://github.com/MeltanoLabs/target-csv/pull/2>

hmm this looks nice!

<@U06D0FVPBHN>

Give this a shot with a CSV target , here's the meltano.yml

```plugins:
  loaders:
  - name: target-csv
    pip_url: git+<https://github.com/MeltanoLabs/target-csv>
    namespace: target_csv
    executable: target-csv```

Tested with the Data we generated in target-athena and it all looked great.

Dialect being set to Excel did the trick?

<@U06CBKL5W7L> is this good enough to replace <https://hub.meltano.com/loaders/csv> ?

Might want to get it updated for the new people!

Cc <@U069EPD13KN>, <@U06D0TMQ2U8>. One thing I noticed is that our SDK-based MeltanoLabs implementation doesn't yet support flattening, while the hotglue variant does.

Also - this isn't necessarily a blocker, but we really should be publishing pinnable versions for all MeltanoLabs taps/targets. We don't have a script or pattern for this yet, unfortunately.