CODEWITHSUNDEEP
google-bigquery
developer
developer

Reputation: 9478

Google generated BigQuery file is corrupted all the time

select * from   gpqueries:contracts.raw where    fiscal_year =2015

ignore case

Whe generating data as JSON or CSV from google big query, and getting data as below when downloaded it from storage bucket.

Please guide me why this happens. Also how can combine multiple files, if generated files are multiple.

enter image description here

Update :

enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 676

Answers (1)

Felipe Hoffa
Felipe Hoffa

Reputation: 59245

From the screenshot I can see that the first 3 characters are 1F8B08 - that's the signature of a gzip compressed file. Just uncompress it with gunzip.

http://www.filesignatures.net/index.php?page=search&search=1F8B08&mode=SIG

My guess: Did you pick "compression: gzip" when exporting?

Upvotes: 1

Related Questions