SFTP Connect

[ajain80]

How I can connect sftp server from databricks. So I can write files into tables directly?

[Debayan]

Hi @ARINJAY JAIN​ , Could you please check if this works: https://community.databricks.com/s/question/0D53f00001lbF65CAE/notebook-for-sftp-server-connectivity...

[kalo1]

Thank you for the link, you made my day.

[Kaniz]

Hi @ARINJAY JAIN​ , We haven’t heard from you since @Debayan Mukherjee​ 's last response, and I was checking back to see if you have a resolution yet.

If you have any solution, please share it with the community, as it can be helpful to others. Otherwise, we will respond with more details and try to help.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[Hubert-Dudek · Accepted solution]

The classic solution is to copy data from FTP to ADLS storage using Azure Data Factory, and after the copy is done in the ADF pipeline, trigger the databricks notebook.

[Cronk]

Thank you, I will try it. I hope it works. If you're looking for the best online writing services for your college assignments, be sure to visit https://www.topwritersreview.com/reviews/essayusa/ It's an excellent resource that can help you make an informed decision and achieve your academic goals with confidence.

[Michael_Appiah]

Is there a way to copy data from FTP into ADLS using PySpark in a Databricks Notebook (i.e. without ADF)?
The following library (https://github.com/springml/spark-sftp) that some have recommended does not seem to include a PySpark API.