OCI Cloud Query

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:

• The Official OCI Plugin Documentation
• The Blink Automation Library

Blink supports this Steampipe version: v0.17.2.

Action Parameters​

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