Package google.bigtable.v2

Index

Bigtable

Service for reading from and writing to existing Bigtable tables.

CheckAndMutateRow

rpc CheckAndMutateRow(CheckAndMutateRowRequest) returns (CheckAndMutateRowResponse)

Mutates a row atomically based on the output of a predicate Reader filter.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

ExecuteQuery

rpc ExecuteQuery(ExecuteQueryRequest) returns (ExecuteQueryResponse)

Executes a SQL query against a particular Bigtable instance.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

GenerateInitialChangeStreamPartitions

rpc GenerateInitialChangeStreamPartitions(GenerateInitialChangeStreamPartitionsRequest) returns (GenerateInitialChangeStreamPartitionsResponse)

Returns the current list of partitions that make up the table's change stream. The union of partitions will cover the entire keyspace. Partitions can be read withReadChangeStream. NOTE: This API is only intended to be used by Apache Beam BigtableIO.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

MutateRow

rpc MutateRow(MutateRowRequest) returns (MutateRowResponse)

Mutates a row atomically. Cells already present in the row are left unchanged unless explicitly changed bymutation.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

MutateRows

rpc MutateRows(MutateRowsRequest) returns (MutateRowsResponse)

Mutates multiple rows in a batch. Each individual row is mutated atomically as in MutateRow, but the entire batch is not executed atomically.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

PingAndWarm

rpc PingAndWarm(PingAndWarmRequest) returns (PingAndWarmResponse)

Warm up associated instance metadata for this connection. This call is not required but may be useful for connection keep-alive.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

PrepareQuery

rpc PrepareQuery(PrepareQueryRequest) returns (PrepareQueryResponse)

Prepares a GoogleSQL query for execution on a particular Bigtable instance.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

ReadChangeStream

rpc ReadChangeStream(ReadChangeStreamRequest) returns (ReadChangeStreamResponse)

Reads changes from a table's change stream. Changes will reflect both user-initiated mutations and mutations that are caused by garbage collection. NOTE: This API is only intended to be used by Apache Beam BigtableIO.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

ReadModifyWriteRow

rpc ReadModifyWriteRow(ReadModifyWriteRowRequest) returns (ReadModifyWriteRowResponse)

Modifies a row atomically on the server. The method reads the latest existing timestamp and value from the specified columns and writes a new entry based on pre-defined read/modify/write rules. The new value for the timestamp is the greater of the existing timestamp or the current server time. The method returns the new contents of all modified cells.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-platform

For more information, see theAuthentication Overview.

ReadRows

rpc ReadRows(ReadRowsRequest) returns (ReadRowsResponse)

Streams back the contents of all requested rows in key order, optionally applying the same Reader filter to each. Depending on their size, rows and cells may be broken up across multiple responses, but atomicity of each row will still be preserved. See the ReadRowsResponse documentation for details.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/bigtable.data.readonly
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data.readonly
  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/cloud-platform.read-only

For more information, see theAuthentication Overview.

SampleRowKeys

rpc SampleRowKeys(SampleRowKeysRequest) returns (SampleRowKeysResponse)

Returns a sample of row keys in the table. The returned row keys will delimit contiguous sections of the table of approximately equal size, which can be used to break up the data for distributed tasks like mapreduces.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigtable.data
  • https://www.googleapis.com/auth/bigtable.data.readonly
  • https://www.googleapis.com/auth/cloud-bigtable.data
  • https://www.googleapis.com/auth/cloud-bigtable.data.readonly
  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/cloud-platform.read-only

For more information, see theAuthentication Overview.

ArrayValue

ArrayValue is an ordered list ofValue.

Fields
values[]

Value

The ordered elements in the array.

Cell

Specifies (some of) the contents of a single row/column/timestamp of a table.

Fields
timestamp_micros

int64

The cell's stored timestamp, which also uniquely identifies it within its column. Values are always expressed in microseconds, but individual tables may set a coarser granularity to further restrict the allowed values. For example, a table which specifies millisecond granularity will only allow values oftimestamp_micros which are multiples of 1000.

value

bytes

The value stored in the cell. May contain any byte string, including the empty string, up to 100MiB in length.

labels[]

string

Labels applied to the cell by aRowFilter.

CheckAndMutateRowRequest

Request message for Bigtable.CheckAndMutateRow.

Fields
table_name

string

Optional. The unique name of the table to which the conditional mutation should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires one or more of the followingIAM permissions on the specified resourcetableName:

  • bigtable.tables.mutateRows
  • bigtable.tables.readRows
authorized_view_name

string

Optional. The unique name of the AuthorizedView to which the conditional mutation should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires one or more of the followingIAM permissions on the specified resourceauthorizedViewName:

  • bigtable.tables.mutateRows
  • bigtable.authorizedViews.readRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

row_key

bytes

Required. The key of the row to which the conditional mutation should be applied.

predicate_filter

RowFilter

The filter to be applied to the contents of the specified row. Depending on whether or not any results are yielded, eithertrue_mutations orfalse_mutations will be executed. If unset, checks that the row contains any values at all.

true_mutations[]

Mutation

Changes to be atomically applied to the specified row ifpredicate_filter yields at least one cell when applied torow_key. Entries are applied in order, meaning that earlier mutations can be masked by later ones. Must contain at least one entry iffalse_mutations is empty, and at most 100000.

false_mutations[]

Mutation

Changes to be atomically applied to the specified row ifpredicate_filter does not yield any cells when applied torow_key. Entries are applied in order, meaning that earlier mutations can be masked by later ones. Must contain at least one entry iftrue_mutations is empty, and at most 100000.

CheckAndMutateRowResponse

Response message for Bigtable.CheckAndMutateRow.

Fields
predicate_matched

bool

Whether or not the request'spredicate_filter yielded any results for the specified row.

Column

Specifies (some of) the contents of a single row/column intersection of a table.

Fields
qualifier

bytes

The unique key which identifies this column within its family. This is the same key that's used to identify the column in, for example, a RowFilter which sets itscolumn_qualifier_regex_filter field. May contain any byte string, including the empty string, up to 16kiB in length.

cells[]

Cell

Must not be empty. Sorted in order of decreasing "timestamp_micros".

ColumnMetadata

Describes a column in a Bigtable Query Language result set.

Fields
name

string

The name of the column.

type

Type

The type of the column.

ColumnRange

Specifies a contiguous range of columns within a single column family. The range spans from <column_family>:<start_qualifier> to <column_family>:<end_qualifier>, where both bounds can be either inclusive or exclusive.

Fields
family_name

string

The name of the column family within which this range falls.

Union fieldstart_qualifier. The column qualifier at which to start the range (withincolumn_family). If neither field is set, interpreted as the empty string, inclusive.start_qualifier can be only one of the following:
start_qualifier_closed

bytes

Used when giving an inclusive lower bound for the range.

start_qualifier_open

bytes

Used when giving an exclusive lower bound for the range.

Union fieldend_qualifier. The column qualifier at which to end the range (withincolumn_family). If neither field is set, interpreted as the infinite string, exclusive.end_qualifier can be only one of the following:
end_qualifier_closed

bytes

Used when giving an inclusive upper bound for the range.

end_qualifier_open

bytes

Used when giving an exclusive upper bound for the range.

ExecuteQueryRequest

Request message for Bigtable.ExecuteQuery

Fields
instance_name

string

Required. The unique name of the instance against which the query should be executed. Values are of the formprojects/<project>/instances/<instance>

Authorization requires the followingIAM permission on the specified resourceinstanceName:

  • bigtable.instances.executeQuery
app_profile_id

string

Optional. This value specifies routing for replication. If not specified, thedefault application profile will be used.

query
(deprecated)

string

This item is deprecated!

Required. The query string.

Exactly one ofquery andprepared_query is required. Setting both or neither is anINVALID_ARGUMENT.

prepared_query

bytes

A prepared query that was returned fromPrepareQueryResponse.

Exactly one ofquery andprepared_query is required. Setting both or neither is anINVALID_ARGUMENT.

Setting this field also places restrictions on several other fields: -data_format must be empty. -validate_only must be false. -params must match theparam_types set in thePrepareQueryRequest.

resume_token

bytes

