OCI Cloud Query - BlinkOps Documentation

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

Parameter	Description
SQL statement	The SQL query to execute against database resources. Use standard SQL syntax.
Output format	The representation of the output result. The possible options are “Table”, “CSV” or “JSON”.

Overview Get Instance

⌘I

​Background​

​Action Parameters​

Background

Action Parameters