​
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’s supported Steampipe version is: 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”.

Was this page helpful?

Run OCI CLI ScriptGenerate Oracle Cloud Infrastructure Steampipe Report