Optional. If this request is resuming a previously interrupted query execution,resume_token should be copied from the last PartialResultSet yielded before the interruption. Doing this enables the query execution to resume where the last one left off. The rest of the request parameters must exactly match the request that yielded this token. Otherwise the request will fail.

params

map<string,Value>

Required. params contains string type keys and Bigtable type values that bind to placeholders in the query string. In query string, a parameter placeholder consists of the@ character followed by the parameter name (for example,@firstName) in the query string.

For example, ifparams["firstName"] = bytes_value: "foo" type {bytes_type {}} then@firstName will be replaced with googlesql bytes value "foo" in the query string during query evaluation.

IfValue.kind is not set, the value is treated as a NULL value of the given type. For example, ifparams["firstName"] = type {string_type {}} then@firstName will be replaced with googlesql null string.

Ifquery is set, any emptyValue.type in the map will be rejected withINVALID_ARGUMENT.

Ifprepared_query is set, any emptyValue.type in the map will be inferred from theparam_types in thePrepareQueryRequest. Any non-emptyValue.type must match the correspondingparam_types entry, or be rejected withINVALID_ARGUMENT.

Union fielddata_format. Requested data format for the response.

Ifprepared_query is set, then thedata_format is fixed by thePrepareQueryRequest, and a non-emptydata_format in theExecuteQueryRequest will be rejected withINVALID_ARGUMENT.data_format can be only one of the following:

proto_format
(deprecated)

ProtoFormat

This item is deprecated!

Protocol buffer format as described by ProtoSchema and ProtoRows messages.

ExecuteQueryResponse

Response message for Bigtable.ExecuteQuery

Fields
Union fieldresponse. The first response streamed from the server is of typeResultSetMetadata and includes information about the columns and types of the result set. From there on, we streamPartialResultSet messages with no additional information.PartialResultSet will containresume_token to restart the response if query interrupts. In case of resumption withresume_token, the server will not resend the ResultSetMetadata.response can be only one of the following:
metadata

ResultSetMetadata

Structure of rows in this response stream. The first (and only the first) response streamed from the server will be of this type.

results

PartialResultSet

A partial result set with row data potentially including additional instructions on how recent past and future partial responses should be interpreted.

Family

Specifies (some of) the contents of a single row/column family intersection of a table.

Fields
name

string

The unique key which identifies this family within its row. This is the same key that's used to identify the family in, for example, a RowFilter which sets its "family_name_regex_filter" field. Must match[-_.a-zA-Z0-9]+, except that AggregatingRowProcessors may produce cells in a sentinel family with an empty name. Must be no greater than 64 characters in length.

columns[]

Column

Must not be empty. Sorted in order of increasing "qualifier".

FullReadStatsView

FullReadStatsView captures all known information about a read.

Fields
read_iteration_stats

ReadIterationStats

Iteration stats describe how efficient the read is, e.g. comparing rows seen vs. rows returned or cells seen vs cells returned can provide an indication of read efficiency (the higher the ratio of seen to retuned the better).

request_latency_stats

RequestLatencyStats

Request latency stats describe the time taken to complete a request, from the server side.

GenerateInitialChangeStreamPartitionsRequest

NOTE: This API is intended to be used by Apache Beam BigtableIO. Request message for Bigtable.GenerateInitialChangeStreamPartitions.

Fields
table_name

string

Required. The unique name of the table from which to get change stream partitions. Values are of the formprojects/<project>/instances/<instance>/tables/<table>. Change streaming must be enabled on the table.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.readRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used. Single cluster routing must be configured on the profile.

GenerateInitialChangeStreamPartitionsResponse

NOTE: This API is intended to be used by Apache Beam BigtableIO. Response message for Bigtable.GenerateInitialChangeStreamPartitions.

Fields
partition

StreamPartition

A partition of the change stream.

MutateRowRequest

Request message for Bigtable.MutateRow.

Fields
table_name

string

Optional. The unique name of the table to which the mutation should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.mutateRows
authorized_view_name

string

Optional. The unique name of the AuthorizedView to which the mutation should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires the followingIAM permission on the specified resourceauthorizedViewName:

  • bigtable.authorizedViews.mutateRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

row_key

bytes

Required. The key of the row to which the mutation should be applied.

mutations[]

Mutation

Required. Changes to be atomically applied to the specified row. Entries are applied in order, meaning that earlier mutations can be masked by later ones. Must contain at least one entry and at most 100000.

MutateRowResponse

This type has no fields.

Response message for Bigtable.MutateRow.

MutateRowsRequest

Request message for BigtableService.MutateRows.

Fields
table_name

string

Optional. The unique name of the table to which the mutations should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.mutateRows
authorized_view_name

string

Optional. The unique name of the AuthorizedView to which the mutations should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires the followingIAM permission on the specified resourceauthorizedViewName:

  • bigtable.authorizedViews.mutateRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

entries[]

Entry

Required. The row keys and corresponding mutations to be applied in bulk. Each entry is applied as an atomic mutation, but the entries may be applied in arbitrary order (even between entries for the same row). At least one entry must be specified, and in total the entries can contain at most 100000 mutations.

Entry

A mutation for a given row.

Fields
row_key

bytes

The key of the row to which themutations should be applied.

mutations[]

Mutation

Required. Changes to be atomically applied to the specified row. Mutations are applied in order, meaning that earlier mutations can be masked by later ones. You must specify at least one mutation.

MutateRowsResponse

Response message for BigtableService.MutateRows.

Fields
entries[]

Entry

One or more results for Entries from the batch request.

rate_limit_info

RateLimitInfo

Information about how client should limit the rate (QPS). Primirily used by supported official Cloud Bigtable clients. If unset, the rate limit info is not provided by the server.

Entry

The result of applying a passed mutation in the original request.

Fields
index

int64

The index into the original request'sentries list of the Entry for which a result is being reported.

status

Status

The result of the request Entry identified byindex. Depending on how requests are batched during execution, it is possible for one Entry to fail due to an error with another Entry. In the event that this occurs, the same error will be reported for both entries.

Mutation

Specifies a particular change to be made to the contents of a row.

Fields
Union fieldmutation. Which of the possible Mutation types to apply.mutation can be only one of the following:
set_cell

SetCell

Set a cell's value.

add_to_cell

AddToCell

Incrementally updates anAggregate cell.

merge_to_cell

MergeToCell

Merges accumulated state to anAggregate cell.

delete_from_column

DeleteFromColumn

Deletes cells from a column.

delete_from_family

DeleteFromFamily

Deletes cells from a column family.

delete_from_row

DeleteFromRow

Deletes cells from the entire row.

AddToCell

A Mutation which incrementally updates a cell in anAggregate family.

Fields
family_name

string

The name of theAggregate family into which new data should be added. This must be a family with avalue_type ofAggregate. Format:[-_.a-zA-Z0-9]+

column_qualifier

Value

The qualifier of the column into which new data should be added. This must be araw_value.

timestamp

Value

The timestamp of the cell to which new data should be added. This must be araw_timestamp_micros that matches the table'sgranularity.

input

Value

The input value to be accumulated into the specified cell. This must be compatible with the family'svalue_type.input_type.

DeleteFromColumn

A Mutation which deletes cells from the specified column, optionally restricting the deletions to a given timestamp range.

Fields
family_name

string

The name of the family from which cells should be deleted. Must match[-_.a-zA-Z0-9]+

column_qualifier

bytes

The qualifier of the column from which cells should be deleted. Can be any byte string, including the empty string.

time_range

TimestampRange

The range of timestamps within which cells should be deleted.

DeleteFromFamily

A Mutation which deletes all cells from the specified column family.

Fields
family_name

string

The name of the family from which cells should be deleted. Must match[-_.a-zA-Z0-9]+

DeleteFromRow

This type has no fields.

A Mutation which deletes all cells from the containing row.

MergeToCell

A Mutation which merges accumulated state into a cell in anAggregate family.

Fields
family_name

string

The name of theAggregate family into which new data should be added. This must be a family with avalue_type ofAggregate. Format:[-_.a-zA-Z0-9]+

column_qualifier

Value

The qualifier of the column into which new data should be added. This must be araw_value.

timestamp

Value

The timestamp of the cell to which new data should be added. This must be araw_timestamp_micros that matches the table'sgranularity.

