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: table_gcp_logging_sink

Sinks represent filtered exports for log entries.

Examples

List writer identity that writes the export logs of logging sink

select
name,
unique_writer_identity
from
gcp_logging_sink;

List the destination path for each sink

select
name,
destination
from
gcp_logging_sink;

.inspect gcp_logging_sink

GCP Logging Sink

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
create_timetimestamp without time zoneThe creation timestamp of the sink
descriptiontextA user-specified, human-readable description of the sink
destinationtextSpecifies the destination, in which the logs will be exported
disabledbooleanSpecifies whether the sink is disabled, or not
exclusionsjsonbA list of exclusion filters. Log entries that match any of the exclusion filters will not be exported.
filtertextAn advanced logs filter. The log entries which will match the filter, will be exported.
include_childrenbooleanSpecifies whether a particular log entry from the children is exported depends on the sink's filter expression
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextThe client-assigned sink identifier, unique within the project
projecttextThe GCP Project in which the resource is located.
self_linktextServer-defined URL for the resource.
titletextTitle of the resource.
unique_writer_identitytextAn IAM identity—a service account or group—under which Logging writes the exported log entries to the sink's destination
update_timetimestamp without time zoneThe last update timestamp of the sink