feat: add sample code about default missingValueInterpretation (#2249)

yirutang · web-flow · commit ebedcc07e400 · 2023-09-25T15:23:35.000-07:00
* feat: add sample code about default missingValueInterpretation

* .
diff --git a/samples/snippets/src/main/java/com/example/bigquerystorage/WriteToDefaultStream.java b/samples/snippets/src/main/java/com/example/bigquerystorage/WriteToDefaultStream.java
@@ -26,6 +26,7 @@
 import com.google.cloud.bigquery.BigQueryOptions;
 import com.google.cloud.bigquery.QueryJobConfiguration;
 import com.google.cloud.bigquery.TableResult;
+import com.google.cloud.bigquery.storage.v1.AppendRowsRequest;
 import com.google.cloud.bigquery.storage.v1.AppendRowsResponse;
 import com.google.cloud.bigquery.storage.v1.BigQueryWriteClient;
 import com.google.cloud.bigquery.storage.v1.BigQueryWriteSettings;
@@ -178,6 +179,10 @@ public void initialize(TableName parentTable)
                       .setChannelsPerCpu(2)
                       .build())
               .setEnableConnectionPool(true)
+              // If value is missing in json and there is a default value configured on bigquery
+              // column, apply the default value to the missing value field.
+              .setDefaultMissingValueInterpretation(
+                  AppendRowsRequest.MissingValueInterpretation.DEFAULT_VALUE)
               .build();
     }
 
