Class: Google::Apis::BigqueryV2::Table

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/bigquery_v2/classes.rb,
lib/google/apis/bigquery_v2/representations.rb,
lib/google/apis/bigquery_v2/representations.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ Table

Returns a new instance of Table.



11064
11065
11066
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11064

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#biglake_configuration ⇒ Google::Apis::BigqueryV2::BigLakeConfiguration

Configuration for BigQuery tables for Apache Iceberg (formerly BigLake managed tables.) Corresponds to the JSON property biglakeConfiguration

Returns:



10743
10744
10745
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10743

def biglake_configuration
  @biglake_configuration
end

#clone_definition ⇒ Google::Apis::BigqueryV2::CloneDefinition

Information about base table and clone time of a table clone. Corresponds to the JSON property cloneDefinition

Returns:



10748
10749
10750
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10748

def clone_definition
  @clone_definition
end

#clustering ⇒ Google::Apis::BigqueryV2::Clustering

Configures table clustering. Corresponds to the JSON property clustering

Returns:



10753
10754
10755
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10753

def clustering
  @clustering
end

#creation_time ⇒ Fixnum

Output only. The time when this table was created, in milliseconds since the epoch. Corresponds to the JSON property creationTime

Returns:

  • (Fixnum) 


10759
10760
10761
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10759

def creation_time
  @creation_time
end

#default_collation ⇒ String

Optional. Defines the default collation specification of new STRING fields in the table. During table creation or update, if a STRING field is added to this table without explicit collation specified, then the table inherits the table default collation. A change to this field affects only fields added afterwards, and does not alter the existing fields. The following values are supported: * 'und:ci': undetermined locale, case insensitive. * '': empty string. Default to case-sensitive behavior. Corresponds to the JSON property defaultCollation

Returns:

  • (String) 


10770
10771
10772
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10770

def default_collation
  @default_collation
end

#default_rounding_mode ⇒ String

Optional. Defines the default rounding mode specification of new decimal fields (NUMERIC OR BIGNUMERIC) in the table. During table creation or update, if a decimal field is added to this table without an explicit rounding mode specified, then the field inherits the table default rounding mode. Changing this field doesn't affect existing fields. Corresponds to the JSON property defaultRoundingMode

Returns:

  • (String) 


10779
10780
10781
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10779

def default_rounding_mode
  @default_rounding_mode
end

#description ⇒ String

Optional. A user-friendly description of this table. Corresponds to the JSON property description

Returns:

  • (String) 


10784
10785
10786
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10784

def description
  @description
end

#encryption_configuration ⇒ Google::Apis::BigqueryV2::EncryptionConfiguration

Configuration for Cloud KMS encryption settings. Corresponds to the JSON property encryptionConfiguration

Returns:



10789
10790
10791
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10789

def encryption_configuration
  @encryption_configuration
end

#etag ⇒ String

Output only. A hash of this resource. Corresponds to the JSON property etag

Returns:

  • (String) 


10794
10795
10796
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10794

def etag
  @etag
end

#expiration_time ⇒ Fixnum

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. Corresponds to the JSON property expirationTime

Returns:

  • (Fixnum) 


10803
10804
10805
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10803

def expiration_time
  @expiration_time
end

#external_catalog_table_options ⇒ Google::Apis::BigqueryV2::ExternalCatalogTableOptions

Metadata about open source compatible table. The fields contained in these options correspond to Hive metastore's table-level properties. Corresponds to the JSON property externalCatalogTableOptions

Returns:



10809
10810
10811
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10809

def external_catalog_table_options
  @external_catalog_table_options
end

#external_data_configuration ⇒ Google::Apis::BigqueryV2::ExternalDataConfiguration

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. Corresponds to the JSON property externalDataConfiguration

Returns:



10816
10817
10818
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10816

def external_data_configuration
  @external_data_configuration
end

#friendly_name ⇒ String

Optional. A descriptive name for this table. Corresponds to the JSON property friendlyName

