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 Likes
Is it possible to rename the file after you download it? Or is the contents of the file not what you expect?
1 Like
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.
1 Like
Is it possible that the file in Cloud Storage is not actually a CSV file?
1 Like
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.
1 Like
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.
1 Like