bigquery  v2
Properties | List of all members
Google.Apis.Bigquery.v2.Data.Table Class Reference
Inheritance diagram for Google.Apis.Bigquery.v2.Data.Table:
Google::Apis::Requests::IDirectResponseSchema

Properties

virtual Clustering Clustering [get, set]
 [Beta] Clustering specification for the table. Must be specified with partitioning, data in the table will be first partitioned and subsequently clustered. More...
 
virtual System.Nullable< long > CreationTime [get, set]
 [Output-only] The time when this table was created, in milliseconds since the epoch. More...
 
virtual string Description [get, set]
 [Optional] A user-friendly description of this table. More...
 
virtual EncryptionConfiguration EncryptionConfiguration [get, set]
 Custom encryption configuration (e.g., Cloud KMS keys). More...
 
virtual string ETag [get, set]
 [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. More...
 
virtual System.Nullable< long > ExpirationTime [get, set]
 [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. More...
 
virtual ExternalDataConfiguration ExternalDataConfiguration [get, set]
 [Optional] Describes the data format, location, and other properties of a table stored outside of BigQuery. By defining these properties, the data source can then be queried as if it were a standard BigQuery table. More...
 
virtual string FriendlyName [get, set]
 [Optional] A descriptive name for this table. More...
 
virtual string Id [get, set]
 [Output-only] An opaque ID uniquely identifying the table. More...
 
virtual string Kind [get, set]
 [Output-only] The type of the resource. More...
 
virtual System.Collections.Generic.IDictionary< string, string > Labels [get, set]
 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. More...
 
virtual System.Nullable< ulong > LastModifiedTime [get, set]
 [Output-only] The time when this table was last modified, in milliseconds since the epoch. More...
 
virtual string Location [get, set]
 [Output-only] The geographic location where the table resides. This value is inherited from the dataset. More...
 
virtual MaterializedViewDefinition MaterializedView [get, set]
 [Optional] Materialized view definition. More...
 
virtual ModelDefinition Model [get, set]
 [Output-only, Beta] Present iff this table represents a ML model. Describes the training information for the model, and it is required to run 'PREDICT' queries. More...
 
virtual System.Nullable< long > NumBytes [get, set]
 [Output-only] The size of this table in bytes, excluding any data in the streaming buffer. More...
 
virtual System.Nullable< long > NumLongTermBytes [get, set]
 [Output-only] The number of bytes in the table that are considered "long-term storage". More...
 
virtual System.Nullable< long > NumPhysicalBytes [get, set]
 [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. More...
 
virtual System.Nullable< ulong > NumRows [get, set]
 [Output-only] The number of rows of data in this table, excluding any data in the streaming buffer. More...
 
virtual RangePartitioning RangePartitioning [get, set]
 [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified. More...
 
virtual System.Nullable< bool > RequirePartitionFilter [get, set]
 [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. More...
 
virtual TableSchema Schema [get, set]
 [Optional] Describes the schema of this table. More...
 
virtual string SelfLink [get, set]
 [Output-only] A URL that can be used to access this resource again. More...
 
virtual Streamingbuffer StreamingBuffer [get, set]
 [Output-only] Contains information regarding this table's streaming buffer, if one is present. This field will be absent if the table is not being streamed to or if there is no data in the streaming buffer. More...
 
virtual TableReference TableReference [get, set]
 [Required] Reference describing the ID of this table. More...
 
virtual TimePartitioning TimePartitioning [get, set]
 Time-based partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified. More...
 
virtual string Type [get, set]
 [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. [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. More...
 
virtual ViewDefinition View [get, set]
 [Optional] The view definition. More...
 
- Properties inherited from Google::Apis::Requests::IDirectResponseSchema
string ETag
 

Property Documentation

◆ Clustering

virtual Clustering Google.Apis.Bigquery.v2.Data.Table.Clustering
getset

[Beta] Clustering specification for the table. Must be specified with partitioning, data in the table will be first partitioned and subsequently clustered.

◆ CreationTime

virtual System.Nullable<long> Google.Apis.Bigquery.v2.Data.Table.CreationTime
getset

[Output-only] The time when this table was created, in milliseconds since the epoch.

◆ Description

virtual string Google.Apis.Bigquery.v2.Data.Table.Description
getset

[Optional] A user-friendly description of this table.

◆ EncryptionConfiguration

virtual EncryptionConfiguration Google.Apis.Bigquery.v2.Data.Table.EncryptionConfiguration
getset

Custom encryption configuration (e.g., Cloud KMS keys).

◆ ETag

virtual string Google.Apis.Bigquery.v2.Data.Table.ETag
getset

[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.

◆ ExpirationTime

virtual System.Nullable<long> Google.Apis.Bigquery.v2.Data.Table.ExpirationTime
getset

[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.

◆ ExternalDataConfiguration

virtual ExternalDataConfiguration Google.Apis.Bigquery.v2.Data.Table.ExternalDataConfiguration
getset

[Optional] Describes the data format, location, and other properties of a table stored outside of BigQuery. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.

◆ FriendlyName

virtual string Google.Apis.Bigquery.v2.Data.Table.FriendlyName
getset

[Optional] A descriptive name for this table.

◆ Id

virtual string Google.Apis.Bigquery.v2.Data.Table.Id
getset

[Output-only] An opaque ID uniquely identifying the table.

◆ Kind

virtual string Google.Apis.Bigquery.v2.Data.Table.Kind
getset

[Output-only] The type of the resource.

◆ Labels

virtual System.Collections.Generic.IDictionary<string,string> Google.Apis.Bigquery.v2.Data.Table.Labels
getset

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.

◆ LastModifiedTime

virtual System.Nullable<ulong> Google.Apis.Bigquery.v2.Data.Table.LastModifiedTime
getset

[Output-only] The time when this table was last modified, in milliseconds since the epoch.

◆ Location

virtual string Google.Apis.Bigquery.v2.Data.Table.Location
getset

[Output-only] The geographic location where the table resides. This value is inherited from the dataset.

◆ MaterializedView

virtual MaterializedViewDefinition Google.Apis.Bigquery.v2.Data.Table.MaterializedView
getset

[Optional] Materialized view definition.

◆ Model

virtual ModelDefinition Google.Apis.Bigquery.v2.Data.Table.Model
getset

[Output-only, Beta] Present iff this table represents a ML model. Describes the training information for the model, and it is required to run 'PREDICT' queries.

◆ NumBytes

virtual System.Nullable<long> Google.Apis.Bigquery.v2.Data.Table.NumBytes
getset

[Output-only] The size of this table in bytes, excluding any data in the streaming buffer.

◆ NumLongTermBytes

virtual System.Nullable<long> Google.Apis.Bigquery.v2.Data.Table.NumLongTermBytes
getset

[Output-only] The number of bytes in the table that are considered "long-term storage".

◆ NumPhysicalBytes

virtual System.Nullable<long> Google.Apis.Bigquery.v2.Data.Table.NumPhysicalBytes
getset

[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.

◆ NumRows

virtual System.Nullable<ulong> Google.Apis.Bigquery.v2.Data.Table.NumRows
getset

[Output-only] The number of rows of data in this table, excluding any data in the streaming buffer.

◆ RangePartitioning

virtual RangePartitioning Google.Apis.Bigquery.v2.Data.Table.RangePartitioning
getset

[TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.

◆ RequirePartitionFilter

virtual System.Nullable<bool> Google.Apis.Bigquery.v2.Data.Table.RequirePartitionFilter
getset

[Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified.

◆ Schema

virtual TableSchema Google.Apis.Bigquery.v2.Data.Table.Schema
getset

[Optional] Describes the schema of this table.

◆ SelfLink

virtual string Google.Apis.Bigquery.v2.Data.Table.SelfLink
getset

[Output-only] A URL that can be used to access this resource again.

◆ StreamingBuffer

virtual Streamingbuffer Google.Apis.Bigquery.v2.Data.Table.StreamingBuffer
getset

[Output-only] Contains information regarding this table's streaming buffer, if one is present. This field will be absent if the table is not being streamed to or if there is no data in the streaming buffer.

◆ TableReference

virtual TableReference Google.Apis.Bigquery.v2.Data.Table.TableReference
getset

[Required] Reference describing the ID of this table.

◆ TimePartitioning

virtual TimePartitioning Google.Apis.Bigquery.v2.Data.Table.TimePartitioning
getset

Time-based partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.

◆ Type

virtual string Google.Apis.Bigquery.v2.Data.Table.Type
getset

[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. [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

virtual ViewDefinition Google.Apis.Bigquery.v2.Data.Table.View
getset

[Optional] The view definition.


The documentation for this class was generated from the following file: