tables

Overview

Name	tables
Type	Resource
Id	google.bigquery.tables

Fields

Name	Datatype	Description
id	string	[Output-only] An opaque ID uniquely identifying the table.
description	string	[Optional] A user-friendly description of this table.
model	object
numTotalPhysicalBytes	string	[Output-only] The physical size of this table in bytes. This also includes storage used for time travel. This data is not kept in real time, and might be delayed by a few seconds to a few minutes.
etag	string	[Output-only] A hash of the table metadata. Used to ensure there were no concurrent modifications to the resource when attempting an update. Not guaranteed to change when the table contents or the fields numRows, numBytes, numLongTermBytes or lastModifiedTime change.
lastModifiedTime	string	[Output-only] The time when this table was last modified, in milliseconds since the epoch.
numRows	string	[Output-only] The number of rows of data in this table, excluding any data in the streaming buffer.
defaultRoundingMode	string	[Output-only] The default rounding mode of the table.
numPhysicalBytes	string	[Output-only][TrustedTester] The physical size of this table in bytes, excluding any data in the streaming buffer. This includes compression and storage used for time travel.
numPartitions	string	[Output-only] The number of partitions present in the table or materialized view. This data is not kept in real time, and might be delayed by a few seconds to a few minutes.
numActivePhysicalBytes	string	[Output-only] Number of physical bytes less than 90 days old. This data is not kept in real time, and might be delayed by a few seconds to a few minutes.
clustering	object
expirationTime	string	[Optional] The time when this table expires, in milliseconds since the epoch. If not present, the table will persist indefinitely. Expired tables will be deleted and their storage reclaimed. The defaultTableExpirationMs property of the encapsulating dataset can be used to set a default expirationTime on newly created tables.
materializedView	object
type	string	[Output-only] Describes the table type. The following values are supported: TABLE: A normal BigQuery table. VIEW: A virtual table defined by a SQL query. SNAPSHOT: An immutable, read-only table that is a copy of another table. [TrustedTester] MATERIALIZED_VIEW: SQL query whose result is persisted. EXTERNAL: A table that references data stored in an external storage system, such as Google Cloud Storage. The default value is TABLE.
view	object
tableReference	object
selfLink	string	[Output-only] A URL that can be used to access this resource again.
rangePartitioning	object
location	string	[Output-only] The geographic location where the table resides. This value is inherited from the dataset.
tableConstraints	object
numLongTermBytes	string	[Output-only] The number of bytes in the table that are considered "long-term storage".
biglakeConfiguration	object
creationTime	string	[Output-only] The time when this table was created, in milliseconds since the epoch.
numTotalLogicalBytes	string	[Output-only] Total number of logical bytes in the table or materialized view.
cloneDefinition	object
externalDataConfiguration	object
encryptionConfiguration	object
snapshotDefinition	object
numLongTermPhysicalBytes	string	[Output-only] Number of physical bytes more than 90 days old. This data is not kept in real time, and might be delayed by a few seconds to a few minutes.
timePartitioning	object
kind	string	[Output-only] The type of the resource.
defaultCollation	string	[Output-only] The default collation of the table.
numLongTermLogicalBytes	string	[Output-only] Number of logical bytes that are more than 90 days old.
requirePartitionFilter	boolean	[Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified.
schema	object
numActiveLogicalBytes	string	[Output-only] Number of logical bytes that are less than 90 days old.
labels	object	The labels associated with this table. You can use these to organize and group your tables. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
friendlyName	string	[Optional] A descriptive name for this table.
maxStaleness	string	[Optional] Max staleness of data that could be returned when table or materialized view is queried (formatted as Google SQL Interval type).
streamingBuffer	object
numBytes	string	[Output-only] The size of this table in bytes, excluding any data in the streaming buffer.
numTimeTravelPhysicalBytes	string	[Output-only] Number of physical bytes used by time travel storage (deleted or changed data). This data is not kept in real time, and might be delayed by a few seconds to a few minutes.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	datasetId, projectId, tableId	Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.
list	SELECT	datasetId, projectId	Lists all tables in the specified dataset. Requires the READER dataset role.
insert	INSERT	datasetId, projectId	Creates a new, empty table in the dataset.
delete	DELETE	datasetId, projectId, tableId	Deletes the table specified by tableId from the dataset. If the table contains data, all the data will be deleted.
_list	EXEC	datasetId, projectId	Lists all tables in the specified dataset. Requires the READER dataset role.
patch	EXEC	datasetId, projectId, tableId	Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource. This method supports patch semantics.
update	EXEC	datasetId, projectId, tableId	Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource.