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

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

Run AWS Cloud Query

v0.76.0

Run Azure Cloud Query

v0.31.0

Run GCP Cloud Query

v0.26.0

Run GitHub Cloud Query

v0.19.0

Run Kubernetes Cloud Query

v0.10.0

Run Oracle-Cloud Infrastructure Query

v0.17.2

Run CrowdStrike Cloud Query

v0.2.0

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

Run CSV Query

v0.4.1

Run Terraform Files Query

v0.2.0