GCP Plugin GCP BigQuery Tables table

Official

Premium

GCP

The GCP Source plugin for CloudQuery extracts configuration from a variety of GCP APIs and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v18.6.1

Type

Source

Platforms

Date Published

Documentation Tables Changelog Destinations

gcp_accessapproval_folder_approval_requests
gcp_accessapproval_folder_service_accounts
gcp_accessapproval_folder_settings
gcp_accessapproval_organization_approval_requests
gcp_accessapproval_organization_service_accounts
gcp_accessapproval_organization_settings
gcp_accessapproval_project_approval_requests
gcp_accessapproval_project_service_accounts
gcp_accessapproval_project_settings
gcp_aiplatform_dataset_locations
- gcp_aiplatform_datasets
gcp_aiplatform_endpoint_locations
- gcp_aiplatform_endpoints
gcp_aiplatform_featurestore_locations
- gcp_aiplatform_featurestores
gcp_aiplatform_indexendpoint_locations
- gcp_aiplatform_index_endpoints
gcp_aiplatform_index_locations
- gcp_aiplatform_indexes
gcp_aiplatform_job_locations
- gcp_aiplatform_batch_prediction_jobs
- gcp_aiplatform_custom_jobs
- gcp_aiplatform_hyperparameter_tuning_jobs
- gcp_aiplatform_model_deployment_monitoring_jobs
gcp_aiplatform_metadata_locations
- gcp_aiplatform_metadata_stores
gcp_aiplatform_model_locations
- gcp_aiplatform_models
gcp_aiplatform_operations
gcp_aiplatform_pipeline_locations
- gcp_aiplatform_pipeline_jobs
- gcp_aiplatform_training_pipelines
gcp_aiplatform_specialistpool_locations
- gcp_aiplatform_specialist_pools
gcp_aiplatform_tensorboard_locations
- gcp_aiplatform_tensorboards
gcp_aiplatform_vizier_locations
- gcp_aiplatform_studies
gcp_apigateway_apis
gcp_apigateway_gateways
gcp_apikeys_keys
gcp_appengine_apps
gcp_appengine_authorized_certificates
gcp_appengine_authorized_domains
gcp_appengine_domain_mappings
gcp_appengine_firewall_ingress_rules
gcp_appengine_services
- gcp_appengine_versions
  - gcp_appengine_instances
gcp_applicationintegration_authconfigs
gcp_applicationintegration_certificates
gcp_applicationintegration_integrations
- gcp_applicationintegration_integration_executions
  - gcp_applicationintegration_integration_execution_suspensions
- gcp_applicationintegration_integration_versions
gcp_applicationintegration_sfdc_instances
- gcp_applicationintegration_sfdc_channels
gcp_artifactregistry_locations
- gcp_artifactregistry_repositories
  - gcp_artifactregistry_docker_images
  - gcp_artifactregistry_files
  - gcp_artifactregistry_packages
    - gcp_artifactregistry_tags
    - gcp_artifactregistry_versions
gcp_baremetalsolution_instances
gcp_baremetalsolution_networks
gcp_baremetalsolution_nfs_shares
gcp_baremetalsolution_volumes
- gcp_baremetalsolution_volume_luns
gcp_batch_jobs
gcp_batch_task_groups
- gcp_batch_tasks
gcp_beyondcorp_app_connections
gcp_beyondcorp_app_connectors
gcp_beyondcorp_app_gateways
gcp_bigquery_datasets
- gcp_bigquery_tables
gcp_bigquerydatatransfer_configs
- gcp_bigquerydatatransfer_runs
  - gcp_bigquerydatatransfer_logs
gcp_bigquerydatatransfer_datasources
gcp_bigquerydatatransfer_locations
gcp_bigtableadmin_instances
- gcp_bigtableadmin_app_profiles
- gcp_bigtableadmin_clusters
  - gcp_bigtableadmin_backups
- gcp_bigtableadmin_tables
gcp_billing_billing_accounts
- gcp_billing_budgets
gcp_billing_services
gcp_binaryauthorization_assertors
gcp_certificatemanager_certificate_issuance_configs
gcp_certificatemanager_certificate_maps
- gcp_certificatemanager_certificate_map_entries
gcp_certificatemanager_certificates
gcp_certificatemanager_dns_authorizations
gcp_cloudassetinventory_feeds
gcp_cloudassetinventory_savedqueries
gcp_cloudbuild_builds
gcp_cloudbuild_connections
- gcp_cloudbuild_connection_repositories
gcp_cloudbuild_triggers
gcp_cloudbuild_worker_pools
gcp_clouddeploy_delivery_pipelines
- gcp_clouddeploy_releases
  - gcp_clouddeploy_rollouts
    - gcp_clouddeploy_job_runs
