GCP Plugin GCP SQL Instances 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

v17.4.2

Type

Source

Platforms

Date Published

December 18, 2024

Price per 1M rows

Starting from $17

monthly free quota

1M rows

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_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_groups
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_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_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_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 SQL Instances

The gcp_sql_instances table shows data for GCP SQL Instances.

https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1beta4/instances#DatabaseInstance

Table Options #

list_instances ([]*CustomSqlListInstancesRequest) (nullable)

CustomSqlListInstancesRequest #

filter (string)
Filter sets the optional parameter "filter": A filter expression that filters resources listed in the response. The expression is in the form of field. For example, 'instanceType'. Fields can be nested as needed as per their JSON representation, such as 'settings.userLabels.auto_start'. Multiple filter queries are space-separated. For example. 'state instanceType'. By default, each expression is an AND expression. However, you can include AND and OR expressions explicitly.

Primary Keys #

Name	Type
self_link	`utf8`

Columns #

Name	Type
available_maintenance_versions	`list<item: utf8, nullable>`
backend_type	`utf8`
connection_name	`utf8`
_cq_id	`uuid`
_cq_parent_id	`uuid`
create_time	`utf8`
current_disk_size	`int64`
database_installed_version	`utf8`
database_version	`utf8`
disk_encryption_configuration	`json`
disk_encryption_status	`json`
dns_name	`utf8`
etag	`utf8`
failover_replica	`json`
gce_zone	`utf8`
gemini_config	`json`
instance_type	`utf8`
ip_addresses	`json`
ipv6_address	`utf8`
kind	`utf8`
maintenance_version	`utf8`
master_instance_name	`utf8`
max_disk_size	`int64`
name	`utf8`
on_premises_configuration	`json`
out_of_disk_report	`json`
primary_dns_name	`utf8`
project	`utf8`
project_id	`utf8`
psc_service_attachment_link	`utf8`
region	`utf8`
replica_configuration	`json`
replica_names	`list<item: utf8, nullable>`
replication_cluster	`json`
root_password	`utf8`
satisfies_pzi	`bool`
satisfies_pzs	`bool`
scheduled_maintenance	`json`
secondary_gce_zone	`utf8`
self_link	`utf8`
server_ca_cert	`json`
service_account_email_address	`utf8`
settings	`json`
sql_network_architecture	`utf8`
state	`utf8`
suspension_reason	`list<item: utf8, nullable>`
switch_transaction_logs_to_cloud_storage_enabled	`bool`
upgradable_database_versions	`json`
write_endpoint	`utf8`

Relations

The following tables depend on "GCP SQL Instances":

GCP SQL Users