cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

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

hetadesai
New Contributor II

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Kaniz
Community Manager
Community Manager

Hi @heta desai​ , Here's how you can copy your file from SFTP location and put it into Azure Data lake.

https://docs.microsoft.com/en-us/azure/data-factory/connector-sftp?tabs=data-factory

View solution in original post

3 REPLIES 3

Kaniz
Community Manager
Community Manager

Hi @heta desai​ , Here's how you can copy your file from SFTP location and put it into Azure Data lake.

https://docs.microsoft.com/en-us/azure/data-factory/connector-sftp?tabs=data-factory

Hubert-Dudek
Esteemed Contributor III

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.

Kaniz
Community Manager
Community Manager

Hi @heta desai​ , Did our suggestions help you?

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.