Table: gcp_bigquery_tables
This table shows data for GCP BigQuery Tables.
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#Table (opens in a new tab)
The composite primary key for this table is (project_id, id).
Relations
This table depends on gcp_bigquery_datasets.
Columns
Name | Type |
---|---|
_cq_source_name | String |
_cq_sync_time | Timestamp |
_cq_id | UUID |
_cq_parent_id | UUID |
project_id (PK) | String |
clone_definition | JSON |
clustering | JSON |
creation_time | Int |
default_collation | String |
default_rounding_mode | String |
description | String |
encryption_configuration | JSON |
etag | String |
expiration_time | Int |
external_data_configuration | JSON |
friendly_name | String |
id (PK) | String |
kind | String |
labels | JSON |
last_modified_time | Int |
location | String |
materialized_view | JSON |
max_staleness | String |
model | JSON |
num_bytes | Int |
num_long_term_bytes | Int |
num_physical_bytes | Int |
num_rows | Int |
num_active_logical_bytes | Int |
num_active_physical_bytes | Int |
num_long_term_logical_bytes | Int |
num_long_term_physical_bytes | Int |
num_partitions | Int |
num_time_travel_physical_bytes | Int |
num_total_logical_bytes | Int |
num_total_physical_bytes | Int |
range_partitioning | JSON |
require_partition_filter | Bool |
schema | JSON |
self_link | String |
snapshot_definition | JSON |
streaming_buffer | JSON |
table_reference | JSON |
time_partitioning | JSON |
type | String |
view | JSON |