Returns:

  • (String) 


10821
10822
10823
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10821

def friendly_name
  @friendly_name
end

#id ⇒ String

Output only. An opaque ID uniquely identifying the table. Corresponds to the JSON property id

Returns:

  • (String) 


10826
10827
10828
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10826

def id
  @id
end

#kind ⇒ String

The type of resource ID. Corresponds to the JSON property kind

Returns:

  • (String) 


10831
10832
10833
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10831

def kind
  @kind
end

#labels ⇒ Hash<String,String>

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. Corresponds to the JSON property labels

Returns:

  • (Hash<String,String>) 


10840
10841
10842
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10840

def labels
  @labels
end

#last_modified_time ⇒ Fixnum

Output only. The time when this table was last modified, in milliseconds since the epoch. Corresponds to the JSON property lastModifiedTime

Returns:

  • (Fixnum) 


10846
10847
10848
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10846

def last_modified_time
  @last_modified_time
end

#location ⇒ String

Output only. The geographic location where the table resides. This value is inherited from the dataset. Corresponds to the JSON property location

Returns:

  • (String) 


10852
10853
10854
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10852

def location
  @location
end

#managed_table_type ⇒ String

Optional. If set, overrides the default managed table type configured in the dataset. Corresponds to the JSON property managedTableType

Returns:

  • (String) 


10858
10859
10860
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10858

def managed_table_type
  @managed_table_type
end

#materialized_view ⇒ Google::Apis::BigqueryV2::MaterializedViewDefinition

Definition and configuration of a materialized view. Corresponds to the JSON property materializedView

Returns:



10863
10864
10865
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10863

def materialized_view
  @materialized_view
end

#materialized_view_status ⇒ Google::Apis::BigqueryV2::MaterializedViewStatus

Status of a materialized view. The last refresh timestamp status is omitted here, but is present in the MaterializedViewDefinition message. Corresponds to the JSON property materializedViewStatus

Returns:



10869
10870
10871
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10869

def materialized_view_status
  @materialized_view_status
end

#max_staleness ⇒ String

Optional. The maximum staleness of data that could be returned when the table ( or stale MV) is queried. Staleness encoded as a string encoding of sql IntervalValue type. Corresponds to the JSON property maxStaleness

Returns:

  • (String) 


10876
10877
10878
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10876

def max_staleness
  @max_staleness
end

#model ⇒ Google::Apis::BigqueryV2::ModelDefinition

Deprecated. Corresponds to the JSON property model

Returns:



10881
10882
10883
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10881

def model
  @model
end

#num_active_logical_bytes ⇒ Fixnum

Output only. Number of logical bytes that are less than 90 days old. Corresponds to the JSON property numActiveLogicalBytes

Returns:

  • (Fixnum) 


10886
10887
10888
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10886

def num_active_logical_bytes
  @num_active_logical_bytes
end

#num_active_physical_bytes ⇒ Fixnum

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. Corresponds to the JSON property numActivePhysicalBytes

Returns:

  • (Fixnum) 


10892
10893
10894
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10892

def num_active_physical_bytes
  @num_active_physical_bytes
end

#num_bytes ⇒ Fixnum

Output only. The size of this table in logical bytes, excluding any data in the streaming buffer. Corresponds to the JSON property numBytes

Returns:

  • (Fixnum) 


10898
10899
10900
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10898

def num_bytes
  @num_bytes
end

#num_current_physical_bytes ⇒ Fixnum

Output only. Number of physical bytes used by current live data storage. This data is not kept in real time, and might be delayed by a few seconds to a few minutes. Corresponds to the JSON property numCurrentPhysicalBytes

Returns:

  • (Fixnum) 


10905
10906
10907
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10905

def num_current_physical_bytes
  @num_current_physical_bytes
end

#num_long_term_bytes ⇒ Fixnum

Output only. The number of logical bytes in the table that are considered " long-term storage". Corresponds to the JSON property numLongTermBytes

