Skip to main content

​
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”.
RunAWSCloudQuery