input

Value

The input value to be merged into the specified cell. This must be compatible with the family'svalue_type.state_type. MergingNULL is allowed, but has no effect.

SetCell

A Mutation which sets the value of the specified cell.

Fields
family_name

string

The name of the family into which new data should be written. Must match[-_.a-zA-Z0-9]+

column_qualifier

bytes

The qualifier of the column into which new data should be written. Can be any byte string, including the empty string.

timestamp_micros

int64

The timestamp of the cell into which new data should be written. Use -1 for current Bigtable server time. Otherwise, the client should set this value itself, noting that the default value is a timestamp of zero if the field is left unspecified. Values must match the granularity of the table (e.g. micros, millis).

value

bytes

The value to be written into the specified cell.

PartialResultSet

A partial result set from the streaming query API. Cloud Bigtable clients buffer partial results received in this message until aresume_token is received.

The pseudocode below describes how to buffer and parse a stream ofPartialResultSet messages.

Having: - queue of row results waiting to be returnedqueue - extensible buffer of bytesbuffer - a place to keep track of the most recentresume_token for each PartialResultSetp received { if p.reset { ensurequeue is empty ensurebuffer is empty } if p.estimated_batch_size != 0 { (optional) ensurebuffer is sized to at leastp.estimated_batch_size } ifp.proto_rows_batch is set { appendp.proto_rows_batch.bytes tobuffer } if p.batch_checksum is set andbuffer is not empty { validate the checksum matches the contents ofbuffer (see comments onbatch_checksum) parsebuffer asProtoRows message, clearingbuffer add parsed rows to end ofqueue } if p.resume_token is set { release results inqueue savep.resume_token inresume_token } }

Fields
resume_token

bytes

An opaque token sent by the server to allow query resumption and signal that the buffered values constructed from receivedpartial_rows can be yielded to the caller. Clients can provide this token in a subsequent request to resume the result stream from the current point.

Whenresume_token is non-empty, the buffered values received frompartial_rows since the last non-emptyresume_token can be yielded to the callers, provided that the client keeps the value ofresume_token and uses it on subsequent retries.

Aresume_token may be sent without information inpartial_rows to checkpoint the progress of a sparse query. Any previouspartial_rows data should still be yielded in this case, and the newresume_token should be saved for future retries as normal.

Aresume_token will only be sent on a boundary where there is either no ongoing result batch, orbatch_checksum is also populated.

The server will also send a sentinelresume_token when last batch ofpartial_rows is sent. If the client retries the ExecuteQueryRequest with the sentinelresume_token, the server will emit it again without any data inpartial_rows, then return OK.

reset

bool

Iftrue, any data buffered since the last non-emptyresume_token must be discarded before the other parts of this message, if any, are handled.

estimated_batch_size

int32

Estimated size of the buffer required to hold the next batch of results.

This value will be sent with the firstpartial_rows of a batch. That is, on the firstpartial_rows received in a stream, on the first message after abatch_checksum message, and any timereset is true.

The client can use this estimate to allocate a buffer for the next batch of results. This helps minimize the number of allocations required, though the buffer size may still need to be increased if the estimate is too low.

Union fieldpartial_rows. Some rows of the result set in one of the supported formats.

MultiplePartialResultSet messages may be sent to represent a complete response. The client should buffer data constructed from the fields inpartial_rows until a non-emptyresume_token is received. Each sub-message documents the appropriate way to combine results.partial_rows can be only one of the following:

proto_rows_batch

ProtoRowsBatch

Partial rows in serialized ProtoRows format.

batch_checksum

uint32

CRC32C checksum of concatenatedpartial_rows data for the current batch.

When present, the buffered data frompartial_rows forms a complete parseable message of the appropriate type.

The client should mark the end of a parseable message and prepare to receive a new one starting from the nextPartialResultSet message. Clients must verify the checksum of the serialized batch before yielding it to the caller.

This does NOT mean the values can be yielded to the callers since aresume_token is required to safely do so.

Ifresume_token is non-empty and any data has been received since the last one, this field is guaranteed to be non-empty. In other words, clients may assume that a batch will never cross aresume_token boundary.

PingAndWarmRequest

Request message for client connection keep-alive and warming.

Fields
name

string

Required. The unique name of the instance to check permissions for as well as respond. Values are of the formprojects/<project>/instances/<instance>.

Authorization requires the followingIAM permission on the specified resourcename:

  • bigtable.instances.ping
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

PingAndWarmResponse

This type has no fields.

Response message for Bigtable.PingAndWarm connection keepalive and warming.

PrepareQueryRequest

Request message for Bigtable.PrepareQuery

Fields
instance_name

string

Required. The unique name of the instance against which the query should be executed. Values are of the formprojects/<project>/instances/<instance>

Authorization requires the followingIAM permission on the specified resourceinstanceName:

  • bigtable.instances.executeQuery
app_profile_id

string

Optional. This value specifies routing for preparing the query. Note that thisapp_profile_id is only used for preparing the query. The actual query execution will use the app profile specified in theExecuteQueryRequest. If not specified, thedefault application profile will be used.

query

string

Required. The query string.

param_types

map<string,Type>

Required.param_types is a map of parameter identifier strings to theirTypes.

In query string, a parameter placeholder consists of the@ character followed by the parameter name (for example,@firstName) in the query string.

For example, if param_types["firstName"] = Bytes then @firstName will be a query parameter of type Bytes. The specificValue to be used for the query execution must be sent inExecuteQueryRequest in theparams map.

Union fielddata_format. Required. Requested data format for the response. Note that the selected data format is binding for allExecuteQuery rpcs that use the prepared query.data_format can be only one of the following:
proto_format

ProtoFormat

Protocol buffer format as described by ProtoSchema and ProtoRows messages.

PrepareQueryResponse

Response message for Bigtable.PrepareQueryResponse

Fields
metadata

ResultSetMetadata

Structure of rows in the response stream ofExecuteQueryResponse for the returnedprepared_query.

prepared_query

bytes

A serialized prepared query. Clients should treat this as an opaque blob of bytes to send inExecuteQueryRequest.

valid_until

Timestamp

The time at which the prepared query token becomes invalid. A token may become invalid early due to changes in the data being read, but it provides a guideline to refresh query plans asynchronously.

ProtoFormat

This type has no fields.

Protocol buffers format descriptor, as described by Messages ProtoSchema and ProtoRows

ProtoRows

Rows represented in proto format.

This should be constructed by concatenating thebatch_data from each of the relevantProtoRowsBatch messages and parsing the result as aProtoRows message.

Fields
values[]

Value

A proto rows message consists of a list of values. Every N complete values defines a row, where N is equal to the number of entries in themetadata.proto_schema.columns value received in the first response.

ProtoRowsBatch

A part of a serializedProtoRows message.

Fields
batch_data

bytes

Part of a serializedProtoRows message. A complete, parseable ProtoRows message is constructed by concatenatingbatch_data from multipleProtoRowsBatch messages. ThePartialResultSet that contains the last part hascomplete_batch set totrue.

ProtoSchema

ResultSet schema in proto format

Fields
columns[]

ColumnMetadata

The columns in the result set.

RateLimitInfo

Information about how client should adjust the load to Bigtable.

Fields
period

Duration

Time that clients should wait before adjusting the target rate again. If clients adjust rate too frequently, the impact of the previous adjustment may not have been taken into account and may over-throttle or under-throttle. If clients adjust rate too slowly, they will not be responsive to load changes on server side, and may over-throttle or under-throttle.

factor

double

If it has been at least oneperiod since the last load adjustment, the client should multiply the current load by this value to get the new target load. For example, if the current load is 100 andfactor is 0.8, the new target load should be 80. After adjusting, the client should ignorefactor until anotherperiod has passed.

The client can measure its load using any unit that's comparable over time. For example, QPS can be used as long as each request involves a similar amount of work.

ReadChangeStreamRequest

NOTE: This API is intended to be used by Apache Beam BigtableIO. Request message for Bigtable.ReadChangeStream.

Fields
table_name

string

Required. The unique name of the table from which to read a change stream. Values are of the formprojects/<project>/instances/<instance>/tables/<table>. Change streaming must be enabled on the table.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.readRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used. Single cluster routing must be configured on the profile.

