damccorm commented on code in PR #31721:
URL: https://github.com/apache/beam/pull/31721#discussion_r1672005611


##########
sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/BigQueryOptions.java:
##########
@@ -109,6 +109,26 @@ public interface BigQueryOptions
 
   void setNumStorageWriteApiStreamAppendClients(Integer value);
 
+  @Description(
+      "When using the STORAGE_API_AT_LEAST_ONCE write method with multiplexing 
(ie. useStorageApiConnectionPool=true), "
+          + "this option sets the minimum number of connections each pool 
creates. This is on a per worker, per region basis. "
+          + "Note that in practice, the minimum number of connections created 
is the minimum of this value and "
+          + "(numStorageWriteApiStreamAppendClients x num destinations).")
+  @Default.Integer(2)
+  Integer getMinConnectionPoolConnections();
+
+  void setMinConnectionPoolConnections(Integer value);
+
+  @Description(
+      "When using the STORAGE_API_AT_LEAST_ONCE write method with multiplexing 
(ie. useStorageApiConnectionPool=true), "
+          + "this option sets the maximum number of connections each pool 
creates. This is on a per worker, per region basis. "
+          + "This value should be greater than or equal to the total number of 
dynamic destinations, otherwise a "
+          + "race condition occurs where append operations compete over 
streams.")
+  @Default.Integer(20)

Review Comment:
   > These values are copied over from the existing ConnectionWorkerPool 
defaults (see [code 
ref](https://github.com/googleapis/java-bigquerystorage/blob/b255926764e0e9dac689efdd31d38a25b251296f/google-cloud-bigquerystorage/src/main/java/com/google/cloud/bigquery/storage/v1/ConnectionWorkerPool.java#L175-L191)).
 Note that this restriction is only applied when a user explicitly enables 
multiplexing (ie. setUseStorageApiConnectionPool(true) )
   
   Got it - that is reasonable/non-blocking for this PR then. I do wonder if 
making this larger makes sense though, I'd be interested in hearing thoughts 
from some of the BQ folks here.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to