Meltano

Hello all, I'm using tap-stripe and target-postgresql meltano labs variant and the export fails with a broken pipe error. What could be the issue here?

stripe.log

meltano invoke target-postgres --version
2024-01-16T15:01:52.985521Z [*info*   ] *Environment 'dev' is active*
target-postgres v[could not be detected], Meltano SDK v0.34.1

<https://stackoverflow.com/questions/56808425/sqlalchemy-psycopg2-programmingerror-cant-adapt-type-dict>

It looks like you have this error in your stack trace

Are you using the default Stitch data variant of `tap-stripe`?

Hello <@U06C8PJF0TF> yes I'm using the default variant of stripe
`- name: tap-stripe`
    `variant: singer-io`
    `pip_url: git+<https://github.com/singer-io/tap-stripe.git>`
Is there an issue with that ?

In my understanding as both works with the same spec it should work or am I wrong ?

The error seems to suggest that a dict object is being sent to sqlalchemy directy. Can you try a target like `jsonl` to output some files locally to json? Do you get the same issue?

Sorry for not coming back earlier - I tested another stripe variant and it worked with that one <https://hub.meltano.com/extractors/tap-stripe--prratek/>

it went smoothly into the postgres target