gcp_clouddeploy_targets
gcp_clouderrorreporting_error_group_stats
- gcp_clouderrorreporting_error_events
gcp_cloudresourcemanager_organizations
gcp_cloudscheduler_locations
- gcp_cloudscheduler_jobs
gcp_cloudsupport_cases
gcp_cloudtasks_locations
- gcp_cloudtasks_queues
- gcp_cloudtasks_tasks
gcp_cloudtrace_traces
gcp_composer_environments
gcp_composer_image_versions
gcp_composer_operations
gcp_compute_addresses
gcp_compute_autoscalers
gcp_compute_backend_buckets
gcp_compute_backend_services
gcp_compute_disks
gcp_compute_disk_types
gcp_compute_external_vpn_gateways
gcp_compute_firewalls
gcp_compute_forwarding_rules
gcp_compute_global_addresses
gcp_compute_health_checks
gcp_compute_images
gcp_compute_instance_group_managers
gcp_compute_instance_groups
- gcp_compute_instance_group_instances
gcp_compute_instances
gcp_compute_interconnect_locations
- gcp_compute_interconnect_attachments
gcp_compute_interconnect_remote_locations
gcp_compute_interconnects
gcp_compute_network_endpoint_groups
gcp_compute_networks
gcp_compute_osconfig_os_patch_deployments
gcp_compute_osconfig_os_patch_jobs
- gcp_compute_osconfig_os_patch_jobs_instance_details
gcp_compute_packet_mirrorings
gcp_compute_projects
gcp_compute_routers
- gcp_compute_router_nat_mapping_infos
gcp_compute_routes
gcp_compute_security_policies
gcp_compute_snapshots
gcp_compute_ssl_certificates
gcp_compute_ssl_policies
gcp_compute_subnetworks
gcp_compute_target_grpc_proxies
gcp_compute_target_http_proxies
gcp_compute_target_https_proxies
gcp_compute_target_instances
gcp_compute_target_pools
gcp_compute_target_ssl_proxies
gcp_compute_target_tcp_proxies
gcp_compute_target_vpn_gateways
gcp_compute_url_maps
gcp_compute_vpn_gateways
gcp_compute_vpn_tunnels
gcp_compute_zones
- gcp_compute_machine_types
- gcp_compute_osconfig_inventories
- gcp_compute_osconfig_os_policy_assignments
- gcp_compute_osconfig_os_policy_assignment_reports
- gcp_compute_osconfig_os_vulnerability_reports
gcp_containeranalysis_occurrences
gcp_container_clusters
gcp_dataflow_jobs
- gcp_dataflow_job_messages
- gcp_dataflow_job_metrics
gcp_dataflow_snapshots
gcp_datafusion_available_versions
gcp_datafusion_instances
- gcp_datafusion_instance_operations
gcp_dataproc_regions
- gcp_dataproc_autoscaling_policies
- gcp_dataproc_clusters
  - gcp_dataproc_cluster_nodegroups
- gcp_dataproc_jobs
gcp_deploymentmanager_deployments
- gcp_deploymentmanager_manifests
- gcp_deploymentmanager_resources
gcp_deploymentmanager_operations
gcp_deploymentmanager_types
gcp_dns_managed_zones
- gcp_dns_resource_record_sets
gcp_dns_policies
gcp_domains_registrations
gcp_essentialcontacts_folder_contacts
gcp_essentialcontacts_organization_contacts
gcp_essentialcontacts_project_contacts
gcp_eventarc_channels
gcp_eventarc_providers
gcp_eventarc_triggers
gcp_filestore_backups
gcp_filestore_instances
gcp_filestore_locations
gcp_filestore_operations
gcp_filestore_snapshots
gcp_firebaseappcheck_app_attest_configs
gcp_firebaseappcheck_device_check_configs
gcp_firebaseappcheck_play_integrity_configs
gcp_firebaseappcheck_recaptcha_configs
gcp_firebaseappcheck_recaptcha_enterprise_configs
gcp_firebaseappcheck_safety_net_configs
gcp_firebase_hosting_sites
- gcp_firebase_hosting_site_custom_domains
- gcp_firebase_hosting_site_releases
- gcp_firebase_hosting_site_versions
- gcp_firebase_hosting_site_channels
gcp_firestore_databases
gcp_functions_functions
gcp_functionsv2_functions
gcp_iam_deny_policies
gcp_iam_organizational_roles
gcp_iam_predefined_roles
gcp_iam_roles
gcp_iam_service_accounts
- gcp_iam_service_account_keys
gcp_identitytoolkit_accounts
gcp_identitytoolkit_default_supported_idps
gcp_identitytoolkit_inbound_saml_configs
gcp_identitytoolkit_oauth_idp_configs
gcp_identitytoolkit_project_configs
gcp_identitytoolkit_project_public_configs
gcp_identitytoolkit_recaptcha_params
gcp_identitytoolkit_tenants
gcp_kms_locations
- gcp_kms_keyrings
  - gcp_kms_crypto_keys
    - gcp_kms_crypto_key_versions
  - gcp_kms_import_jobs
