How to load .zip files into BigQuery?

Question

We are able to load uncompressed CSV files and gzipped files completely fine. However, if we want to load CSV files compressed in ".zip" - what is the best approach to move ahead? Will we need to manually convert the zip to gz or BigQuery has added some support to handle this?

Thanks

Answer 1

BigQuery supports loading gzip files

The limitation is - If you use gzip compression BigQuery cannot read the data in parallel. Loading compressed CSV data into BigQuery is slower than loading uncompressed data.