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

App Engine application IAP should be enabled

Schema for gcp_app_engine_application

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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