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.
Publisher
cloudquery
Repositorygithub.com
Latest version
v12.3.1
Type
Source
Platforms
Date Published
Mar 26, 2024
Price per 1M rows
Starting from $15
monthly free quota
10M rows
GCP BigQuery Datasets
The gcp_bigquery_datasets table shows data for GCP BigQuery Datasets.
https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets#Dataset
The composite primary key for this table is id, project_id.
Columns
Name | Type |
---|---|
access | json |
_cq_id | uuid |
_cq_parent_id | uuid |
creation_time | int64 |
dataset_reference | json |
default_collation | utf8 |
default_encryption_configuration | json |
default_partition_expiration_ms | int64 |
default_rounding_mode | utf8 |
default_table_expiration_ms | int64 |
description | utf8 |
etag | utf8 |
external_dataset_reference | json |
friendly_name | utf8 |
id | utf8 |
is_case_insensitive | bool |
kind | utf8 |
labels | json |
last_modified_time | int64 |
linked_dataset_metadata | json |
linked_dataset_source | json |
location | utf8 |
max_time_travel_hours | int64 |
project_id | utf8 |
satisfies_pzi | bool |
satisfies_pzs | bool |
self_link | utf8 |
storage_billing_model | utf8 |
tags | json |
type | utf8 |
Relations
The following tables depend on "GCP BigQuery Datasets":