airbyte icon indicating copy to clipboard operation
airbyte copied to clipboard

SFTP Destination

Open mystmaker33 opened this issue 4 years ago • 4 comments

Tell us about the new connector you’d like to have

I would like an SFTP destination for csvs based on tables in my database.

Describe the context around this new connector

We often need to regularly output csv files for our vendors with our data in them. Many of them use SFTPs to receive the csvs.

Describe the alternative you are considering or using

Right now I have scheduled python scripts that query our database, write the csv and post it to the desired SFTP

Are you willing to submit a PR?

Maybe! I can take a look, but don't want to guarantee anything :)

mystmaker33 avatar Jul 21 '21 00:07 mystmaker33

Hello! Would like to know if there's any update on this? I'm also looking to use SFTP as a destination. @mystmaker33 did you find some solution for this? Thanks in advance!

snikhil24 avatar Jun 29 '22 23:06 snikhil24

Hey @snikhil24, @mystmaker33 I started working on this one, if you could, your contribution will be much appreciated! https://github.com/airbytehq/airbyte/pull/19536

haithem-souala avatar Nov 22 '22 14:11 haithem-souala

Hey! I'm cleaning up issues, and want to clarify. So we have destination-sftp-json, and you'd like to have destination-sftp-csv, is that it? Would it be a better fit to have destination-sftp with configurable format instead?

natikgadzhi avatar Oct 14 '24 00:10 natikgadzhi

Personally I think a configurable destination format makes the most sense, as different vendors need their files formatted differently.

On Sun, Oct 13, 2024, 8:11 PM Natik Gadzhi @.***> wrote:

Hey! I'm cleaning up issues, and want to clarify. So we have destination-sftp-json, and you'd like to have destination-sftp-csv, is that it? Would it be a better fit to have destination-sftp with configurable format instead?

— Reply to this email directly, view it on GitHub https://github.com/airbytehq/airbyte/issues/4875#issuecomment-2409434235, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEHJLVMVOTBYOCODZ7YGLP3Z3MD4LAVCNFSM6AAAAABP35JTN2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBZGQZTIMRTGU . You are receiving this because you were mentioned.Message ID: @.***>

mystmaker33 avatar Oct 14 '24 01:10 mystmaker33

Any updates on an SFTP destination for CSV?

zivagolee avatar Mar 17 '25 22:03 zivagolee

We have decided to push our Destination SFTP which supports json and csv. We use it for highly secured sftp sites so has some extra optional options https://github.com/airbytehq/airbyte/pull/60219

wallies avatar May 12 '25 06:05 wallies