Hello here, I’m using tap-postgres transferwise and was wondering if there was a way to add some kind of where clause to capture specific values for specific stream

Hey @charley_guillaume! Whats your use case for this? You might be able to stream map filters to remove records based on a boolean expression

Hey @pat_nadolny Thanks for your prompt answer. In the db i’m ingesting from some data are in a draft mode making most of the fields completely not ingestable (wrong datatype,...) I want those rows to be filtered out. I’ll look into the filters. Thanks!

Awesome! If you do end up testing out stream maps, definitely report back any feedback and let us know how it goes 😄

I should say that stream maps currently only work in SDK-based taps, but support for https://github.com/MeltanoLabs/meltano-map-transform directly as a plugin is coming soon via https://gitlab.com/meltano/meltano/-/issues/2299