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 query to execute against AWS cloud resources. Use standard SQL syntax.
RegionsAWS regions to target for the query.

This parameter supports multiple formats:
• All regions: * (default)
• Single region: us-east-1
• Multiple specific regions: us-east-1,eu-west-1,ap-southeast-2
• Wildcard patterns: us-* (all US regions), eu-* (all EU regions)
• Pattern matching: us-??st-1 (matches us-east-1, us-west-1)
Output FormatThe representation of the output result.
AWS Plugin VersionThe Steampipe AWS plugin version used to execute the query. Different versions may support different AWS services and features.
Environment VariablesEnvironment variables, defined as key-value pairs, to pass to the query execution context.
RunAWSCloudQuery