Skip to main content

​
Background​

The Run Oracle Cloud Infrastructure Cloud Query Action performs Steampipe queries on Oracle-Cloud Infrastructure resources with a powerful and simple PostgreSQL syntax. For example, listing all dbs in your Oracle Cloud database and their basic info can be don simply: 
select  db_name,  id,  lifecycle_state,  time_createdfrom  oci_database_db;
List all unavailable databases: 
select  db_name,  id,  lifecycle_state,  time_createdfrom  oci_database_dbwhere  lifecycle_state <> 'AVAILABLE';
A query to list volumes created in the root compartment: 
select  id as volume_id,  display_name,  lifecycle_state,  tenant_id,  compartment_idfrom  oci_core_volumewhere  compartment_id = tenant_id;
A full description of all existing tables and official examples are provided here:
Blink supports this Steampipe version: v0.17.2.

​
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
⌘I