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.
Parameter | Description |
---|---|
SQL statement | The SQL statement we wish to use to query the resource. |
Output format | Representation of the output result. The possible options are “Table”, “CSV” or “JSON”. |
Was this page helpful?