Hi all! I'm using stap-sftp plugin for a meltano e...
# getting-started
o
Hi all! I'm using stap-sftp plugin for a meltano extraction of a CSV. Does anybody know if it exists the possibility of extract only rows where some column value is equal to something? like for example to extract only users where column "country" is "spain", and don't extract the rest? Thanks!
v
https://sdk.meltano.com/en/latest/stream_maps.html might work for you. Personally I'd pull all the data from the csv then make a view in the db filtering the data there
o
Hi Derek, what I need is just to insert filtered records on the database, so not all data gets persisted.
I will take a look to the stream_maps 👍 , thanks a lot.
Worked like a charm @visch, thanks!