Skip to main content

Run Cloud Query Actions

Cloud/file query Actions perform Steampipe queries on resources with a powerful and simple PostgreSQL syntax.

For example, a complicated action such as fetching all of your EC2 instance IDs in AWS across all regions can be done simply by running the "Run AWS Cloud Query" action and the following query:

select instance_id from aws_ec2_instance

Each cloud query action can be found under the relevant vendor's collection.

Supported plugins

note

Pay attention to the version of the supported plugins, and be aware of the features supported by this version.

File Identifiers With Cloud Queries

Some plugins, such as the Run CSV Query or Run Terraform Files Query, receive a File Identifier parameter, which allows them to query data from a compressed file/folder. The File Identifier can be obtained by running the Create Archive action.

For example, in order to query data from a CSV:

  1. Download the csv (using cURL or a Download File action)/Clone the repository containing it using the Git Clone action.
  2. Create an archive of the cloned repo / downloaded file using the Create Archive action.
  3. Using the Variable Picker, select the file identifier created in the previous step, and pass it as a Parameter to the Run CSV File Query Action.
Thumbnail
Thumbnail