File size limitation for SFTP connector

QUESTION

Do we have a file size limitation for our SFTP connector? 

ANSWER

SFTP connector does not enforce any hard limit for the size of files to be fetched from SFTP server. The connector uses streaming, so it is able to deal with much larger files without any issues. 
However, similar to manual transfers of large files between SFTP server and client, you may encounter issues due to connection resets or broken connection issues on the SFTP server end. The connection (an unstable connection, termination of connection based on some policy, etc.) or some settings on the UNIX server hosting the SFTP server.
In case of large files, the possibility of picking up the same file, which is already being processed (being transferred), during next iteration is a possibility. So, changing the file polling time to pick up the file has to be tweaked based on the size of the files you are dealing with. By checking the behavior for different polling timers, you will arrive at an optimal value for your application.