...
Metadata defined for an FTP/FTPS or an SFTP (SSH) connection is not designed to be used in the same way as a file or database metadata. It is used to contain the connection information to the server and its directories. You use such a metadata definition in FTP or SCP actions in processes, but drag by dragging and dropping it on the action to create a metadata link. By doing so, you configure the action (host, port, user, password, etc.) with the parameters set in the metadata. You cannot reverse-engineer file structure through FTP/SFTP, as they are transfer protocols.
...