https://community.databricks.com/t5/data-engineering/how-to-download-zip-file-from-sftp-location-and-put-that-file/m-p/31455#M22899 <P>I would go with @Kaniz Fatma​&nbsp;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.</P> Tue, 18 Jan 2022 20:42:03 GMT Hubert-Dudek 2022-01-18T20:42:03Z https://community.databricks.com/t5/data-engineering/how-to-download-zip-file-from-sftp-location-and-put-that-file/m-p/31453#M22897 <P>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. </P><P></P><P>Please help me to solve this.</P> Tue, 18 Jan 2022 14:10:19 GMT https://community.databricks.com/t5/data-engineering/how-to-download-zip-file-from-sftp-location-and-put-that-file/m-p/31453#M22897 hetadesai 2022-01-18T14:10:19Z https://community.databricks.com/t5/data-engineering/how-to-download-zip-file-from-sftp-location-and-put-that-file/m-p/31455#M22899 <P>I would go with @Kaniz Fatma​&nbsp;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.</P> Tue, 18 Jan 2022 20:42:03 GMT https://community.databricks.com/t5/data-engineering/how-to-download-zip-file-from-sftp-location-and-put-that-file/m-p/31455#M22899 Hubert-Dudek 2022-01-18T20:42:03Z