CODEWITHSUNDEEP
excelcsvgoogle-bigquerygoogle-cloud-storage
mattyfew
mattyfew

Reputation: 163

Exporting from BigQuery not working

I am trying to export a large CSV dataset from BigQuery. The file is over 90000 rows, so BigQuery prompts me to export the table to Google Cloud Storage

...so I did that with the options of:

Export format: CSV,

Compression: GZIP

Google Cloud Storage URI: my_bucket/2015/feb.csv

After a few minutes, the dataset appears in my Google Cloud Storage. Then I go to download it from there. The file is about 200MB, when I finally open it, the excel sheet is crammed with Wingdings, none of the data made it through.

Did I go wrong somewhere? How can I download and open this file properly?

Upvotes: 1

Views: 1471

Answers (1)

Felipe Hoffa
Felipe Hoffa

Reputation: 59175

Try

 mv feb.csv feb.csv.gz
 gunzip feb.csv.gz

According to the question, you asked for a compressed file, so un-compress it first.

Upvotes: 1

Related Questions