topic Re: unzip a password protected file using synapse notebook in Data Engineering

unzip a password protected file using synapse notebook

anuintuceo — Tue, 14 May 2024 12:10:15 GMT

I have a zipped file. It has 3 csv files. It is password protected. When I tried extracting it manually it will extract only with 7zip.

I moved my zipped file to ADLS automatically and want to extract it with the password.

How to unzip the file and read all the csv's

-werners- — Fri, 17 May 2024 07:17:18 GMT

it is most probably possible.
If you use python, the zipfile library can do it, something like this:

with zipfile.ZipFile(zip_file_path, 'r') as zip_ref: zip_ref.extractall(path=extract_to, pwd=bytes(password,'utf-8'))

In scala there is f.e. zip4j