Back to plugin list
Official
Open-core
GCP
The GCP Source plugin for CloudQuery extracts configuration from a variety of GCP APIs and loads it into any supported CloudQuery destination. Some tables are marked as premium and have a price per 1M rows synced.
Price per 1M rows
Starting from $15
monthly free quota
10M rows
GCP BigQuery Tables
The gcp_bigquery_tables table shows data for GCP BigQuery Tables.
https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#Table
The composite primary key for this table is id, project_id.
Columns
Name | Type |
---|---|
biglake_configuration | json |
clone_definition | json |
clustering | json |
_cq_id | uuid |
_cq_parent_id | uuid |
creation_time | int64 |
default_collation | utf8 |
default_rounding_mode | utf8 |
description | utf8 |
encryption_configuration | json |
etag | utf8 |
expiration_time | int64 |
external_catalog_table_options | json |
external_data_configuration | json |
friendly_name | utf8 |
id | utf8 |
kind | utf8 |
labels | json |
last_modified_time | int64 |
location | utf8 |
materialized_view | json |
materialized_view_status | json |
max_staleness | utf8 |
model | json |
num_active_logical_bytes | int64 |
num_active_physical_bytes | int64 |
num_bytes | int64 |
num_long_term_bytes | int64 |
num_long_term_logical_bytes | int64 |
num_long_term_physical_bytes | int64 |
num_partitions | int64 |
num_physical_bytes | int64 |
num_rows | int64 |
num_time_travel_physical_bytes | int64 |
num_total_logical_bytes | int64 |
num_total_physical_bytes | int64 |
partition_definition | json |
project_id | utf8 |
range_partitioning | json |
replicas | json |
require_partition_filter | bool |
resource_tags | json |
schema | json |
self_link | utf8 |
snapshot_definition | json |
streaming_buffer | json |
table_constraints | json |
table_reference | json |
table_replication_info | json |
time_partitioning | json |
type | utf8 |
view | json |
Relations
This table depends on:
GCP BigQuery Datasets