topic Re: can you help me with connection between databricks and sftp file using paramiko?? in Warehousing & Analytics

can you help me with connection between databricks and sftp file using paramiko??

115412 — Thu, 18 May 2023 14:34:26 GMT

https://community.databricks.com/s/question/0D58Y00009fClizSAC/ssh-connection-with-paramiko i read in this post that you can help me with that problem, please can you give me more advice what i have to do to connect to an sftp through ssh

Re: can you help me with connection between databricks and sftp file using paramiko??

ZhengHuang — Fri, 02 Jun 2023 18:34:53 GMT

Hi!

Could you please let me know what your current blocker is? Are you looking for a code snippet that can help you get file through sftp? Or if you are looking for the spark config that whitelist the port? Or if you are blocked by some other error?

Re: can you help me with connection between databricks and sftp file using paramiko??

ZhengHuang — Fri, 02 Jun 2023 18:46:08 GMT

here is a sample code you can try:

transport = paramiko.Transport((host, port))
transport.connect(None, username, password)
sftp_path =sftp_path + sftp_file_name
sftp = paramiko.SFTPClient.from_transport(transport)
sftp.get(sftp_path, replaced_local_path + flat_file_name)

please ensure the all the variables are correctly defined and the connection to the host server is open.