If I'm wanting to transfer daily csv files stored on a sFTP server, is there a tap that manages the sFTP file downloads? To run this within Meltano, what would be required, or this completely custom? NB: not an Airflow expert

Hi Rodney, the spreadsheets anywhere tap (https://hub.meltano.com/extractors/spreadsheets-anywhere) is probably your best starting point. It supports any smart_open (https://github.com/RaRe-Technologies/smart_open) transport including sFTP. Is your requirement to load the files into an existing database, or sync to do some kind of analytics? Would be great to understand the whole challenge. Someone might have just the thing to help you.

Is your requirement to load the files into an existing database, or sync to do some kind of analytics?

It's to load a daily extract of leads produced and stored in sFTP by Adobe Campaign. They host the sFTP server, and it needs to be inserted into a database to then conduct analytics against the data in the db

Wow. ok... sFTP exports https://experienceleague.adobe.com/docs/campaign-classic/using/getting-started/importing-a[…]orting-data/get-started-data-import-export.html?lang=en