partition

StreamPartition

The partition to read changes from.

end_time

Timestamp

If specified, OK will be returned when the stream advances beyond this time. Otherwise, changes will be continuously delivered on the stream. This value is inclusive and will be truncated to microsecond granularity.

heartbeat_duration

Duration

If specified, the duration betweenHeartbeat messages on the stream. Otherwise, defaults to 5 seconds.

Union fieldstart_from. Options for describing where we want to start reading from the stream.start_from can be only one of the following:
start_time

Timestamp

Start reading the stream at the specified timestamp. This timestamp must be within the change stream retention period, less than or equal to the current time, and after change stream creation, whichever is greater. This value is inclusive and will be truncated to microsecond granularity.

continuation_tokens

StreamContinuationTokens

Tokens that describe how to resume reading a stream where reading previously left off. If specified, changes will be read starting at the the position. Tokens are delivered on the stream as part ofHeartbeat andCloseStream messages.

If a single token is provided, the token's partition must exactly match the request's partition. If multiple tokens are provided, as in the case of a partition merge, the union of the token partitions must exactly cover the request's partition. Otherwise, INVALID_ARGUMENT will be returned.

ReadChangeStreamResponse

NOTE: This API is intended to be used by Apache Beam BigtableIO. Response message for Bigtable.ReadChangeStream.

Fields
Union fieldstream_record. The data or control message on the stream.stream_record can be only one of the following:
data_change

DataChange

A mutation to the partition.

heartbeat

Heartbeat

A periodic heartbeat message.

close_stream

CloseStream

An indication that the stream should be closed.

CloseStream

A message indicating that the client should stop reading from the stream. If status is OK andcontinuation_tokens &new_partitions are empty, the stream has finished (for example if there was anend_time specified). Ifcontinuation_tokens &new_partitions are present, then a change in partitioning requires the client to open a new stream for each token to resume reading. Example:

                                 [B,      D) ends                                      |                                      v              new_partitions:  [A,  C) [C,  E)continuation_tokens.partitions:  [B,C) [C,D)                                 ^---^ ^---^                                 ^     ^                                 |     |                                 |     StreamContinuationToken 2                                 |                                 StreamContinuationToken 1

To read the new partition [A,C), supply the continuation tokens whose ranges cover the new partition, for example ContinuationToken[A,B) & ContinuationToken[B,C).

Fields
status

Status

The status of the stream.

continuation_tokens[]

StreamContinuationToken

If non-empty, contains the information needed to resume reading their associated partitions.

new_partitions[]

StreamPartition

If non-empty, contains the new partitions to start reading from, which are related to but not necessarily identical to the partitions for the abovecontinuation_tokens.

DataChange

A message corresponding to one or more mutations to the partition being streamed. A single logicalDataChange message may also be split across a sequence of multiple individual messages. Messages other than the first in a sequence will only have thetype andchunks fields populated, with the final message in the sequence also containingdone set to true.

Fields
type

Type

The type of the mutation.

source_cluster_id

string

The cluster where the mutation was applied. Not set whentype isGARBAGE_COLLECTION.

row_key

bytes

The row key for all mutations that are part of thisDataChange. If theDataChange is chunked across multiple messages, then this field will only be set for the first message.

commit_timestamp

Timestamp

The timestamp at which the mutation was applied on the Bigtable server.

tiebreaker

int32

A value that lets stream consumers reconstruct Bigtable's conflict resolution semantics.https://cloud.google.com/bigtable/docs/writes#conflict-resolution In the event that the same row key, column family, column qualifier, timestamp are modified on different clusters at the samecommit_timestamp, the mutation with the largertiebreaker will be the one chosen for the eventually consistent state of the system.

chunks[]

MutationChunk

The mutations associated with this change to the partition. May contain complete mutations or chunks of a multi-message chunkedDataChange record.

done

bool

When true, indicates that the entireDataChange has been read and the client can safely process the message.

token

string

An encoded position for this stream's partition to restart reading from. This token is for the StreamPartition from the request.

estimated_low_watermark

Timestamp

An estimate of the commit timestamp that is usually lower than or equal to any timestamp for a record that will be delivered in the future on the stream. It is possible that, under particular circumstances that a future record has a timestamp that is lower than a previously seen timestamp. For an example usage seehttps://beam.apache.org/documentation/basics/#watermarks

Type

The type of mutation.

Enums
TYPE_UNSPECIFIEDThe type is unspecified.
USERA user-initiated mutation.
GARBAGE_COLLECTIONA system-initiated mutation as part of garbage collection.https://cloud.google.com/bigtable/docs/garbage-collection
CONTINUATIONThis is a continuation of a multi-message change.

Heartbeat

A periodic message with information that can be used to checkpoint the state of a stream.

Fields
continuation_token

StreamContinuationToken

A token that can be provided to a subsequentReadChangeStream call to pick up reading at the current stream position.

estimated_low_watermark

Timestamp

An estimate of the commit timestamp that is usually lower than or equal to any timestamp for a record that will be delivered in the future on the stream. It is possible that, under particular circumstances that a future record has a timestamp that is lower than a previously seen timestamp. For an example usage seehttps://beam.apache.org/documentation/basics/#watermarks

MutationChunk

A partial or complete mutation.

Fields
chunk_info

ChunkInfo

If set, then the mutation is aSetCell with a chunked value across multiple messages.

mutation

Mutation

If this is a continuation of a chunked message (chunked_value_offset > 0), ignore all fields except theSetCell's value and merge it with the previous message by concatenating the value fields.

ChunkInfo

Information about the chunking of this mutation. OnlySetCell mutations can be chunked, and all chunks for aSetCell will be delivered contiguously with no other mutation types interleaved.

Fields
chunked_value_size

int32

The total value size of all the chunks that make up theSetCell.

chunked_value_offset

int32

The byte offset of this chunk into the total value size of the mutation.

last_chunk

bool

When true, this is the last chunk of a chunkedSetCell.

ReadIterationStats

ReadIterationStats captures information about the iteration of rows or cells over the course of a read, e.g. how many results were scanned in a read operation versus the results returned.

Fields
rows_seen_count

int64

The rows seen (scanned) as part of the request. This includes the count of rows returned, as captured below.

rows_returned_count

int64

The rows returned as part of the request.

cells_seen_count

int64

The cells seen (scanned) as part of the request. This includes the count of cells returned, as captured below.

cells_returned_count

int64

The cells returned as part of the request.

ReadModifyWriteRowRequest

Request message for Bigtable.ReadModifyWriteRow.

Fields
table_name

string

Optional. The unique name of the table to which the read/modify/write rules should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.mutateRows
authorized_view_name

string

Optional. The unique name of the AuthorizedView to which the read/modify/write rules should be applied.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires the followingIAM permission on the specified resourceauthorizedViewName:

  • bigtable.authorizedViews.mutateRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

row_key

bytes

Required. The key of the row to which the read/modify/write rules should be applied.

rules[]

ReadModifyWriteRule

Required. Rules specifying how the specified row's contents are to be transformed into writes. Entries are applied in order, meaning that earlier rules will affect the results of later ones. At least one entry must be specified, and there can be at most 100000 rules.

ReadModifyWriteRowResponse

Response message for Bigtable.ReadModifyWriteRow.

Fields
row

Row

A Row containing the new contents of all cells modified by the request.

ReadModifyWriteRule

Specifies an atomic read/modify/write operation on the latest value of the specified column.

Fields
family_name

string

The name of the family to which the read/modify/write should be applied. Must match[-_.a-zA-Z0-9]+

column_qualifier

bytes

The qualifier of the column to which the read/modify/write should be applied. Can be any byte string, including the empty string.

Union fieldrule. The rule used to determine the column's new latest value from its current latest value.rule can be only one of the following:
append_value

bytes

Rule specifying thatappend_value be appended to the existing value. If the targeted cell is unset, it will be treated as containing the empty string.

increment_amount

int64

Rule specifying thatincrement_amount be added to the existing value. If the targeted cell is unset, it will be treated as containing a zero. Otherwise, the targeted cell must contain an 8-byte value (interpreted as a 64-bit big-endian signed integer), or the entire request will fail.

ReadRowsRequest

Request message for Bigtable.ReadRows.

