turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
gcp_audit_policygcp_bigquery_datasetgcp_bigquery_jobgcp_bigquery_tablegcp_bigtable_instancegcp_cloudfunctions_functiongcp_compute_addressgcp_compute_backend_bucketgcp_compute_backend_servicegcp_compute_diskgcp_compute_disk_metric_read_opsgcp_compute_disk_metric_read_ops_dailygcp_compute_disk_metric_read_ops_hourlygcp_compute_disk_metric_write_opsgcp_compute_disk_metric_write_ops_dailygcp_compute_disk_metric_write_ops_hourlygcp_compute_firewallgcp_compute_forwarding_rulegcp_compute_global_addressgcp_compute_global_forwarding_rulegcp_compute_imagegcp_compute_instancegcp_compute_instance_metric_cpu_utilizationgcp_compute_instance_metric_cpu_utilization_dailygcp_compute_instance_metric_cpu_utilization_hourlygcp_compute_instance_templategcp_compute_machine_typegcp_compute_networkgcp_compute_node_groupgcp_compute_node_templategcp_compute_project_metadatagcp_compute_regiongcp_compute_resource_policygcp_compute_routergcp_compute_snapshotgcp_compute_ssl_policygcp_compute_subnetworkgcp_compute_target_https_proxygcp_compute_target_poolgcp_compute_target_ssl_proxygcp_compute_target_vpn_gatewaygcp_compute_url_mapgcp_compute_vpn_tunnelgcp_compute_zonegcp_dns_managed_zonegcp_dns_policygcp_dns_record_setgcp_iam_policygcp_iam_rolegcp_kms_keygcp_kms_key_ringgcp_logging_bucketgcp_logging_exclusiongcp_logging_metricgcp_logging_sinkgcp_monitoring_alert_policygcp_monitoring_groupgcp_monitoring_notification_channelgcp_organizationgcp_projectgcp_project_organization_policygcp_project_servicegcp_pubsub_snapshotgcp_pubsub_subscriptiongcp_pubsub_topicgcp_service_accountgcp_service_account_keygcp_sql_backupgcp_sql_databasegcp_sql_database_instancegcp_sql_database_instance_metric_connectionsgcp_sql_database_instance_metric_connections_dailygcp_sql_database_instance_metric_connections_hourlygcp_sql_database_instance_metric_cpu_utilizationgcp_sql_database_instance_metric_cpu_utilization_dailygcp_sql_database_instance_metric_cpu_utilization_hourlygcp_storage_bucket

Table: gcp_compute_node_template

Node templates specify properties for creating sole-tenant nodes, such as node type, vCPU and memory requirements, node affinity labels, and region.

Examples

List of n2-node-80-640 type node templates

select
name,
id,
location,
node_type
from
gcp_compute_node_template
where
node_type = 'n2-node-80-640';

List of node templates where cpu overcommit is enabled

select
name,
id,
node_type
from
gcp_compute_node_template
where
cpu_overcommit_type = 'ENABLED';

Count of node templates per location

select
location,
count(*)
from
gcp_compute_node_template
group by
location;

Find unused node templates

select
t.name,
t.id
from
gcp_compute_node_template as t
left join
gcp_compute_node_group as g on g.node_template = t.self_link
where
g is null;

.inspect gcp_compute_node_template

GCP Compute Node Template

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cpu_overcommit_typetextSpecifies the CPU overcommit.
creation_timestamptimestamp without time zoneThe creation timestamp of the resource.
descriptiontextA user-specified, human-readable description of the node template.
iam_policyjsonbAn Identity and Access Management (IAM) policy, which specifies access controls for Google Cloud resources. A `Policy` is a collection of `bindings`. A `binding` binds one or more `members` to a single `role`. Members can be user accounts, service accounts, Google groups, and domains (such as G Suite). A `role` is a named list of permissions; each `role` can be an IAM predefined role or a user-created custom role. For some types of Google Cloud resources, a `binding` can also specify a `condition`, which is a logical expression that allows access to a resource only if the expression evaluates to `true`.
idbigintThe unique identifier for the resource.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextA friendly name that identifies the resource.
node_affinity_labelsjsonbA list of labels to use for node affinity, which will be used in instance scheduling.
node_typetextSpecifies the type of the nodes to use for node groups, that are created from this template.
node_type_flexibility_cpustextThe URL of the network in which to reserve the address.
node_type_flexibility_local_ssdtextSpecifies the networking tier used for configuring this address.
node_type_flexibility_memorytextSpecifies the prefix length if the resource represents an IP range.
projecttextThe GCP Project in which the resource is located.
regiontextThe name of the region where the node template resides.
self_linktextThe server-defined URL for the resource.
server_binding_typetextSpecifies the binding properties for the physical server.
statustextSpecifies the status of the node template.
status_messagetextA human-readable explanation of the resource status.
titletextTitle of the resource.