What is Big Queries maximum row size?

2
votes

When trying to load data into a big query table, I get an error telling me a row is larger than the maximum allowed size. I could not find this limitation anywhere in the documentation. What is the limit? And is there a workaround?

The file is compressed json and is 360M.

4
google-bigquery

4 Answers

3
votes

2018 update: 100 MB maximum row size. https://cloud.google.com/bigquery/quotas

1
votes

The maximum row size is 64k. See: https://developers.google.com/bigquery/docs/import#import

The limitation for json will likely increase soon.

1
votes

2013 update: The maximum row size is 1MB, and 20MB for JSON.

See: https://developers.google.com/bigquery/preparing-data-for-bigquery#dataformats