steampipe plugin install gcp

Table: gcp_project_service - Query Google Cloud Platform Project Services using SQL

A Project Service in Google Cloud Platform is a service that has been enabled for a specific project. These services include various APIs and cloud-based solutions provided by Google, such as Compute Engine, App Engine, Cloud Storage, BigQuery, and more. Having access to project service information allows users to understand and manage the services and APIs that are currently in use for a given project.

Table Usage Guide

The gcp_project_service table provides insights into the enabled services and APIs within a Google Cloud Platform project. As a cloud architect or administrator, you can explore service-specific details through this table, including service names, project IDs, and states of services. Use it to manage and monitor the enabled services and APIs, ensuring optimal utilization and compliance with organizational policies.

Examples

Basic info

Explore the various services associated with your Google Cloud Platform project. This query is useful for understanding what services are currently active within your project, aiding in project management and resource allocation.

select
*
from
gcp_project_service;
select
*
from
gcp_project_service;

List of services which are enabled

Explore which services are currently active within your Google Cloud Platform project. This is useful for maintaining awareness of your operational services and ensuring that only necessary services are enabled, enhancing security and cost-efficiency.

select
name,
state
from
gcp_project_service
where
state = 'ENABLED';
select
name,
state
from
gcp_project_service
where
state = 'ENABLED';

Schema for gcp_project_service

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametext=The resource name of the consumer and service
parenttextThe resource name of the consumer
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetext!=, =Specifies the state of the service

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- gcp

You can pass the configuration to the command with the --config argument:

steampipe_export_gcp --config '<your_config>' gcp_project_service