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_machine_type

A machine type is a set of virtualized hardware resources available to a virtual machine (VM) instance, including the system memory size, virtual CPU (vCPU) count, and persistent disk limits.

In Compute Engine, machine types are grouped and curated by families for different workloads. Compute Engine offers general-purpose, memory-optimized, compute-optimized, and accelerated-optimized families.

Examples

Basic info

select
name,
id,
description,
guest_cpus,
maximum_persistent_disks,
maximum_persistent_disks_size_gb
from
gcp_compute_machine_type;

List machine types with more than 48 cores

select
name,
id,
description,
guest_cpus
from
gcp_compute_machine_type
where
guest_cpus >= 48;

List machine types with shared CPUs

select
name,
id,
is_shared_cpu
from
gcp_compute_machine_type
where
is_shared_cpu;

Get accelerator configurations assigned to each machine type

select
name,
id,
a -> 'guestAcceleratorCount' as guest_accelerator_count,
a ->> 'guestAcceleratorType' as guest_accelerator_type
from
gcp_compute_machine_type,
jsonb_array_elements(accelerators) as a;

.inspect gcp_compute_machine_type

GCP Compute Machine Type

NameTypeDescription
acceleratorsjsonbA list of accelerator configurations assigned to this machine type.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timestamptimestamp without time zoneCreation timestamp in RFC3339 text format.
descriptiontextAn optional textual description of the resource.
guest_cpusbigintThe number of virtual CPUs that are available to the instance.
idbigintAn unique identifier for the resource. This identifier is defined by the server.
image_space_gbbigintThe amount of memory available for image ig GB.
is_shared_cpubooleanWhether this machine type has a shared CPU.
kindtextThe type of the resource. Always compute#machineType for machine types.
maximum_persistent_disksbigintMaximum persistent disks allowed.
maximum_persistent_disks_size_gbbigintMaximum total persistent disks size (GB) allowed.
memory_mbbigintThe amount of physical memory available to the instance, defined in MB.
nametextName of the resource.
projecttextThe GCP Project in which the resource is located.
scratch_disksjsonbA list of extended scratch disks assigned to the instance.
self_linktextServer-defined URL for the resource.
titletextTitle of the resource.