Returns:

  • (Fixnum) 


10911
10912
10913
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10911

def num_long_term_bytes
  @num_long_term_bytes
end

#num_long_term_logical_bytes ⇒ Fixnum

Output only. Number of logical bytes that are more than 90 days old. Corresponds to the JSON property numLongTermLogicalBytes

Returns:

  • (Fixnum) 


10916
10917
10918
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10916

def num_long_term_logical_bytes
  @num_long_term_logical_bytes
end

#num_long_term_physical_bytes ⇒ Fixnum

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. Corresponds to the JSON property numLongTermPhysicalBytes

Returns:

  • (Fixnum) 


10922
10923
10924
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10922

def num_long_term_physical_bytes
  @num_long_term_physical_bytes
end

#num_partitions ⇒ Fixnum

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. Corresponds to the JSON property numPartitions

Returns:

  • (Fixnum) 


10929
10930
10931
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10929

def num_partitions
  @num_partitions
end

#num_physical_bytes ⇒ Fixnum

Output only. The physical size of this table in bytes. This includes storage used for time travel. Corresponds to the JSON property numPhysicalBytes

Returns:

  • (Fixnum) 


10935
10936
10937
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10935

def num_physical_bytes
  @num_physical_bytes
end

#num_rows ⇒ Fixnum

Output only. The number of rows of data in this table, excluding any data in the streaming buffer. Corresponds to the JSON property numRows

Returns:

  • (Fixnum) 


10941
10942
10943
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10941

def num_rows
  @num_rows
end

#num_time_travel_physical_bytes ⇒ Fixnum

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. Corresponds to the JSON property numTimeTravelPhysicalBytes

Returns:

  • (Fixnum) 


10948
10949
10950
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10948

def num_time_travel_physical_bytes
  @num_time_travel_physical_bytes
end

#num_total_logical_bytes ⇒ Fixnum

Output only. Total number of logical bytes in the table or materialized view. Corresponds to the JSON property numTotalLogicalBytes

Returns:

  • (Fixnum) 


10953
10954
10955
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10953

def num_total_logical_bytes
  @num_total_logical_bytes
end

#num_total_physical_bytes ⇒ Fixnum

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. Corresponds to the JSON property numTotalPhysicalBytes

Returns:

  • (Fixnum) 


10960
10961
10962
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10960

def num_total_physical_bytes
  @num_total_physical_bytes
end

#partition_definition ⇒ Google::Apis::BigqueryV2::PartitioningDefinition

The partitioning information, which includes managed table, external table and metastore partitioned table partition information. Corresponds to the JSON property partitionDefinition

Returns:



10966
10967
10968
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10966

def partition_definition
  @partition_definition
end

#range_partitioning ⇒ Google::Apis::BigqueryV2::RangePartitioning

If specified, configures range partitioning for this table. Corresponds to the JSON property rangePartitioning

Returns:



10971
10972
10973
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10971

def range_partitioning
  @range_partitioning
end

#replicas ⇒ Array<Google::Apis::BigqueryV2::TableReference>

Optional. Output only. Table references of all replicas currently active on the table. Corresponds to the JSON property replicas

Returns:



10977
10978
10979
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10977

def replicas
  @replicas
end

#require_partition_filter ⇒ Boolean Also known as: require_partition_filter?

Optional. If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Corresponds to the JSON property requirePartitionFilter

Returns:

  • (Boolean) 


10983
10984
10985
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10983

def require_partition_filter
  @require_partition_filter
end

#resource_tags ⇒ Hash<String,String>

[Optional] The tags associated with this table. Tag keys are globally unique. See additional information on tags. An object containing a list of "key": value pairs. The key is the namespaced friendly name of the tag key, e.g. "12345/ environment" where 12345 is parent id. The value is the friendly short name of the tag value, e.g. "production". Corresponds to the JSON property resourceTags

Returns:

  • (Hash<String,String>) 


10994
10995
10996
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 10994

def resource_tags
  @resource_tags
