steampipe plugin install awssteampipe plugin install aws

Table: aws_amplify_app

AWS Amplify is a full-suite package of tools and services specifically designed to help developers create and launch apps with ease. The Apps represent the different branches of a repository for building, deploying, and hosting an Amplify app.

Examples

Basic info

select
  app_id,
  name,
  description,
  arn,
  platform,
  create_time,
  build_spec
from
  aws_amplify_app;

List apps created within the last 90 days

select
  name,
  app_id,
  create_time
from
  aws_amplify_app
where
  create_time >= (now() - interval '90' day)
order by
  create_time;

List apps updated within the last hour

select
  name,
  app_id,
  update_time
from
  aws_amplify_app
where
  update_time >= (now() - interval '1' hour)
order by
  update_time;

Describe information about the production branch for an app

select
  production_branch ->> 'BranchName' as branch_name,
  production_branch ->> 'LastDeployTime' as last_deploy_time,
  production_branch ->> 'Status' as status
from
  aws_amplify_app
where
  name = 'amplify_app_name';

List information about the build spec for an app

select
  name,
  app_id,
  build_spec ->> 'backend' as build_backend_spec,
  build_spec ->> 'frontend' as build_frontend_spec,
  build_spec ->> 'test' as build_test_spec,
  build_spec ->> 'env' as build_env_settings
from
  aws_amplify_app
where
  name = 'amplify_app_name';

List information on rewrite(200) redirect settings for an app

select
  name,
  redirects_array ->> 'Condition' as country_code,
  redirects_array ->> 'Source' as source_address,
  redirects_array ->> 'Status' as redirect_type,
  redirects_array ->> 'Target' as destination_address
from
  aws_amplify_app,
  jsonb_array_elements(custom_rules) as redirects_array
where
  redirects_array ->> 'Status' = '200'
  and name = 'amplify_app_name';

List all apps that have branch auto build enabled

select
  app_id,
  name,
  description,
  arn
from
  aws_amplify_app
where
  enable_branch_auto_build = true;

.inspect aws_amplify_app

AWS Amplify App

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
app_id	text	The unique ID of the Amplify app.
arn	text	The Amazon Resource Name (ARN) of the Amplify app.
auto_branch_creation_config	jsonb	Describes the automated branch creation configuration for the Amplify app.
auto_branch_creation_patterns	jsonb	Describes the automated branch creation glob patterns for the Amplify app.
basic_auth_credentials	text	The basic authorization credentials for branches for the Amplify app. You must base64-encode the authorization credentials and provide them in the format user:password.
build_spec	jsonb	Describes the content of the build specification (build spec) for the Amplify app.
create_time	timestamp with time zone	Creates a date and time for the Amplify app.
custom_headers	text	Describes the custom HTTP headers for the Amplify app.
custom_rules	jsonb	Describes the custom redirect and rewrite rules for the Amplify app.
default_domain	text	The default domain for the Amplify app.
description	text	The description for the Amplify app.
enable_auto_branch_creation	boolean	Enables automated branch creation for the Amplify app.
enable_basic_auth	boolean	Enables basic authorization for the Amplify app's branches.
enable_branch_auto_build	boolean	Enables the auto-building of branches for the Amplify app.
enable_branch_auto_deletion	boolean	Automatically disconnect a branch in the Amplify Console when you delete a branch from your Git repository.
environment_variables	jsonb	The environment variables for the Amplify app.
iam_service_role_arn	text	The AWS Identity and Access Management (IAM) service role for the Amazon Resource Name (ARN) of the Amplify app.
name	text	The name for the Amplify app.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform	text	The platform for the Amplify app.
production_branch	jsonb	Describes the information about a production branch of the Amplify app.
region	text	The AWS Region in which the resource is located.
repository	text	The Git repository for the Amplify app.
repository_clone_method	text	The Amplify service uses this parameter to specify the authentication protocol to use to access the Git repository for an Amplify app. Amplify specifies TOKEN for a GitHub repository, SIGV4 for an AWS CodeCommit repository, and SSH for GitLab and Bitbucket repositories.
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.
update_time	timestamp with time zone	Updates the date and time for the Amplify app.

turbot/aws