Fields
table_name

string

Optional. The unique name of the table from which to read.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.readRows
authorized_view_name

string

Optional. The unique name of the AuthorizedView from which to read.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires the followingIAM permission on the specified resourceauthorizedViewName:

  • bigtable.authorizedViews.readRows
materialized_view_name

string

Optional. The unique name of the MaterializedView from which to read.

Values are of the formprojects/<project>/instances/<instance>/materializedViews/<materialized_view>.

Authorization requires the followingIAM permission on the specified resourcematerializedViewName:

  • bigtable.materializedViews.readRows
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

rows

RowSet

The row keys and/or ranges to read sequentially. If not specified, reads from all rows.

filter

RowFilter

The filter to apply to the contents of the specified row(s). If unset, reads the entirety of each row.

rows_limit

int64

The read will stop after committing to N rows' worth of results. The default (zero) is to return all results.

request_stats_view

RequestStatsView

The view into RequestStats, as described above.

reversed

bool

Experimental API - Please note that this API is currently experimental and can change in the future.

Return rows in lexiographical descending order of the row keys. The row contents will not be affected by this flag.

Example result set:

[  {key: "k2", "f:col1": "v1", "f:col2": "v1"},  {key: "k1", "f:col1": "v2", "f:col2": "v2"}]

RequestStatsView

The desired view into RequestStats that should be returned in the response.

See also: RequestStats message.

Enums
REQUEST_STATS_VIEW_UNSPECIFIEDThe default / unset value. The API will default to the NONE option below.
REQUEST_STATS_NONEDo not include any RequestStats in the response. This will leave the RequestStats embedded message unset in the response.
REQUEST_STATS_FULLInclude the full set of available RequestStats in the response, applicable to this read.

ReadRowsResponse

Response message for Bigtable.ReadRows.

Fields
chunks[]

CellChunk

A collection of a row's contents as part of the read request.

last_scanned_row_key

bytes

Optionally the server might return the row key of the last row it has scanned. The client can use this to construct a more efficient retry request if needed: any row keys or portions of ranges less than this row key can be dropped from the request. This is primarily useful for cases where the server has read a lot of data that was filtered out since the last committed row key, allowing the client to skip that work on a retry.

request_stats

RequestStats

If requested, return enhanced query performance statistics. The field request_stats is empty in a streamed response unless the ReadRowsResponse message contains request_stats in the last message of the stream. Always returned when requested, even when the read request returns an empty response.

CellChunk

Specifies a piece of a row's contents returned as part of the read response stream.

Fields
row_key

bytes

The row key for this chunk of data. If the row key is empty, this CellChunk is a continuation of the same row as the previous CellChunk in the response stream, even if that CellChunk was in a previous ReadRowsResponse message.

family_name

StringValue

The column family name for this chunk of data. If this message is not present this CellChunk is a continuation of the same column family as the previous CellChunk. The empty string can occur as a column family name in a response so clients must check explicitly for the presence of this message, not just forfamily_name.value being non-empty.

qualifier

BytesValue

The column qualifier for this chunk of data. If this message is not present, this CellChunk is a continuation of the same column as the previous CellChunk. Column qualifiers may be empty so clients must check for the presence of this message, not just forqualifier.value being non-empty.

timestamp_micros

int64

The cell's stored timestamp, which also uniquely identifies it within its column. Values are always expressed in microseconds, but individual tables may set a coarser granularity to further restrict the allowed values. For example, a table which specifies millisecond granularity will only allow values oftimestamp_micros which are multiples of 1000. Timestamps are only set in the first CellChunk per cell (for cells split into multiple chunks).

labels[]

string

Labels applied to the cell by aRowFilter. Labels are only set on the first CellChunk per cell.

value

bytes

The value stored in the cell. Cell values can be split across multiple CellChunks. In that case only the value field will be set in CellChunks after the first: the timestamp and labels will only be present in the first CellChunk, even if the first CellChunk came in a previous ReadRowsResponse.

value_size

int32

If this CellChunk is part of a chunked cell value and this is not the final chunk of that cell, value_size will be set to the total length of the cell value. The client can use this size to pre-allocate memory to hold the full cell value.

Union fieldrow_status. Signals to the client concerning previous CellChunks received.row_status can be only one of the following:
reset_row

bool

Indicates that the client should drop all previous chunks forrow_key, as it will be re-read from the beginning.

commit_row

bool

Indicates that the client can safely process all previous chunks forrow_key, as its data has been fully read.

RequestLatencyStats

RequestLatencyStats provides a measurement of the latency of the request as it interacts with different systems over its lifetime, e.g. how long the request took to execute within a frontend server.

Fields
frontend_server_latency

Duration

The latency measured by the frontend server handling this request, from when the request was received, to when this value is sent back in the response. For more context on the component that is measuring this latency, see:https://cloud.google.com/bigtable/docs/overview

Note: This value may be slightly shorter than the value reported into aggregate latency metrics in Monitoring for this request (https://cloud.google.com/bigtable/docs/monitoring-instance) as this value needs to be sent in the response before the latency measurement including that transmission is finalized.

Note: This value includes the end-to-end latency of contacting nodes in the targeted cluster, e.g. measuring from when the first byte arrives at the frontend server, to when this value is sent back as the last value in the response, including any latency incurred by contacting nodes, waiting for results from nodes, and finally sending results from nodes back to the caller.

RequestStats

RequestStats is the container for additional information pertaining to a single request, helpful for evaluating the performance of the sent request. Currently, the following method is supported: google.bigtable.v2.ReadRows

Fields

Union fieldstats_view. Information pertaining to each request type received. The type is chosen based on the requested view.

See the messages above for additional context.stats_view can be only one of the following:

full_read_stats_view

FullReadStatsView

Available with the ReadRowsRequest.RequestStatsView.REQUEST_STATS_FULL view, see package google.bigtable.v2.

ResponseParams

Response metadata proto

Fields
zone_id

string

The cloud bigtable zone associated with the cluster.

cluster_id

string

Identifier for a cluster that represents set of bigtable resources.

afe_id

int64

The AFE ID for the AFE that is served this request.

ResultSetMetadata

Describes the structure of a Bigtable result set.

Fields
Union fieldschema. The schema of the ResultSet, contains ordered list of column names with typesschema can be only one of the following:
proto_schema

ProtoSchema

Schema in proto format

Row

Specifies the complete (requested) contents of a single row of a table. Rows which exceed 256MiB in size cannot be read in full.

Fields
key

bytes

The unique key which identifies this row within its table. This is the same key that's used to identify the row in, for example, a MutateRowRequest. May contain any non-empty byte string up to 4KiB in length.

families[]

Family

May be empty, but only if the entire row is empty. The mutual ordering of column families is not specified.

RowFilter

Takes a row as input and produces an alternate view of the row based on specified rules. For example, a RowFilter might trim down a row to include just the cells from columns matching a given regular expression, or might return all the cells of a row but not their values. More complicated filters can be composed out of these components to express requests such as, "within every column of a particular family, give just the two most recent cells which are older than timestamp X."

There are two broad categories of RowFilters (true filters and transformers), as well as two ways to compose simple filters into more complex ones (chains and interleaves). They work as follows:

  • True filters alter the input row by excluding some of its cells wholesale from the output row. An example of a true filter is thevalue_regex_filter, which excludes cells whose values don't match the specified pattern. All regex true filters use RE2 syntax (https://github.com/google/re2/wiki/Syntax) in raw byte mode (RE2::Latin1), and are evaluated as full matches. An important point to keep in mind is thatRE2(.) is equivalent by default toRE2([^\n]), meaning that it does not match newlines. When attempting to match an arbitrary byte, you should therefore use the escape sequence\C, which may need to be further escaped as\\C in your client language.

  • Transformers alter the input row by changing the values of some of its cells in the output, without excluding them completely. Currently, the only supported transformer is thestrip_value_transformer, which replaces every cell's value with the empty string.

  • Chains and interleaves are described in more detail in the RowFilter.Chain and RowFilter.Interleave documentation.

The total serialized size of a RowFilter message must not exceed 20480 bytes, and RowFilters may not be nested within each other (in Chains or Interleaves) to a depth of more than 20.

Fields
Union fieldfilter. Which of the possible RowFilter types to apply. If none are set, this RowFilter returns all cells in the input row.filter can be only one of the following:
chain

Chain

Applies several RowFilters to the data in sequence, progressively narrowing the results.

interleave

Interleave

Applies several RowFilters to the data in parallel and combines the results.

condition

Condition

Applies one of two possible RowFilters to the data based on the output of a predicate RowFilter.

sink

bool

ADVANCED USE ONLY. Hook for introspection into the RowFilter. Outputs all cells directly to the output of the read rather than to any parent filter. Consider the following example:

Chain(  FamilyRegex("A"),  Interleave(    All(),    Chain(Label("foo"), Sink())  ),  QualifierRegex("B"))                    A,A,1,w                    A,B,2,x                    B,B,4,z                       |                FamilyRegex("A")                       |                    A,A,1,w                    A,B,2,x                       |          +------------+-------------+          |                          |        All()                    Label(foo)          |                          |       A,A,1,w              A,A,1,w,labels:[foo]       A,B,2,x              A,B,2,x,labels:[foo]          |                          |          |                        Sink() --------------+          |                          |                  |          +------------+      x------+          A,A,1,w,labels:[foo]                       |                        A,B,2,x,labels:[foo]                    A,A,1,w                             |                    A,B,2,x                             |                       |                                |               QualifierRegex("B")                      |                       |                                |                    A,B,2,x                             |                       |                                |                       +--------------------------------+                       |                    A,A,1,w,labels:[foo]                    A,B,2,x,labels:[foo]  // could be switched                    A,B,2,x               // could be switched

Despite being excluded by the qualifier filter, a copy of every cell that reaches the sink is present in the final result.

As with anInterleave, duplicate cells are possible, and appear in an unspecified mutual order. In this case we have a duplicate with column "A:B" and timestamp 2, because one copy passed through the all filter while the other was passed through the label and sink. Note that one copy has label "foo", while the other does not.

Cannot be used within thepredicate_filter,true_filter, orfalse_filter of aCondition.

pass_all_filter

bool

Matches all cells, regardless of input. Functionally equivalent to leavingfilter unset, but included for completeness.

block_all_filter

bool

Does not match any cells, regardless of input. Useful for temporarily disabling just part of a filter.

row_key_regex_filter

bytes

Matches only cells from rows whose keys satisfy the given RE2 regex. In other words, passes through the entire row when the key matches, and otherwise produces an empty row. Note that, since row keys can contain arbitrary bytes, the\C escape sequence must be used if a true wildcard is desired. The. character will not match the new line character\n, which may be present in a binary key.

row_sample_filter

double

Matches all cells from a row with probability p, and matches no cells from the row with probability 1-p.

family_name_regex_filter

string

Matches only cells from columns whose families satisfy the given RE2 regex. For technical reasons, the regex must not contain the: character, even if it is not being used as a literal. Note that, since column families cannot contain the new line character\n, it is sufficient to use. as a full wildcard when matching column family names.

column_qualifier_regex_filter

bytes

Matches only cells from columns whose qualifiers satisfy the given RE2 regex. Note that, since column qualifiers can contain arbitrary bytes, the\C escape sequence must be used if a true wildcard is desired. The. character will not match the new line character\n, which may be present in a binary qualifier.

column_range_filter

ColumnRange

Matches only cells from columns within the given range.

timestamp_range_filter

TimestampRange

Matches only cells with timestamps within the given range.

value_regex_filter

bytes

Matches only cells with values that satisfy the given regular expression. Note that, since cell values can contain arbitrary bytes, the\C escape sequence must be used if a true wildcard is desired. The. character will not match the new line character\n, which may be present in a binary value.

value_range_filter

ValueRange

Matches only cells with values that fall within the given range.

cells_per_row_offset_filter

int32

Skips the first N cells of each row, matching all subsequent cells. If duplicate cells are present, as is possible when using an Interleave, each copy of the cell is counted separately.

cells_per_row_limit_filter

int32

Matches only the first N cells of each row. If duplicate cells are present, as is possible when using an Interleave, each copy of the cell is counted separately.

cells_per_column_limit_filter

int32

Matches only the most recent N cells within each column. For example, if N=2, this filter would match columnfoo:bar at timestamps 10 and 9, skip all earlier cells infoo:bar, and then begin matching again in columnfoo:bar2. If duplicate cells are present, as is possible when using an Interleave, each copy of the cell is counted separately.

strip_value_transformer

bool

Replaces each cell's value with the empty string.

apply_label_transformer

string

Applies the given label to all cells in the output row. This allows the client to determine which results were produced from which part of the filter.

Values must be at most 15 characters in length, and match the RE2 pattern[a-z0-9\\-]+

Due to a technical limitation, it is not currently possible to apply multiple labels to a cell. As a result, a Chain may have no more than one sub-filter which contains aapply_label_transformer. It is okay for an Interleave to contain multipleapply_label_transformers, as they will be applied to separate copies of the input. This may be relaxed in the future.

Chain

A RowFilter which sends rows through several RowFilters in sequence.

Fields
filters[]

RowFilter

The elements of "filters" are chained together to process the input row: in row -> f(0) -> intermediate row -> f(1) -> ... -> f(N) -> out row The full chain is executed atomically.

Condition

A RowFilter which evaluates one of two possible RowFilters, depending on whether or not a predicate RowFilter outputs any cells from the input row.

IMPORTANT NOTE: The predicate filter does not execute atomically with the true and false filters, which may lead to inconsistent or unexpected results. Additionally, Condition filters have poor performance, especially when filters are set for the false condition.

Fields
predicate_filter

RowFilter

Ifpredicate_filter outputs any cells, thentrue_filter will be evaluated on the input row. Otherwise,false_filter will be evaluated.

true_filter

RowFilter

The filter to apply to the input row ifpredicate_filter returns any results. If not provided, no results will be returned in the true case.

false_filter

RowFilter

The filter to apply to the input row ifpredicate_filter does not return any results. If not provided, no results will be returned in the false case.

Interleave

A RowFilter which sends each row to each of several component RowFilters and interleaves the results.

Fields
filters[]

RowFilter

The elements of "filters" all process a copy of the input row, and the results are pooled, sorted, and combined into a single output row. If multiple cells are produced with the same column and timestamp, they will all appear in the output row in an unspecified mutual order. Consider the following example, with three filters:

                             input row                                 |       -----------------------------------------------------       |                         |                         |      f(0)                      f(1)                      f(2)       |                         |                         |1: foo,bar,10,x             foo,bar,10,z              far,bar,7,a2: foo,blah,11,z            far,blah,5,x              far,blah,5,x       |                         |                         |       -----------------------------------------------------                                 |1:                      foo,bar,10,z   // could have switched with #22:                      foo,bar,10,x   // could have switched with #13:                      foo,blah,11,z4:                      far,bar,7,a5:                      far,blah,5,x   // identical to #66:                      far,blah,5,x   // identical to #5

All interleaved filters are executed atomically.

RowRange

Specifies a contiguous range of rows.

Fields
Union fieldstart_key. The row key at which to start the range. If neither field is set, interpreted as the empty string, inclusive.start_key can be only one of the following:
start_key_closed

bytes

Used when giving an inclusive lower bound for the range.

start_key_open

bytes

Used when giving an exclusive lower bound for the range.

Union fieldend_key. The row key at which to end the range. If neither field is set, interpreted as the infinite row key, exclusive.end_key can be only one of the following:
end_key_open

bytes

Used when giving an exclusive upper bound for the range.

end_key_closed

bytes

Used when giving an inclusive upper bound for the range.

RowSet

Specifies a non-contiguous set of rows.

Fields
row_keys[]

bytes

Single rows included in the set.

row_ranges[]

RowRange

Contiguous row ranges included in the set.

SampleRowKeysRequest

Request message for Bigtable.SampleRowKeys.

Fields
table_name

string

Optional. The unique name of the table from which to sample row keys.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>.

Authorization requires the followingIAM permission on the specified resourcetableName:

  • bigtable.tables.sampleRowKeys
authorized_view_name

string

Optional. The unique name of the AuthorizedView from which to sample row keys.

Values are of the formprojects/<project>/instances/<instance>/tables/<table>/authorizedViews/<authorized_view>.

Authorization requires the followingIAM permission on the specified resourceauthorizedViewName:

  • bigtable.authorizedViews.sampleRowKeys
materialized_view_name

string

Optional. The unique name of the MaterializedView from which to read.

Values are of the formprojects/<project>/instances/<instance>/materializedViews/<materialized_view>.

Authorization requires the followingIAM permission on the specified resourcematerializedViewName:

  • bigtable.materializedViews.sampleRowKeys
app_profile_id

string

This value specifies routing for replication. If not specified, the "default" application profile will be used.

SampleRowKeysResponse

Response message for Bigtable.SampleRowKeys.

Fields
row_key

bytes

Sorted streamed sequence of sample row keys in the table. The table might have contents before the first row key in the list and after the last one, but a key containing the empty string indicates "end of table" and will be the last response given, if present. Note that row keys in this list may not have ever been written to or read from, and users should therefore not make any assumptions about the row key structure that are specific to their use case.

offset_bytes

int64

Approximate total storage space used by all rows in the table which precederow_key. Buffering the contents of all rows between two subsequent samples would require space roughly equal to the difference in theiroffset_bytes fields.

StreamContinuationToken

NOTE: This API is intended to be used by Apache Beam BigtableIO. The information required to continue reading the data from aStreamPartition from where a previous read left off.

Fields
partition

StreamPartition

The partition that this token applies to.

token

string

An encoded position in the stream to restart reading from.

StreamContinuationTokens

NOTE: This API is intended to be used by Apache Beam BigtableIO. The information required to continue reading the data from multipleStreamPartitions from where a previous read left off.

Fields
tokens[]

StreamContinuationToken

List of continuation tokens.

StreamPartition

NOTE: This API is intended to be used by Apache Beam BigtableIO. A partition of a change stream.

Fields
row_range

RowRange

The row range covered by this partition and is specified by [start_key_closed,end_key_open).

TimestampRange

Specified a contiguous range of microsecond timestamps.

Fields
start_timestamp_micros

int64

Inclusive lower bound. If left empty, interpreted as 0.

end_timestamp_micros

int64

Exclusive upper bound. If left empty, interpreted as infinity.

Type

Type represents the type of data that is written to, read from, or stored in Bigtable. It is heavily based on the GoogleSQL standard to help maintain familiarity and consistency across products and features.

For compatibility with Bigtable's existing untyped APIs, eachType includes anEncoding which describes how to convert to or from the underlying data.

Each encoding can operate in one of two modes:

  • Sorted: In this mode, Bigtable guarantees thatEncode(X) <= Encode(Y) if and only ifX <= Y. This is useful anywhere sort order is important, for example when encoding keys.
  • Distinct: In this mode, Bigtable guarantees that ifX != Y thenEncode(X) != Encode(Y). However, the converse is not guaranteed. For example, both{'foo': '1', 'bar': '2'} and{'bar': '2', 'foo': '1'} are valid encodings of the same JSON value.

The API clearly documents which mode is used wherever an encoding can be configured. Each encoding also documents which values are supported in which modes. For example, when encoding INT64 as a numeric STRING, negative numbers cannot be encoded in sorted mode. This is becauseINT64(1) > INT64(-1), butSTRING("-00001") > STRING("00001").

Fields
Union fieldkind. The kind of type that this represents.kind can be only one of the following:
bytes_type

Bytes

Bytes

string_type

String

String

int64_type

Int64

Int64

float32_type

Float32

Float32

float64_type

Float64

Float64

bool_type

Bool

Bool

timestamp_type

Timestamp

Timestamp

date_type

Date

Date

aggregate_type

Aggregate

Aggregate

struct_type

Struct

Struct

array_type

Array

Array

map_type

Map

Map

proto_type

Proto

Proto

enum_type

Enum

Enum

Aggregate

A value that combines incremental updates into a summarized value.

Data is never directly written or read using typeAggregate. Writes provide either theinput_type orstate_type, and reads always return thestate_type .

Fields
input_type

Type

Type of the inputs that are accumulated by thisAggregate. UseAddInput mutations to accumulate new inputs.

state_type

Type

Output only. Type that holds the internal accumulator state for theAggregate. This is a function of theinput_type andaggregator chosen.

Union fieldaggregator. Which aggregator function to use. The configured types must match.aggregator can be only one of the following:
sum

Sum

Sum aggregator.

hllpp_unique_count

HyperLogLogPlusPlusUniqueCount

HyperLogLogPlusPlusUniqueCount aggregator.

max

Max

Max aggregator.

min

Min

Min aggregator.

HyperLogLogPlusPlusUniqueCount

This type has no fields.

Computes an approximate unique count over the input values. When using raw data as input, be careful to use a consistent encoding. Otherwise the same value encoded differently could count more than once, or two distinct values could count as identical. Input: Any, or omit for Raw State: TBD Special state conversions:Int64 (the unique count estimate)

Max

This type has no fields.

Computes the max of the input values. Allowed input:Int64 State: same as input

Min

This type has no fields.

Computes the min of the input values. Allowed input:Int64 State: same as input

Sum

This type has no fields.

Computes the sum of the input values. Allowed input:Int64 State: same as input

Array

An ordered list of elements of a given type. Values of typeArray are stored inValue.array_value.

Fields
element_type

Type

The type of the elements in the array. This must not beArray.

Bool

This type has no fields.

bool Values of typeBool are stored inValue.bool_value.

Bytes

Bytes Values of typeBytes are stored inValue.bytes_value.

Fields
encoding

Encoding

The encoding to use when converting to or from lower level types.

Encoding

Rules used to convert to or from lower level types.

Fields
Union fieldencoding. Which encoding to use.encoding can be only one of the following:
raw

Raw

UseRaw encoding.

Raw

Leaves the value as-is.

Sorted mode: all values are supported.

Distinct mode: all values are supported.

Fields
escape_nulls

bool

If set, allows NULL values to be encoded as the empty string "".

The actual empty string, or any value which only contains the null byte0x00, has one more null byte appended.

Date

This type has no fields.

Date Values of typeDate are stored inValue.date_value.

Enum

A protobuf enum type. Values of typeEnum are stored inValue.int_value.

Fields
schema_bundle_id

string

The ID of the schema bundle that this enum is defined in.

enum_name

string

The fully qualified name of the protobuf enum message, including package. In the format of "foo.bar.EnumMessage".

Float32

This type has no fields.

Float32 Values of typeFloat32 are stored inValue.float_value.

Float64

This type has no fields.

Float64 Values of typeFloat64 are stored inValue.float_value.

Int64

Int64 Values of typeInt64 are stored inValue.int_value.

Fields
encoding

Encoding

The encoding to use when converting to or from lower level types.

Encoding

Rules used to convert to or from lower level types.

Fields
Union fieldencoding. Which encoding to use.encoding can be only one of the following:
big_endian_bytes

BigEndianBytes

UseBigEndianBytes encoding.

ordered_code_bytes

OrderedCodeBytes

UseOrderedCodeBytes encoding.

BigEndianBytes

Encodes the value as an 8-byte big-endian two's complement value.

Sorted mode: non-negative values are supported.

Distinct mode: all values are supported.

Compatible with:

  • BigQueryBINARY encoding
  • HBaseBytes.toBytes
  • JavaByteBuffer.putLong() withByteOrder.BIG_ENDIAN
Fields
bytes_type
(deprecated)

Bytes

This item is deprecated!

Deprecated: ignored if set.

OrderedCodeBytes

This type has no fields.

Encodes the value in a variable length binary format of up to 10 bytes. Values that are closer to zero use fewer bytes.

Sorted mode: all values are supported.

Distinct mode: all values are supported.

Map

A mapping of keys to values of a given type. Values of typeMap are stored in aValue.array_value where each entry is anotherValue.array_value with two elements (the key and the value, in that order). Normally encoded Map values won't have repeated keys, however, clients are expected to handle the case in which they do. If the same key appears multiple times, thelast value takes precedence.

Fields
key_type

Type

The type of a map key. OnlyBytes,String, andInt64 are allowed as key types.

value_type

Type

The type of the values in a map.

Proto

A protobuf message type. Values of typeProto are stored inValue.bytes_value.

Fields
schema_bundle_id

string

The ID of the schema bundle that this proto is defined in.

message_name

string

The fully qualified name of the protobuf message, including package. In the format of "foo.bar.Message".

String

String Values of typeString are stored inValue.string_value.

Fields
encoding

Encoding

The encoding to use when converting to or from lower level types.

Encoding

Rules used to convert to or from lower level types.

Fields
Union fieldencoding. Which encoding to use.encoding can be only one of the following:
utf8_raw
(deprecated)

Utf8Raw

This item is deprecated!

Deprecated: if set, converts to an emptyutf8_bytes.

utf8_bytes

Utf8Bytes

UseUtf8Bytes encoding.

Utf8Bytes

UTF-8 encoding.

Sorted mode: - All values are supported. - Code point order is preserved.

Distinct mode: all values are supported.

Compatible with:

  • BigQueryTEXT encoding
  • HBaseBytes.toBytes
  • JavaString#getBytes(StandardCharsets.UTF_8)
Fields
null_escape_char

string

Single-character escape sequence used to support NULL values.

If set, allows NULL values to be encoded as the empty string "".

The actual empty string, or any value where every character equalsnull_escape_char, has one morenull_escape_char appended.

Ifnull_escape_char is set and does not equal the ASCII null character0x00, then the encoding will not support sorted mode.

.

Utf8Raw

This type has no fields.

This item is deprecated!

Deprecated: prefer the equivalentUtf8Bytes.

Struct

A structured data value, consisting of fields which map to dynamically typed values. Values of typeStruct are stored inValue.array_value where entries are in the same order and number asfield_types.

Fields
fields[]

Field

The names and types of the fields in this struct.

encoding

Encoding

The encoding to use when converting to or from lower level types.

Encoding

Rules used to convert to or from lower level types.

Fields
Union fieldencoding. Which encoding to use.encoding can be only one of the following:
singleton

Singleton

UseSingleton encoding.

delimited_bytes

DelimitedBytes

UseDelimitedBytes encoding.

ordered_code_bytes

OrderedCodeBytes

UserOrderedCodeBytes encoding.

DelimitedBytes

Fields are encoded independently and concatenated with a configurabledelimiter in between.

A struct with no fields defined is encoded as a singledelimiter.

Sorted mode:

Distinct mode:

Fields
delimiter

bytes

Byte sequence used to delimit concatenated fields. The delimiter must contain at least 1 character and at most 50 characters.

OrderedCodeBytes

This type has no fields.

Fields are encoded independently, then escaped and delimited by appling the following rules in order: - While the last remaining field isASC orUNSPECIFIED, and encodes to the empty string "", remove it. - In each remaining field, replace all null bytes0x00 with the fixed byte pair{0x00, 0xFF}. - If any remaining field encodes to the empty string "", replace it with the fixed byte pair{0x00, 0x00}. - Append the fixed byte pair{0x00, 0x01} to each remaining field, except for the last remaining field if it isASC. - Bitwise negate allDESC fields. - Concatenate the results, or emit the fixed byte pair{0x00, 0x00} if there are no remaining fields to concatenate.

Examples:

 - STRUCT()             -> "\00\00" - STRUCT("")           -> "\00\00" - STRUCT("", "")       -> "\00\00" - STRUCT("", "B")      -> "\00\00" + "\00\01" + "B" - STRUCT("A", "")      -> "A" - STRUCT("", "B", "")  -> "\00\00" + "\00\01" + "B" - STRUCT("A", "", "C") -> "A" + "\00\01" + "\00\00" + "\00\01" + "C"

Examples for struct withDESC fields:

 - STRUCT("" DESC)          -> "\xFF\xFF" + "\xFF\xFE" - STRUCT("" DESC, "")      -> "\xFF\xFF" + "\xFF\xFE" - STRUCT("" DESC, "", "")  -> "\xFF\xFF" + "\xFF\xFE" - STRUCT("" DESC, "A")     -> "\xFF\xFF" + "\xFF\xFE" + "A" - STRUCT("A", "" DESC, "") -> "A" + "\00\01" + "\xFF\xFF" + "\xFF\xFE" - STRUCT("", "A" DESC)     -> "\x00\x00" + "\x00\x01" + "\xBE" +                               "\xFF\xFE"

Since null bytes are always escaped, this encoding can cause size blowup for encodings likeInt64.BigEndianBytes that are likely to produce many such bytes.

Sorted mode:

  • Fields are encoded in sorted mode.
  • All values supported by the field encodings are allowed.
  • Fields with unset orUNSPECIFIED order are treated asASC.
  • Element-wise order is preserved:A < B ifA[0] < B[0], or ifA[0] == B[0] && A[1] < B[1], etc. Strict prefixes sort first.

Distinct mode:

  • Fields are encoded in distinct mode.
  • All values supported by the field encodings are allowed.

Singleton

This type has no fields.

Uses the encoding offields[0].type as-is. Only valid iffields.size == 1. This encoding does not supportDESC field ordering.

Field

A struct field and its type.

Fields
field_name

string

The field name (optional). Fields without afield_name are considered anonymous and cannot be referenced by name.

type

Type

The type of values in this field.

Timestamp

Timestamp Values of typeTimestamp are stored inValue.timestamp_value.

Fields
encoding

Encoding

The encoding to use when converting to or from lower level types.

Encoding

Rules used to convert to or from lower level types.

Fields
Union fieldencoding. Which encoding to use.encoding can be only one of the following:
unix_micros_int64

Encoding

Encodes the number of microseconds since the Unix epoch using the givenInt64 encoding. Values must be microsecond-aligned.

Compatible with:

  • JavaInstant.truncatedTo() withChronoUnit.MICROS

Value

Value represents a dynamically typed value. The typed fields inValue are used as a transport encoding for the actual value (which may be of a more complex type). See the documentation of theType message for more details.

Fields
type

Type

The verifiedType of thisValue, if it cannot be inferred.

Read results will never specify the encoding fortype since the value will already have been decoded by the server. Furthermore, thetype will be omitted entirely if it can be inferred from a previous response. The exact semantics for inferringtype will vary, and are therefore documented separately for each read method.

When using composite types (Struct, Array, Map) only the outermostValue will specify thetype. This top-leveltype will define the types for any nestedStruct' fields,Arrayelements, orMapkey/value pairs. If a nestedValueprovides atype` on write, the request will be rejected with INVALID_ARGUMENT.

Union fieldkind. Options for transporting values within the protobuf type system. A givenkind may support more than onetype and vice versa. On write, this is roughly analogous to a GoogleSQL literal.

The value isNULL if none of the fields inkind is set. Iftype is also omitted on write, we will infer it based on the schema.kind can be only one of the following:

raw_value

bytes

Represents a raw byte sequence with no type information. Thetype field must be omitted.

raw_timestamp_micros

int64

Represents a raw cell timestamp with no type information. Thetype field must be omitted.

bytes_value

bytes

Represents a typed value transported as a byte sequence.

string_value

string

Represents a typed value transported as a string.

int_value

int64

Represents a typed value transported as an integer.

bool_value

bool

Represents a typed value transported as a boolean.

float_value

double

Represents a typed value transported as a floating point number. Does not support NaN or infinities.

timestamp_value

Timestamp

Represents a typed value transported as a timestamp.

date_value

Date

Represents a typed value transported as a date.

array_value

ArrayValue

Represents a typed value transported as a sequence of values. To differentiate betweenStruct,Array, andMap, the outermostValue must provide an explicittype on write. Thistype will apply recursively to the nestedStruct fields,Array elements, orMap key/value pairs, whichmust not supply their owntype.

ValueRange

Specifies a contiguous range of raw byte values.

Fields
Union fieldstart_value. The value at which to start the range. If neither field is set, interpreted as the empty string, inclusive.start_value can be only one of the following:
start_value_closed

bytes

Used when giving an inclusive lower bound for the range.

start_value_open

bytes

Used when giving an exclusive lower bound for the range.

Union fieldend_value. The value at which to end the range. If neither field is set, interpreted as the infinite string, exclusive.end_value can be only one of the following:
end_value_closed

bytes

Used when giving an inclusive upper bound for the range.

end_value_open

bytes

Used when giving an exclusive upper bound for the range.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-11-06 UTC.