Back to source list
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.1.3
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
GCP Compute Instances
The gcp_compute_instances table shows data for GCP Compute Instances.
Table Options #
aggregated_list_instances
([]*CustomComputeAggregatedListInstancesRequest
) (nullable)
CustomComputeAggregatedListInstancesRequest #
filter
(string
) (nullable)A filter expression that filters resources listed in the response. Most Compute resources support two types of filter expressions: expressions that support regular expressions and expressions that follow API improvement proposal AIP-160. These two types of filter expressions cannot be mixed in one request. If you want to use AIP-160, your expression must specify the field name, an operator, and the value that you want to use for filtering. The value must be a string, a number, or a boolean. The operator must be either=
,!=
,>
,<
,<=
,>=
or:
. For example, if you are filtering Compute Engine instances, you can exclude instances namedexample-instance
by specifyingname != example-instance
. The:*
comparison can be used to test whether a key has been defined. For example, to find all objects withowner
label use:labels.owner:*
You can also filter nested fields. For example, you could specifyscheduling.automaticRestart = false
to include instances only if they are not scheduled for automatic restarts. You can use filtering on nested fields to filter based on resource labels. To filter on multiple expressions, provide each separate expression within parentheses. For example:(scheduling.automaticRestart = true) (cpuPlatform = "Intel Skylake")
By default, each expression is anAND
expression. However, you can includeAND
andOR
expressions explicitly. For example:(cpuPlatform = "Intel Skylake") OR (cpuPlatform = "Intel Broadwell") AND (scheduling.automaticRestart = true)
If you want to use a regular expression, use theeq
(equal) orne
(not equal) operator against a single un-parenthesized expression with or without quotes or against multiple parenthesized expressions. Examples:fieldname eq unquoted literal
fieldname eq 'single quoted literal'
fieldname eq "double quoted literal"
(fieldname1 eq literal) (fieldname2 ne "literal")
The literal value is interpreted as a regular expression using Google RE2 library syntax. The literal value must match the entire field. For example, to filter for instances that do not end with name "instance", you would usename ne .*instance
. You cannot combine constraints on multiple fields using regular expressions.include_all_scopes
(boolean
) (nullable)Indicates whether every visible scope for each scope type (zone, region, global) should be included in the response. For new resource types added after this field, the flag has no effect as new resource types will always include every visible scope for each scope type in response. For resource types which predate this field, if this flag is omitted or false, only scopes of the scope types where the resource type is expected to be found will be included.max_results
(integer
) (nullable)The maximum number of results per page that should be returned. If the number of available results is larger thanmaxResults
, Compute Engine returns anextPageToken
that can be used to get the next page of results in subsequent list requests. Acceptable values are0
to500
, inclusive. (Default:500
)order_by
(string
) (nullable)Sorts list results by a certain order. By default, results are returned in alphanumerical order based on the resource name. You can also sort results in descending order based on the creation timestamp usingorderBy="creationTimestamp desc"
. This sorts results based on thecreationTimestamp
field in reverse chronological order (newest result first). Use this to sort resources like operations so that the newest operation is returned first. Currently, only sorting byname
orcreationTimestamp desc
is supported.page_token
(string
) (nullable)Specifies a page token to use. SetpageToken
to thenextPageToken
returned by a previous list request to get the next page of results.project
(string
)Project ID for this request.return_partial_success
(boolean
) (nullable)Opt-in for partial success behavior which provides partial results in case of failure. The default value is false. For example, when partial success behavior is enabled, aggregatedList for a single zone scope either returns all resources in the zone or no resources, with an error code.service_project_number
(integer
) (nullable)The Shared VPC service project id or service project number for which aggregated list request is invoked for subnetworks list-usable api.
Primary Keys #
Name | Type |
---|---|
self_link | utf8 |
Columns #
Name | Type |
---|---|
advanced_machine_features | json |
can_ip_forward | bool |
confidential_instance_config | json |
cpu_platform | utf8 |
_cq_id | uuid |
_cq_parent_id | uuid |
creation_timestamp | utf8 |
deletion_protection | bool |
description | utf8 |
disks | json |
display_device | json |
fingerprint | utf8 |
guest_accelerators | json |
hostname | utf8 |
id | int64 |
instance_encryption_key | json |
key_revocation_action_type | utf8 |
kind | utf8 |
label_fingerprint | utf8 |
labels | json |
last_start_timestamp | utf8 |
last_stop_timestamp | utf8 |
last_suspended_timestamp | utf8 |
machine_type | utf8 |
metadata | json |
min_cpu_platform | utf8 |
name | utf8 |
network_interfaces | json |
network_performance_config | json |
params | json |
private_ipv6_google_access | utf8 |
project_id | utf8 |
reservation_affinity | json |
resolved_hostname | utf8 |
resource_policies | list<item: utf8, nullable> |
resource_status | json |
satisfies_pzi | bool |
satisfies_pzs | bool |
scheduling | json |
self_link | utf8 |
service_accounts | json |
shielded_instance_config | json |
shielded_instance_integrity_policy | json |
source_machine_image | utf8 |
source_machine_image_encryption_key | json |
start_restricted | bool |
status | utf8 |
status_message | utf8 |
tags | json |
zone | utf8 |