steampipe plugin install gcp

Table: gcp_app_engine_application - Query App Engine Application using SQL

Google Cloud Platform's (GCP) App Engine is a fully managed, serverless platform for developing and hosting web applications at scale. An App Engine application refers to the specific application you deploy on this platform.

Table Usage Guide

The gcp_app_engine_application table provides insights into the App Engine abstracts away the infrastructure, allowing developers to focus on code. It manages the hardware and networking infrastructure required to run your code.

Examples

Basic info

Explore the basic details of your Google Cloud Platform's App Engine Application such as their names, storage bucket, database type, default hostname, and serving status. This information can help you manage and monitor your application more effectively.

select
name,
id,
code_bucket,
database_type,
default_hostname,
gcr_domain,
serving_status
from
gcp_app_engine_application;
select
name,
id,
code_bucket,
database_type,
default_hostname,
gcr_domain,
serving_status
from
gcp_app_engine_application;

Get feature setting details of an application

This is designed to retrieve specific configuration details from App Engine applications within a Google Cloud Platform (GCP) environment.

select
name,
id,
location,
feature_settings -> 'SplitHealthChecks' as split_health_checks,
feature_settings -> 'UseContainerOptimizedOs' as use_container_optimized_os
from
gcp_app_engine_application;
select
name,
id,
location,
json_extract(feature_settings, '$.SplitHealthChecks') as split_health_checks,
json_extract(feature_settings, '$.UseContainerOptimizedOs') as use_container_optimized_os
from
gcp_app_engine_application;

Get service account details for the application

Explore the details about the service account that has been associated with the application.

select
a.name,
a.service_account,
s.email,
s.disabled,
s.oauth2_client_id,
s.iam_policy
from
gcp_app_engine_application as a,
gcp_service_account as s
where
s.name = a.service_account;
select
a.name,
a.service_account,
s.email,
s.disabled,
s.oauth2_client_id,
s.iam_policy
from
gcp_app_engine_application as a
join gcp_service_account as s ON s.name = a.service_account;

Schema for gcp_app_engine_application

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
auth_domaintextGoogle Apps authentication domain that controls which users can access this application.Defaults to open access for any Google Account.
code_buckettextGoogle Cloud Storage bucket that can be used for storing files associated with this application.
database_typetextThe type of the Cloud Firestore or Cloud Datastore database associated with this application.
default_buckettextGoogle Cloud Storage bucket that can be used by this application to store content.@OutputOnly.
default_cookie_expirationtextCookie expiration policy for this application.
default_hostnametextHostname used to reach this application, as resolved by App Engine.@OutputOnly.
dispatch_rulesjsonbHTTP path dispatch rules for requests to the application that do not explicitly target a service or version.
feature_settingsjsonbThe feature specific settings to be used in the application.
gcr_domaintextThe Google Container Registry domain used for storing managed build docker images for this application.
iapjsonbIdentity-Aware Proxy.
idtextIdentifier of the Application resource. This identifier is equivalent to the project ID of the Google Cloud Platform project where you want to deploy your application.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextFull path to the Application resource in the API.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
service_accounttextThe service account associated with the application.
serving_statustextServing status of this application.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle 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_app_engine_application