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';

Control examples

Schema for gcp_project_service

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
location	text		The GCP multi-region, region, or zone in which the resource is located.
name	text	=	The resource name of the consumer and service
parent	text		The resource name of the consumer
project	text	=, !=, ~~, ~~, !~~, !~~	The GCP Project in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text	!=, =	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