Welcome to Microsoft Q&A! Thanks for posting the question.
If you are using SFTP connector then this connector can only handle files that are 50 MB or smaller and this connector doesn't support message chunking. For larger files, you can leverage the SFTP-SSH connector that supports message chunking and can handle up to 1 GB.
Storage connector also has a limitation of 1 GB if you are leveraging message chunking.
Feel free to get back to me if you have any queries or concerns.
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.