Unzip gzip files in Azure Data factory

0 votes

I am wondering if it is possible to set up a source and sick in ADF that will unzip a gzip file and shows the extracted txt file. What happened is that the sink was incorrectly defined where both the source/sink had gzip compression.

So what ended up is that "fil1.gz" is now "file1.gz.gz".

This is how the file looks in Azure blob: enter image description here

This is how the file looks like in an S3 bucket (the end is cut off, but the end is "txt.gz"): enter image description here

I saw that in COPY there is Zipdeflate and deflate compression, but I get an error that it does not support this type of activity.

I created a sink in an ADF pipeline where I am trying to unzip it. In the datasource screen I used Zipdeflate, but it puts the file name with "deflate" extention, and not with the 'txt'.

Mar 9, 2022 in Azure by Edureka
• 13,620 points
2,221 views

1 answer to this question.

0 votes

How to unzip a GZIP file? here's some steps to be followed

  1. Save the.gzip file to your computer's desktop. If you downloaded a compressed file from a website, it may have been saved in the Downloads folder in your Documents or user directory.
  2. Start WinZip from the start menu or a desktop shortcut. Click File > Open to open the compressed file. Simply double-click on the file if your system has the compressed file extension associated with the WinZip programme.
  3. Select all of the files and folders contained within the compressed file. Alternatively, hold the CTRL key and left-click on the files or folders you want to open to multi-select them.
  4. In the WinZip toolbar, under the Unzip/Share tab, click 1-click Unzip and select Unzip to PC or Cloud.
  5. Choose the destination folder to place the extracting files and click "Unzip" button.
  6. Find your extracted files in the destination folder.
answered Mar 24, 2022 by Edureka
• 12,690 points

Related Questions In Azure

0 votes
0 answers

Using SQL Stored Procedure vs Databricks in Azure Data Factory

ADF pipeline must be used to write ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
937 views
0 votes
1 answer

Can I create virtual machine without virtual network in Azure Resource Manager?

A VNet is used to provide the ...READ MORE

answered Mar 4, 2022 in Azure by Edureka
• 13,620 points
2,186 views
0 votes
1 answer

Azure Data Studio - Why Is Restore Option Missing Entirely?

The SERVERS sidebar allows you to access ...READ MORE

answered Mar 2, 2022 in Azure by Edureka
• 13,620 points
2,888 views
0 votes
0 answers

Prevent users from editing master branch in ADF

In ADF, I'm attempting to prevent dev ...READ MORE

Dec 20, 2022 in DevOps on Cloud by Damonlang
• 1,230 points
365 views
0 votes
0 answers

Testing & Deploy Azure Data Projects

As an Azure developer and data engineer, I enjoy automating cloud deployments and testing.  I'm currently working with a number of Azure resources, including SQL Server, PowerBI, Azure Data Factory, Azure Data Lake Storage, and Azure Data Lake Analytics. Doing some research I've found a bunch ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
568 views
0 votes
1 answer
0 votes
1 answer

Azure Search synonyms not reflecting in results

You most certainly should. If the words ...READ MORE

answered Mar 2, 2022 in Azure by Edureka
• 12,690 points
873 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP