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_created
from
  oci_database_db;

List all unavailable databases:

select
  db_name,
  id,
  lifecycle_state,
  time_created
from
  oci_database_db
where
  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_id
from
  oci_core_volume
where
  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

info

Blink's supported Steampipe version is: 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".