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:
Each cloud query action can be found under the relevant vendor’s collection.
NOTE
Pay attention to the version of the supported plugins, and be aware of the features supported by this version.
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: