MCP Tools Reference: bigtableadmin.googleapis.com

map (key: string, value: object ( ClusterState ))

Output only. Map from cluster ID to per-cluster table state. If it could not be determined whether or not the table has data in a particular cluster (for example, if its zone is unavailable), then there will be an entry for the cluster with UNKNOWN replication_status . Views: REPLICATION_VIEW , ENCRYPTION_VIEW , FULL

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" } .

map (key: string, value: object ( ColumnFamily ))

The column families configured for this table, mapped by column family ID. Views: SCHEMA_VIEW , STATS_VIEW , FULL

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" } .

enum ( TimestampGranularity )

Immutable. The granularity (i.e. MILLIS ) at which timestamps are stored in this table. Timestamps not matching the granularity will be rejected. If unspecified at creation time, the value will be set to MILLIS . Views: SCHEMA_VIEW , FULL .

object ( RestoreInfo )

Output only. If this table was restored from another data source (e.g. a backup), this field will be populated with information about the restore.

object ( ChangeStreamConfig )

If specified, enable the change stream on this table. Otherwise, the change stream is disabled and the change stream is not retained.

boolean

Set to true to make the table protected against data loss. i.e. deleting the following resources through Admin APIs are prohibited:

• The table.
• The column families in the table.
• The instance containing the table.

Note one can still delete the data stored in the table through Data APIs.

object ( TableStats )

Output only. Only available with STATS_VIEW, this includes summary statistics about the entire table contents. For statistics about a specific column family, see ColumnFamilyStats in the mapped ColumnFamily collection above.

object ( TieredStorageConfig )

Rules to specify what data is stored in each storage tier. Different tiers store data differently, providing different trade-offs between cost and performance. Different parts of a table can be stored separately on different tiers. If a config is specified, tiered storage is enabled for this table. Otherwise, tiered storage is disabled. Only SSD instances can configure tiered storage.

object ( Struct )

The row key schema for this table. The schema is used to decode the raw row key bytes into a structured format. The order of field declarations in this schema is important, as it reflects how the raw row key bytes are structured. Currently, this only affects how the key is read via a GoogleSQL query from the ExecuteQuery API.

For a SQL query, the _key column is still read as raw bytes. But queries can reference the key fields by name, which will be decoded from _key using provided type and encoding. Queries that reference key fields will fail if they encounter an invalid row key.

For example, if _key = "some_id#2024-04-30#\x00\x13\x00\xf3" with the following schema: { fields { field_name: "id" type { string { encoding: utf8_bytes {} } } } fields { field_name: "date" type { string { encoding: utf8_bytes {} } } } fields { field_name: "product_code" type { int64 { encoding: big_endian_bytes {} } } } encoding { delimited_bytes { delimiter: "#" } } }

The decoded key parts would be: id = "some_id", date = "2024-04-30", product_code = 1245427 The query "SELECT _key, product_code FROM table" will return two columns: /------------------------------------------------------\ | _key | product_code | | --------------------------------------|--------------| | "some_id#2024-04-30#\x00\x13\x00\xf3" | 1245427 | ------------------------------------------------------/

The schema has the following invariants: (1) The decoded field values are order-preserved. For read, the field values will be decoded in sorted mode from the raw bytes. (2) Every field in the schema must specify a non-empty name. (3) Every field must specify a type with an associated encoding. The type is limited to scalar types only: Array, Map, Aggregate, and Struct are not allowed. (4) The field names must not collide with existing column family names and reserved keywords "_key" and "_timestamp".

The following update operations are allowed for row_key_schema: - Update from an empty schema to a new schema. - Remove the existing schema. This operation requires setting the ignore_warnings flag to true , since it might be a backward incompatible change. Without the flag, the update request will fail with an INVALID_ARGUMENT error. Any other row key schema update operation (e.g. update existing schema columns names or types) is currently unsupported.

object ( AutomatedBackupPolicy )

If specified, automated backups are enabled for this table. Otherwise, automated backups are disabled.

string ( bytes format)

Must be a valid serialized protocol buffer of the above specified type.

A base64-encoded string.

string ( Duration format)

Delete cells in a column older than the given age. Values must be at least one millisecond, and will be truncated to microsecond granularity.

A duration in seconds with up to nine fractional digits, ending with ' s '. Example: "3.5s" .

object ( Intersection )

Delete cells that would be deleted by every nested rule.

object ( Union )

Delete cells that would be deleted by any nested rule.

number

How many cells are present per column qualifier in this column family, averaged over all rows containing any column in the column family.

e.g. For column family "family" in a table with 3 rows:

• A row with 3 cells in "family:col" and 1 cell in "other:col" (3 cells / 1 column in "family")
• A row with 1 cell in "family:col", 7 cells in "family:other_col", and 7 cells in "other:data" (8 cells / 2 columns in "family")
• A row with 3 cells in "other:col" (0 columns in "family", "family" not present)

would report (3 + 8 + 0)/(1 + 2 + 0) = 3.66 in this field.

string ( int64 format)

How much space the data in the column family occupies. This is roughly how many bytes would be needed to read the contents of the entire column family (e.g. by streaming all contents out).

object ( String )

String

object ( Int64 )

Int64

object ( Float32 )

Float32

object ( Float64 )

Float64

object ( Bool )

Bool

object ( Timestamp )

Timestamp

object ( Date )

Date

object ( Aggregate )

Aggregate

object ( Struct )

Struct

object ( Array )

Array

object ( Map )

Map

object ( Proto )

Proto

object ( Enum )

Enum

object ( Geography )

Geography

object ( Utf8Bytes )

Use Utf8Bytes encoding.

object ( OrderedCodeBytes )

Use OrderedCodeBytes encoding.

object ( Type )

Output only. Type that holds the internal accumulator state for the Aggregate . This is a function of the input_type and aggregator chosen.

object ( Sum )

Sum aggregator.

object ( HyperLogLogPlusPlusUniqueCount )

HyperLogLogPlusPlusUniqueCount aggregator.

object ( Max )

Max aggregator.

object ( Min )

Min aggregator.

object ( DelimitedBytes )

Use DelimitedBytes encoding.

object ( OrderedCodeBytes )

User OrderedCodeBytes encoding.

object ( BackupInfo )

Information about the backup used to restore the table. The backup may no longer exist.

number

How many (column family, column qualifier) combinations are present per row in the table, averaged over all rows in the table.

e.g. A table with 2 rows:

• A row with cells in "family:col" and "other:col" (2 distinct columns)
• A row with cells in "family:col", "family:other_col", and "other:data" (3 distinct columns)

would report (2 + 3)/2 = 2.5 in this field.

number

How many cells are present per column (column family, column qualifier) combinations, averaged over all columns in all rows in the table.

e.g. A table with 2 rows:

• A row with 3 cells in "family:col" and 1 cell in "other:col" (4 cells / 2 columns)
• A row with 1 cell in "family:col", 7 cells in "family:other_col", and 7 cells in "other:data" (15 cells / 3 columns)

would report (4 + 15)/(2 + 3) = 3.8 in this field.

string ( int64 format)

This is roughly how many bytes would be needed to read the entire table (e.g. by streaming all contents out).