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_enabledfrom  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 reasonfrom  aws_s3_bucket;

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

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

Action Parameters

ParameterDescription
SQL statementThe SQL statement we wish to use to query the resource.
Output formatRepresentation of the output result. The possible options are “Table”, “CSV” or “JSON”.