Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Trouble downloading large file from google cloud storage

I have an 800 mb CSV stored in cloud storage and I am trying to download it to my local computer to use with tableau public. but for some reason the file doesn't save as a csv just as a "file" and I can't do anything with that. Any suggestions?

2 5 1,039
5 REPLIES 5

Is it possible to rename the file after you download it? Or is the contents of the file not what you expect?

Yea I tried altering the extension but that didnt work. And the only app that opens the file is notepad which just listed the contents of each cell. 

Is it possible that the file in Cloud Storage is not actually a CSV file?  

So I just checked and the file type says, application/octet-stream. I exported the file from big query as a CSV and assumed application/octet-stream was an internal term for gcs and didnt really matter but it could be the issue. 

Figured out the issue. application/stream-octet saves documents as arbitrary binary data with the intention of maintaining data integrity of the file but relies on the receiver application to determine file type usually by the name of the original file. Therefore when creating the csv i needed include the file extension in the name. Changing the name retroactively doesn't do anything.