- gcp_kms_ekm_connections
gcp_livestream_channels
gcp_livestream_inputs
gcp_logging_metrics
gcp_logging_sinks
gcp_looker_instances
- gcp_looker_instance_operations
gcp_memorystore_locations
- gcp_memorystore_instances
- gcp_memorystore_operations
gcp_monitoring_alert_policies
gcp_networkconnectivity_locations
- gcp_networkconnectivity_internal_ranges
gcp_networkintelligencecenter_connectivity_tests
gcp_networkintelligencecenter_locations
gcp_networkintelligencecenter_operations
gcp_networksecurity_address_groups
gcp_networksecurity_firewall_endpoints
gcp_networksecurity_security_profile_groups
gcp_networksecurity_security_profiles
gcp_networksecurity_tls_inspection_policies
gcp_networkservices_endpoint_policies
gcp_networkservices_gateways
gcp_networkservices_grpc_routes
gcp_networkservices_http_routes
gcp_networkservices_meshes
gcp_networkservices_service_bindings
gcp_networkservices_tcp_routes
gcp_networkservices_tls_routes
gcp_policyanalyzer_activities
gcp_projects
gcp_pubsub_schemas
- gcp_pubsub_schema_revisions
gcp_pubsub_snapshots
gcp_pubsub_subscriptions
gcp_pubsub_topics
gcp_recommendations_folders
gcp_recommendations_organizations
gcp_recommendations_projects
gcp_redis_instances
gcp_resourcemanager_folder_policies
gcp_resourcemanager_folders
- gcp_resourcemanager_subfolders
gcp_resourcemanager_organization_policies
gcp_resourcemanager_organization_tag_keys
- gcp_resourcemanager_organization_tag_values
gcp_resourcemanager_project_policies
gcp_resourcemanager_projects
gcp_resourcemanager_project_tag_bindings
gcp_resourcemanager_project_tag_keys
- gcp_resourcemanager_project_tag_values
gcp_run_locations
- gcp_run_services
gcp_secretmanager_secrets
gcp_securitycenter_folder_event_threat_detection
gcp_securitycenter_folder_findings
gcp_securitycenter_organization_findings
gcp_securitycenter_org_event_threat_detection_settings
gcp_securitycenter_project_event_threat_detection
gcp_securitycenter_project_findings
gcp_serviceusage_services
gcp_sourcerepo_config
gcp_sourcerepo_repos
gcp_sql_instances
- gcp_sql_users
gcp_storage_buckets
- gcp_storage_bucket_policies
- gcp_storage_bucket_objects
gcp_storage_hmac_keys
gcp_storagetransfer_agent_pools
gcp_storagetransfer_transfer_jobs
gcp_storagetransfer_transfer_operations
gcp_translate_glossaries
gcp_videotranscoder_jobs
gcp_videotranscoder_job_templates
gcp_vision_products
- gcp_vision_product_reference_images
gcp_vmmigration_groups
gcp_vmmigration_sources
- gcp_vmmigration_source_datacenter_connectors
- gcp_vmmigration_source_migrating_vms
  - gcp_vmmigration_source_migrating_vm_clone_jobs
  - gcp_vmmigration_source_migrating_vm_cutover_jobs
- gcp_vmmigration_source_utilization_reports
gcp_vmmigration_target_projects
gcp_vpcaccess_locations
- gcp_vpcaccess_connectors
gcp_websecurityscanner_scan_configs
- gcp_websecurityscanner_scan_config_scan_runs
  - gcp_websecurityscanner_scan_config_scan_run_findings
  - gcp_websecurityscanner_scan_config_scan_run_crawled_urls
gcp_workflows_workflows

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

Primary Keys #

Name	Type
id	`utf8`
project_id	`utf8`

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`
managed_table_type	`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_current_physical_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`
restrictions	`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