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;

Control examples

All Controls > App Engine > App Engine application IAP should be enabled

Schema for gcp_app_engine_application

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
auth_domain	text		Google Apps authentication domain that controls which users can access this application.Defaults to open access for any Google Account.
code_bucket	text		Google Cloud Storage bucket that can be used for storing files associated with this application.
database_type	text		The type of the Cloud Firestore or Cloud Datastore database associated with this application.
default_bucket	text		Google Cloud Storage bucket that can be used by this application to store content.@OutputOnly.
default_cookie_expiration	text		Cookie expiration policy for this application.
default_hostname	text		Hostname used to reach this application, as resolved by App Engine.@OutputOnly.
dispatch_rules	jsonb		HTTP path dispatch rules for requests to the application that do not explicitly target a service or version.
feature_settings	jsonb		The feature specific settings to be used in the application.
gcr_domain	text		The Google Container Registry domain used for storing managed build docker images for this application.
iap	jsonb		Identity-Aware Proxy.
id	text		Identifier 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.
location	text		The GCP multi-region, region, or zone in which the resource is located.
name	text		Full path to the Application resource in the API.
project	text	=, !=, ~~, ~~, !~~, !~~	The GCP Project in which the resource is located.
service_account	text		The service account associated with the application.
serving_status	text		Serving status of this application.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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_app_engine_application