​
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 supports Steampipe 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”.

Was this page helpful?