topic Re: Issue while extracting files from a zip file placed in files section of lakehouse in Data Engineering

Issue while extracting files from a zip file placed in files section of lakehouse

ramlalr — Thu, 13 Jun 2024 15:49:26 GMT

I have placed a zip file in a RAW subfolder under files folder in lakehouse, when I try to unzip using zipfile package getting "FileNotFoundError: [Errno 2] No such file or directory: '/RAW/data_Q2_2017.zip'"

Code Used:

import zipfile

with zipfile.ZipFile("/RAW/data_Q2_2017.zip", 'r') as zip_ref:

zip_ref.extractall()

Re: Issue while extracting files from a zip file placed in files section of lakehouse

v-cboorla-msft — Fri, 14 Jun 2024 10:04:05 GMT

Hi @ramlalr

Thanks for using Microsoft Fabric Community.

The error message you are seeing, “FileNotFoundError: [Errno 2] No such file or directory: ‘/RAW/data_Q2_2017.zip’”, typically means that Python cannot find the file you’re trying to unzip. In your case, you are trying to unzip the file located at “/RAW/data_Q2_2017.zip”. This path is an absolute path, which means Python is looking for the file starting from the root directory (“/”). If your file is located in a subdirectory of your current working directory, you should use a relative path instead of an absolute path. A relative path starts from your current working directory, not from the root directory.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

Re: Issue while extracting files from a zip file placed in files section of lakehouse

ramlalr — Fri, 14 Jun 2024 10:23:07 GMT

Thanks for the help

Re: Issue while extracting files from a zip file placed in files section of lakehouse

v-cboorla-msft — Fri, 14 Jun 2024 10:29:12 GMT

Hi @ramlalr

Glad that your query got resolved.
Please continue using Fabric Community for further queries.

Thank you.