Table: gcp_project - Query Google Cloud Platform Projects using SQL

A Google Cloud Platform Project acts as an organizational unit within GCP where resources are allocated. It is used to group resources that belong to the same logical application or business unit. Each project is linked to a billing account and can have users, roles, and permissions assigned to it.

Table Usage Guide

The gcp_project table provides insights into Projects within Google Cloud Platform. As a DevOps engineer, explore project-specific details through this table, including ID, name, labels, and lifecycle state. Utilize it to uncover information about projects, such as their associated resources, user roles, permissions, and billing details.

Examples

Basic info

Explore which Google Cloud Platform projects are active, by looking at their lifecycle state and creation time. This can help you manage resources effectively and keep track of ongoing projects.

select
  name,
  project_id,
  project_number,
  lifecycle_state,
  create_time
from
  gcp_project;

select
  name,
  project_id,
  project_number,
  lifecycle_state,
  create_time
from
  gcp_project;

Get access approval settings for all projects

Explore the access approval settings across your various projects. This can help you understand and manage permissions and approvals more effectively.

select
  name,
  jsonb_pretty(access_approval_settings) as access_approval_settings
from
  gcp_project;

select
  name,
  access_approval_settings
from
  gcp_project;

Query examples

Control examples

Schema for gcp_project

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
access_approval_settings	jsonb	The access approval settings associated with this project.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
create_time	timestamp with time zone	Creation time of the project.
labels	jsonb	A list of labels attached to this project.
lifecycle_state	text	Specifies the project lifecycle state.
name	text	The name of the project.
parent	jsonb	An optional reference to a parent Resource.
project_id	text	An unique, user-assigned ID of the Project.
project_number	bigint	The number uniquely identifying the project.
self_link	text	Server-defined URL for the resource.
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.

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