c# - BigQuery Streaming Insert-估算插入大小，以避免超出限制(BigQuery Streaming Insert - Estimate insertion size in to avoid limitations exceeded)

Question

After trying to insert rows with Streaming, I've encountered the following issue:

(在尝试通过流技术插入行后，我遇到了以下问题：)

Request payload size exceeds the limit: 10485760 bytes.

(请求有效负载大小超出限制：10485760字节。)

Is there a way to estimate a row size after building it?

(构建后是否可以估算行的大小？)

I create a list of BigQueryInsertRow objects and then use the client InsertRows method for insertion, I don't find any GetSize() or any other method to estimate the row size that will be uploaded to BQ.

(我创建了BigQueryInsertRow对象的列表，然后使用客户端的InsertRows方法进行插入，但找不到任何GetSize()或任何其他方法来估计将上传到BQ的行大小。)

Although there's a way to iterate over the columns values, I don't know how the BQ V2 Nuget is calculating this size.

(尽管有一种方法可以遍历列值，但我不知道BQ V2 Nuget如何计算此大小。)

  ask by Guy translate from so

Answer 1

等待大神答复