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_logging_metric

Logs-based metrics are Cloud Monitoring metrics that are based on the content of log entries.

Filter info of each metric

select
name as metric_name,
description,
filter
from
gcp_logging_metric;

Bucket configuration details of the logging metrics

select
name,
exponential_buckets_options_growth_factor,
exponential_buckets_options_num_finite_buckets,
exponential_buckets_options_scale,
linear_buckets_options_num_finite_buckets,
linear_buckets_options_offset,
linear_buckets_options_width,
explicit_buckets_options_bounds
from
gcp_logging_metric;

.inspect gcp_logging_metric

GCP Logging Metric

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
create_timetimestamp without time zoneThe creation timestamp of the metric.
descriptiontextA user-specified, human-readable description of the metric.
explicit_buckets_options_boundsjsonbSpecifies the bounds, used to create a histogram for the distribution.
exponential_buckets_options_growth_factordouble precisionSpecifies the growth factor of a bucket with exponential sequence, used to create a histogram for the distribution. Value must be greater than 1.
exponential_buckets_options_num_finite_bucketsbigintSpecifies the finite buckets, used to create a histogram for the distribution. Value must be greater than 0.
exponential_buckets_options_scaledouble precisionSpecifies the scale. Value must be greater than 0.
filtertextAn advanced logs filter used to match log entries.
label_extractorsjsonbA map from a label key string to an extractor expression which is used to extract data from a log entry field and assign as the label value.
linear_buckets_options_num_finite_bucketsbigintSpecifies the number of finite buckets of linear sequence. Value must be greater than 0.
linear_buckets_options_offsetdouble precisionSpecifies the lower bound of the first bucket.
linear_buckets_options_widthdouble precisionSpecifies the width, used to create a histogram for the distribution.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
metric_descriptor_display_nametextA concise name for the metric, which can be displayed in user interfaces.
metric_descriptor_labelsjsonbThe set of labels that can be used to instance of this metric type.
metric_descriptor_metric_kindtextThe kind of the metric. Possible values are 'METRIC_KIND_UNSPECIFIED', 'GAUGE', 'DELTA', 'CUMULATIVE'.
metric_descriptor_typetextThe metric type, including its DNS name in prefix.
metric_descriptor_unittextThe units in which the metric value is reported.
metric_descriptor_value_typetextThe value type of the measurement.
nametextThe client-assigned metric identifier.
projecttextThe GCP Project in which the resource is located.
titletextTitle of the resource.
update_timetimestamp without time zoneThe last update timestamp of the metric.
value_extractortextA value_extractor is required when using a distribution logs-based metric to extract the values to record from a log entry.
versiontextThe API version that created or updated this metric.