Can I Log in to the SFTP Server Using Fivetran's Public Key?

Question

Can I connect to the SFTP server using the public key in the SFTP connector setup form?

Environment

Connector: SFTP

Answer

The SSH key required to log in to the SFTP server consists of a public and private key. The public key is used to encrypt data, and the private key is used to decrypt data. We can't share the private key outside of our network, though we add the public key to the authorized_keys file in SFTP's server to facilitate our connection.

As a result, it's not possible to log in to the SFTP server using only the public key in Fivetran's SFTP setup form.