notebook for SFTP server connectivity without password.

[s3]

I am trying to develop some script using python to access an sftp server without password and all valid public/private keys in a notebook. However I am not getting any such example. All examples has a password in it. Can I get some help?

[Hubert-Dudek · Accepted solution]

@soumen sarangi​ , There is Spark SFTP library https://github.com/springml/spark-sftp

It sepends what is your data there. Sometimes better idea is to set some copy activity (like in Azure Data Factory) to have it in adls/blob mounted in databricks.

[Atanu]

https://stackoverflow.com/questions/58562744/how-to-upload-text-file-to-ftp-from-databricks-notebook this example looks good to me. or may be try using data libs. https://www.cdata.com/kb/tech/sftp-jdbc-azure-databricks.rst

[Atanu]

again - I do not have this tested to my lab. so still unofficial. 🙂

[Kaniz]

Hi @soumen sarangi​ , Just a friendly follow-up. Do you still need help, or do the above responses help you find the solution? Please let us know.