# Google BigQuery Storage v1 API - Class AppendRowsRequest (3.19.0)

<button class="button button-with-icon cloud-select-dropdown__button " aria-haspopup="true">Version latest</button>

- [3.19.0 (latest)](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.18.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.18.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.17.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.17.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.16.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.16.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.15.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.15.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.14.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.14.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.13.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.13.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.12.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.12.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.11.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.11.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.10.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.10.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.9.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.9.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.8.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.8.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.7.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.7.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.6.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.6.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.5.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.5.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.4.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.4.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.3.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.3.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.2.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.2.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.1.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.1.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [3.0.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/3.0.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.9.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.9.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.8.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.8.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.7.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.7.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.6.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.6.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.5.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.5.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.4.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.4.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)
- [2.3.0](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/2.3.0/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest)

    public sealed class AppendRowsRequest : IMessage<AppendRowsRequest>, IEquatable<AppendRowsRequest>, IDeepCloneable<AppendRowsRequest>, IBufferMessage, IMessage

Reference documentation and code samples for the Google BigQuery Storage v1 API class AppendRowsRequest.

Request message for `AppendRows`.

Because AppendRows is a bidirectional streaming RPC, certain parts of the
AppendRowsRequest need only be specified for the first request before
switching table destinations. You can also switch table destinations within
the same connection for the default stream.

The size of a single AppendRowsRequest must be less than 10 MB in size.
Requests larger than this return an error, typically `INVALID_ARGUMENT`.

## Inheritance

[object](https://learn.microsoft.com/dotnet/api/system.object) \> AppendRowsRequest

## Implements

[IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage-1.html)[AppendRowsRequest](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest), [IEquatable](https://learn.microsoft.com/dotnet/api/system.iequatable-1)[AppendRowsRequest](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest), [IDeepCloneable](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IDeepCloneable-1.html)[AppendRowsRequest](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest), [IBufferMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IBufferMessage.html), [IMessage](https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.IMessage.html)

## Inherited Members

[object.GetHashCode()](https://learn.microsoft.com/dotnet/api/system.object.gethashcode) [object.GetType()](https://learn.microsoft.com/dotnet/api/system.object.gettype) [object.ToString()](https://learn.microsoft.com/dotnet/api/system.object.tostring)

## Namespace

[Google.Cloud.BigQuery.Storage.V1](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1)

## Assembly

Google.Cloud.BigQuery.Storage.V1.dll

## Constructors

### AppendRowsRequest()

    public AppendRowsRequest()

### AppendRowsRequest(AppendRowsRequest)

    public AppendRowsRequest(AppendRowsRequest other)

| **Parameter** ||
|---|---|
| **Name** | **Description** |
| `other` | `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest` |

## Properties

### ArrowRows

    public AppendRowsRequest.Types.ArrowData ArrowRows { get; set; }

Rows in arrow format.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequesthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Types.ArrowData` |   |

### DefaultMissingValueInterpretation

    public AppendRowsRequest.Types.MissingValueInterpretation DefaultMissingValueInterpretation { get; set; }

Optional. Default missing value interpretation for all columns in the
table. When a value is specified on an `AppendRowsRequest`, it is applied
to all requests from that point forward, until a subsequent
`AppendRowsRequest` sets it to a different value.
`missing_value_interpretation` can override
`default_missing_value_interpretation`. For example, if you want to write
`NULL` instead of using default values for some columns, you can set
`default_missing_value_interpretation` to `DEFAULT_VALUE` and at the same
time, set `missing_value_interpretations` to `NULL_VALUE` on those columns.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequesthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Types.MissingValueInterpretation` |   |

### MissingValueInterpretations

    public MapField<string, AppendRowsRequest.Types.MissingValueInterpretation> MissingValueInterpretations { get; }

A map to indicate how to interpret missing value for some fields. Missing
values are fields present in user schema but missing in rows. The key is
the field name. The value is the interpretation of missing values for the
field.

For example, a map {'foo': NULL_VALUE, 'bar': DEFAULT_VALUE} means all
missing values in field foo are interpreted as NULL, all missing values in
field bar are interpreted as the default value of field bar in table
schema.

If a field is not in this map and has missing values, the missing values
in this field are interpreted as NULL.

This field only applies to the current request, it won't affect other
requests on the connection.

Currently, field name can only be top-level column name, can't be a struct
field path like 'foo.bar'.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://cloud.google.com/dotnet/docs/reference/Google.Protobuf/latest/Google.Protobuf.Collections.MapField-2.htmlhttps://learn.microsoft.com/dotnet/api/system.stringhttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequesthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Types.MissingValueInterpretation` |   |

### Offset

    public long? Offset { get; set; }

If present, the write is only performed if the next append offset is same
as the provided value. If not present, the write is performed at the
current end of stream. Specifying a value for this field is not allowed
when calling AppendRows for the '_default' stream.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://learn.microsoft.com/dotnet/api/system.int64` |   |

### ProtoRows

    public AppendRowsRequest.Types.ProtoData ProtoRows { get; set; }

Rows in proto format.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequesthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Typeshttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.Types.ProtoData` |   |

### RowsCase

    public AppendRowsRequest.RowsOneofCase RowsCase { get; }

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequesthttps://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest.RowsOneofCase` |   |

### TraceId

    public string TraceId { get; set; }

Id set by client to annotate its identity. Only initial request setting is
respected.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://learn.microsoft.com/dotnet/api/system.string` |   |

### WriteStream

    public string WriteStream { get; set; }

Required. The write_stream identifies the append operation. It must be
provided in the following scenarios:

- In the first request to an AppendRows connection.

- In all subsequent requests to an AppendRows connection, if you use the
  same connection to write to multiple tables or change the input schema for
  default streams.

For explicitly created write streams, the format is:

- `projects/{project}/datasets/{dataset}/tables/{table}/streams/{id}`

For the special default stream, the format is:

- `projects/{project}/datasets/{dataset}/tables/{table}/streams/_default`.

An example of a possible sequence of requests with write_stream fields
within a single connection:

- r1: {write_stream: stream_name_1}

- r2: {write_stream: /*omit*/}

- r3: {write_stream: /*omit*/}

- r4: {write_stream: stream_name_2}

- r5: {write_stream: stream_name_2}

The destination changed in request_4, so the write_stream field must be
populated in all subsequent requests in this stream.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://learn.microsoft.com/dotnet/api/system.string` |   |

### WriteStreamAsWriteStreamName

    public WriteStreamName WriteStreamAsWriteStreamName { get; set; }

[WriteStreamName](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.WriteStreamName)-typed view over the [WriteStream](https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.AppendRowsRequest#Google_Cloud_BigQuery_Storage_V1_AppendRowsRequest_WriteStream) resource name property.

| **Property Value** ||
|---|---|
| **Type** | **Description** |
| `https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.BigQuery.Storage.V1/latest/Google.Cloud.BigQuery.Storage.V1.WriteStreamName` |   |