end

#restrictions ⇒ Google::Apis::BigqueryV2::RestrictionConfig

Optional. Output only. Restriction config for table. If set, restrict certain accesses on the table based on the config. See Data egress for more details. Corresponds to the JSON property restrictions

Returns:



11002
11003
11004
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11002

def restrictions
  @restrictions
end

#schema ⇒ Google::Apis::BigqueryV2::TableSchema

Schema of a table Corresponds to the JSON property schema

Returns:



11007
11008
11009
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11007

def schema
  @schema
end

#self_link ⇒ String

Output only. A URL that can be used to access this resource again. Corresponds to the JSON property selfLink

Returns:

  • (String) 


11012
11013
11014
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11012

def self_link
  @self_link
end

#snapshot_definition ⇒ Google::Apis::BigqueryV2::SnapshotDefinition

Information about base table and snapshot time of the snapshot. Corresponds to the JSON property snapshotDefinition

Returns:



11017
11018
11019
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11017

def snapshot_definition
  @snapshot_definition
end

#streaming_buffer ⇒ Google::Apis::BigqueryV2::Streamingbuffer

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. Corresponds to the JSON property streamingBuffer

Returns:



11024
11025
11026
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11024

def streaming_buffer
  @streaming_buffer
end

#table_constraints ⇒ Google::Apis::BigqueryV2::TableConstraints

The TableConstraints defines the primary key and foreign key. Corresponds to the JSON property tableConstraints

Returns:



11029
11030
11031
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11029

def table_constraints
  @table_constraints
end

#table_reference ⇒ Google::Apis::BigqueryV2::TableReference

Required. Reference describing the ID of this table. Corresponds to the JSON property tableReference

Returns:



11034
11035
11036
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11034

def table_reference
  @table_reference
end

#table_replication_info ⇒ Google::Apis::BigqueryV2::TableReplicationInfo

Replication info of a table created using AS REPLICA DDL like: CREATE MATERIALIZED VIEW mv1 AS REPLICA OF src_mv Corresponds to the JSON property tableReplicationInfo

Returns:



11040
11041
11042
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11040

def table_replication_info
  @table_replication_info
end

#time_partitioning ⇒ Google::Apis::BigqueryV2::TimePartitioning

If specified, configures time-based partitioning for this table. Corresponds to the JSON property timePartitioning

Returns:



11045
11046
11047
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11045

def time_partitioning
  @time_partitioning
end

#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. * EXTERNAL: A table that references data stored in an external storage system, such as Google Cloud Storage. * MATERIALIZED_VIEW: A precomputed view defined by a SQL query. * SNAPSHOT: An immutable BigQuery table that preserves the contents of a base table at a particular time. See additional information on table snapshots. The default value is TABLE. Corresponds to the JSON property type

Returns:

  • (String) 


11057
11058
11059
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11057

def type
  @type
end

#view ⇒ Google::Apis::BigqueryV2::ViewDefinition

Describes the definition of a logical view. Corresponds to the JSON property view

Returns:



11062
11063
11064
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11062

def view
  @view
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



11069
11070
11071
11072
11073
11074
11075
11076
11077
11078
11079
11080
11081
11082
11083
11084
11085
11086
11087
11088
11089
11090
11091
11092
11093
11094
11095
11096
11097
11098
11099
11100
11101
11102
11103
11104
11105
11106
11107
11108
11109
11110
11111
11112
11113
11114
11115
11116
11117
11118
11119
11120
11121
11122
 
# File 'lib/google/apis/bigquery_v2/classes.rb', line 11069

