AWS Cloud Query

Background

The Run AWS Cloud Query Action performs Steampipe queries on AWS resources with a powerful and simple PostgreSQL syntax.

For example, a complicated action such as fetching all of your EC2 instances IDs in AWS across all regions can be done simply:

select instance_id from aws_ec2_instance

To check if MFA is enabled for all users in an AWS account, use the following query:

select
  title,
  create_date,
  mfa_enabled
from
  aws_iam_user

A query that fetches a list of AWS S3 buckets with disabled logging might look like this:

select
  arn as resource,
  case
    when logging -> 'TargetBucket' is null then 'alarm'
    else 'ok'
  end as status,
  case
    when logging -> 'TargetBucket' is null then title || ' logging disabled.'
    else title || ' logging enabled.'
  end as reason
from
  aws_s3_bucket;

A full description of all existing tables and official examples are provided here:

• The Official AWS Plugin Documentation
• The Blink Automation Library

info

Blink's supported Steampipe version is: v0.92.1.

Action Parameters

Parameter	Description
SQL statement	The SQL statement we wish to use to query the resource.
Output format	Representation of the output result. The possible options are "Table", "CSV" or "JSON".