What is the best way to ingest data from a third party ftp, store, and then do transformations in AWS? I come from working in Azure where I'd use data factory to ingest, datalake to store, and then databricks for transformations.
I'm having trouble figuring out which service to use in AWS that would just simply pull the data from a third party ftp. Does Transfer Family allow this? It seems more like a service used to make your own ftp server.