def update!(**args)
  @biglake_configuration = args[:biglake_configuration] if args.key?(:biglake_configuration)
  @clone_definition = args[:clone_definition] if args.key?(:clone_definition)
  @clustering = args[:clustering] if args.key?(:clustering)
  @creation_time = args[:creation_time] if args.key?(:creation_time)
  @default_collation = args[:default_collation] if args.key?(:default_collation)
  @default_rounding_mode = args[:default_rounding_mode] if args.key?(:default_rounding_mode)
  @description = args[:description] if args.key?(:description)
  @encryption_configuration = args[:encryption_configuration] if args.key?(:encryption_configuration)
  @etag = args[:etag] if args.key?(:etag)
  @expiration_time = args[:expiration_time] if args.key?(:expiration_time)
  @external_catalog_table_options = args[:external_catalog_table_options] if args.key?(:external_catalog_table_options)
  @external_data_configuration = args[:external_data_configuration] if args.key?(:external_data_configuration)
  @friendly_name = args[:friendly_name] if args.key?(:friendly_name)
  @id = args[:id] if args.key?(:id)
  @kind = args[:kind] if args.key?(:kind)
  @labels = args[:labels] if args.key?(:labels)
  @last_modified_time = args[:last_modified_time] if args.key?(:last_modified_time)
  @location = args[:location] if args.key?(:location)
  @managed_table_type = args[:managed_table_type] if args.key?(:managed_table_type)
  @materialized_view = args[:materialized_view] if args.key?(:materialized_view)
  @materialized_view_status = args[:materialized_view_status] if args.key?(:materialized_view_status)
  @max_staleness = args[:max_staleness] if args.key?(:max_staleness)
  @model = args[:model] if args.key?(:model)
  @num_active_logical_bytes = args[:num_active_logical_bytes] if args.key?(:num_active_logical_bytes)
  @num_active_physical_bytes = args[:num_active_physical_bytes] if args.key?(:num_active_physical_bytes)
  @num_bytes = args[:num_bytes] if args.key?(:num_bytes)
  @num_current_physical_bytes = args[:num_current_physical_bytes] if args.key?(:num_current_physical_bytes)
  @num_long_term_bytes = args[:num_long_term_bytes] if args.key?(:num_long_term_bytes)
  @num_long_term_logical_bytes = args[:num_long_term_logical_bytes] if args.key?(:num_long_term_logical_bytes)
  @num_long_term_physical_bytes = args[:num_long_term_physical_bytes] if args.key?(:num_long_term_physical_bytes)
  @num_partitions = args[:num_partitions] if args.key?(:num_partitions)
  @num_physical_bytes = args[:num_physical_bytes] if args.key?(:num_physical_bytes)
  @num_rows = args[:num_rows] if args.key?(:num_rows)
  @num_time_travel_physical_bytes = args[:num_time_travel_physical_bytes] if args.key?(:num_time_travel_physical_bytes)
  @num_total_logical_bytes = args[:num_total_logical_bytes] if args.key?(:num_total_logical_bytes)
  @num_total_physical_bytes = args[:num_total_physical_bytes] if args.key?(:num_total_physical_bytes)
  @partition_definition = args[:partition_definition] if args.key?(:partition_definition)
  @range_partitioning = args[:range_partitioning] if args.key?(:range_partitioning)
  @replicas = args[:replicas] if args.key?(:replicas)
  @require_partition_filter = args[:require_partition_filter] if args.key?(:require_partition_filter)
  @resource_tags = args[:resource_tags] if args.key?(:resource_tags)
  @restrictions = args[:restrictions] if args.key?(:restrictions)
  @schema = args[:schema] if args.key?(:schema)
  @self_link = args[:self_link] if args.key?(:self_link)
  @snapshot_definition = args[:snapshot_definition] if args.key?(:snapshot_definition)
  @streaming_buffer = args[:streaming_buffer] if args.key?(:streaming_buffer)
  @table_constraints = args[:table_constraints] if args.key?(:table_constraints)
  @table_reference = args[:table_reference] if args.key?(:table_reference)
  @table_replication_info = args[:table_replication_info] if args.key?(:table_replication_info)
  @time_partitioning = args[:time_partitioning] if args.key?(:time_partitioning)
  @type = args[:type] if args.key?(:type)
  @view = args[:view] if args.key?(:view)
end