Hmm, I don't know enough to give you a confident answer yet. However, based on the information extracts, it seems that Airbyte's SFTP connector currently supports only CSV and JSON files. You can find more details about the SFTP connector in the [documentation](https://docs.airbyte.com/integrations/sources/sftp). For your specific use case, you might need to create a custom solution or contribute a feature to Airbyte that allows handling encrypted files like .csv.gpg.

The short answer to your question is that Airbyte is not currently suited to this use case. It assumes that Sources and Destinations can communicate via the Airbyte Protocol which requires that data be synced in a structured format (which encrypted data precludes unless it’s decrypted and parsed on the stream). You could write a custom connector, but you would probably need to write both a custom source and destination because neither the File source nor S3 destination will behave as you’d like.

I am now investigating this by making use of rclone --> s3 and using a Lambda trigger to process the input. Not ideal, but it can do the job for now I think!