How to download zip file from SFTP location and put that file into Azure Data Lake and unzip there ?

[hetadesai]

I have zip file on SFTP location. I want to copy that file from SFTP location and put it into Azure Data lake and want to unzip there using spark notebook.

Please help me to solve this.

[Hubert-Dudek]

I would go with @Kaniz Fatma​ approach and download data in Data Factory and after is downloaded on success trigger databricks spark notebook. With spark you can read also compressed data so maybe you will not need to do even separate unzip.