How to extract 7z file on azure databricks

adf575076 1

How to extract 7z file on azure databricks..

1 answer

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2022-10-06T21:21:24.197+00:00
Hello @adf575076 ,

Welcome to the MS Q&A platform.

Please follow the below commands

Ex: downloading the file from the URL https://resources.lendingclub.com/LoanStats3a.csv.zip to my tmp location

import urllib urllib.request.urlretrieve("https://resources.lendingclub.com/LoanStats3a.csv.zip", "/tmp/LoanStats3a.csv.zip")

unzip using the below commnad:

%sh unzip /tmp/LoanStats3a.csv.zip

You can see the file using the below command:

%fs ls file:/databricks/driver/

Databricks document:

https://docs.databricks.com/data/data-sources/zip-files.html

------------------------------

If this answers your question, please consider accepting the answer by hitting the Accept answer button, as it helps the community.
Please sign in to rate this answer.
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2022-10-10T23:30:21.187+00:00

Hello @adf575076 ,
I am just checking in to see if the above answer helped.

------------------------------

If this answers your question, please consider accepting the answer by hitting the Accept answer button, as it helps the community.

adf575076 1 Reputation point

2022-10-12T07:07:31.193+00:00

Thanks for your answer, but you took Zip file as an example, need to check whether it works for 7z file or only works for Zip file.

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2022-10-12T22:31:39.09+00:00

Hello @adf575076 ,
Thank you. Please try and let me know if you have any issues. I believe you can also use 'gunzip' (instead of unzip)

Tanjil Amin 0 Reputation points

2024-11-22T08:18:26.0566667+00:00

Hello, the question was about extracting 7z not zip files. Please update the answer if possible. Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to extract 7z file on azure databricks

1 answer

Your answer